Comprehensive data protection for all workloads
Post Reply
johannesk
Expert
Posts: 146
Liked: 31 times
Joined: Jan 19, 2016 1:28 pm
Full Name: Jóhannes Karl Karlsson
Contact:

Disaster restore of SQL server

Post by johannesk »

hi

I have been challenged with a question about SQL server recovery in case of disaster.

-The OS is lost, latest backup of OS is 12 hours old.
- Latest SQL backup is 15 minutes old.

To get this SQL server up and running with RPO of 15 minutes, is there a way to do that in one step?

As far as I can see, I would need to restore the OS from 12 hours old backup. Then when that is completed, I could restore the SQL data backup from 15 minutes before the disaster.

Is there a quicker/simpler way of doing this restore in such a scenario?
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Disaster restore of SQL server

Post by foggy »

The described procedure is correct. To be able to replay transaction logs, you need to restore the entire server first.
tkarki
Lurker
Posts: 2
Liked: never
Joined: Jan 13, 2016 3:17 pm
Full Name: Tomas Karki
Contact:

Re: Disaster restore of SQL server

Post by tkarki »

Is it not possible to run an instant vm recovery from the backupfiles and replay backupfiles from there? Then you could run a vmotion to production storage.
If the load on the SQL server isn't to high I would have guessed this would be possible?
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Disaster restore of SQL server

Post by veremin »

It should be possible as well. Though, as always with instant VM recovery it all depends on the performance on the underlying storage. Thanks.
Post Reply

Who is online

Users browsing this forum: Semrush [Bot] and 148 guests