SQL Restore Scenario

Availability for the Always-On Enterprise

SQL Restore Scenario

Veeam Logoby kubimike » Thu 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
kubimike
Expert
 
Posts: 133
Liked: 20 times
Joined: Fri Feb 03, 2017 2:34 pm
Full Name: MikeO

Re: SQL Restore Scenario

Veeam Logoby Mike Resseler » Thu 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
Mike Resseler
Veeam Software
 
Posts: 2639
Liked: 316 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: SQL Restore Scenario

Veeam Logoby kubimike » Thu 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?
kubimike
Expert
 
Posts: 133
Liked: 20 times
Joined: Fri Feb 03, 2017 2:34 pm
Full Name: MikeO

Re: SQL Restore Scenario

Veeam Logoby Mike Resseler » Thu 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
Mike Resseler
Veeam Software
 
Posts: 2639
Liked: 316 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: SQL Restore Scenario

Veeam Logoby kubimike » Thu Feb 23, 2017 4:41 pm

Well my DB is larger then 10 GBs so not sure how that will work ?
kubimike
Expert
 
Posts: 133
Liked: 20 times
Joined: Fri Feb 03, 2017 2:34 pm
Full Name: MikeO

Re: SQL Restore Scenario

Veeam Logoby Mike Resseler » Thu 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
Mike Resseler
Veeam Software
 
Posts: 2639
Liked: 316 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: SQL Restore Scenario

Veeam Logoby kubimike » Mon 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
kubimike
Expert
 
Posts: 133
Liked: 20 times
Joined: Fri Feb 03, 2017 2:34 pm
Full Name: MikeO

Re: SQL Restore Scenario

Veeam Logoby v.Eremin » Mon 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.
v.Eremin
Veeam Software
 
Posts: 12606
Liked: 910 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 25 guests

cron