Availability for the Always-On Enterprise
Post Reply
kubimike
Expert
Posts: 312
Liked: 37 times
Joined: Feb 03, 2017 2:34 pm
Full Name: MikeO
Contact:

SQL Restore Scenario

Post by kubimike » Feb 23, 2017 3:26 pm

Hi there. Want to just throw this out there before I actually try it out so I understand how the process works.

Servers:
Veeam server is 9.5 + SP1 has SQL 2012 Express (Limited to 10GB db)
Protected VM has SQL server 2008 (Full edition) + Windows 2008 R2

Scenarios:
1. If I do a point in time recovery using the full edition of SQL on the remote VM, will the Veeam software need to copy the DB files temporarily location IE 'C:\VeeamFLR' on the remote server its restoring to? Or will it just copy the files to the destination drive of my choosing and mount the database ?

2. When doing a SQL restore using 'Restore to current restore point' I assume it will just copy the database files to the destination drive of my choosing on the protected machine and not need to use the full edition of SQL to accomplish this. After the file copy is done it will mount the DB.

3. What method is used for copying this data? I read somewhere that it was an iSCSI connection to the Protected machine

Mike Resseler
Veeam Software
Posts: 4668
Liked: 498 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: SQL Restore Scenario

Post by Mike Resseler » Feb 23, 2017 3:39 pm

Hi Mike,

1. The explorer will grab the database files from the SQL Server's backup and mount it to SQL server. This can be the target server or a staging server. (depends on your restore scenario)
2. Correct. Only the database files
3. That is correct. To create a mount point we use the iSCSI protocol. This is not persistent. It will go away after the restore process

Hope it helps
Mike

kubimike
Expert
Posts: 312
Liked: 37 times
Joined: Feb 03, 2017 2:34 pm
Full Name: MikeO
Contact:

Re: SQL Restore Scenario

Post by kubimike » Feb 23, 2017 3:46 pm

@mike thanks. So if the target and staging server is the same where exactly is it staging the files at?

Mike Resseler
Veeam Software
Posts: 4668
Liked: 498 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: SQL Restore Scenario

Post by Mike Resseler » Feb 23, 2017 4:03 pm

In most cases you will see that the SQL server that comes with VBR will be used because you will most likely use the Veeam Explorer from that server and the mount operation is done there

kubimike
Expert
Posts: 312
Liked: 37 times
Joined: Feb 03, 2017 2:34 pm
Full Name: MikeO
Contact:

Re: SQL Restore Scenario

Post by kubimike » Feb 23, 2017 4:41 pm

Well my DB is larger then 10 GBs so not sure how that will work ?

Mike Resseler
Veeam Software
Posts: 4668
Liked: 498 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: SQL Restore Scenario

Post by Mike Resseler » Feb 23, 2017 5:15 pm

In that case you need to configure a staging server as your local SQL server with VBR is Express.

Details can be found here: https://helpcenter.veeam.com/docs/backu ... tml?ver=95

kubimike
Expert
Posts: 312
Liked: 37 times
Joined: Feb 03, 2017 2:34 pm
Full Name: MikeO
Contact:

Re: SQL Restore Scenario

Post by kubimike » Feb 27, 2017 4:11 pm

@mike thanks for helping but that doesn't really tell me anything honestly. I guess I'll just have to try it and see what happens

v.Eremin
Veeam Software
Posts: 15077
Liked: 1133 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL Restore Scenario

Post by v.Eremin » Feb 27, 2017 5:36 pm

As VB&R by default goes with SQL Express, it cannot restore dbs exceeding 10 GB. So, a full blown SQL server is needed here. If you have any, specify it as a staging server.

Post Reply

Who is online

Users browsing this forum: hareshgc and 47 guests