Disaster restore of SQL server

[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]

The described procedure is correct. To be able to replay transaction logs, you need to restore the entire server first.

[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]

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