Comprehensive data protection for all workloads
Post Reply
Regnor
Service Provider
Posts: 331
Liked: 66 times
Joined: Jan 31, 2011 11:17 am
Full Name: Max
Contact:

SQL point-in-time restore from transaction logs only

Post by Regnor » Apr 08, 2019 12:18 pm

If you do a point-in-time restore Veeam is first restoring the complete database file and afterwards it imports the transaction logs. Both is happening via network so the bandwidth is the limiting resource here.
One of our customers asked if there's any possibility to restore the complete VM via direct-SAN and after that only import the transaction logs to the restored database.
If not please count that as a feature request.

foggy
Veeam Software
Posts: 18366
Liked: 1575 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL point-in-time restore from transaction logs only

Post by foggy » Apr 09, 2019 11:42 am

Currently even if you restore the entire VM first, the database will still be restored during point-in-time restore, prior applying the logs (Veeam B&R can't just restore the VM and then immediately apply logs). This is something that we have written down for future improvements.

Regnor
Service Provider
Posts: 331
Liked: 66 times
Joined: Jan 31, 2011 11:17 am
Full Name: Max
Contact:

Re: SQL point-in-time restore from transaction logs only

Post by Regnor » Apr 10, 2019 11:18 am

Thanks Alex, this would be a great enhancement for some use cases.

Post Reply

Who is online

Users browsing this forum: No registered users and 13 guests