Hello
I would like to know if it make sense to backup virtual machine disks dedicated to sql server database logs.
We have transaction log backup active; hdd dedicated to logs are very large and take a lot of time during backup and above all during backup copy to Veeam Cloud Connect.
What do you usually do?
-
- Lurker
- Posts: 1
- Liked: never
- Joined: Jun 22, 2022 2:24 pm
- Full Name: Andrea Armellini
- Contact:
-
- Veeam Software
- Posts: 3626
- Liked: 608 times
- Joined: Aug 28, 2013 8:23 am
- Full Name: Petr Makarov
- Location: Prague, Czech Republic
- Contact:
Re: database log disk
Hi Andrea and Welcome to Veeam R&D Forums!
It depends on what kind of restore scenarios do you need to cover. If you process the disk, you'll preserve all restore capabilities. For example, Instant VM Recovery might be helpful in case of full disaster as it allows you to spin up a fully functional workload directly from backup. If you don't process the disk, the only tool which will help you to restore database is Veeam Explorer for SQL and you always need to have a SQL server that can be used as a target for restore.
Thanks!
It depends on what kind of restore scenarios do you need to cover. If you process the disk, you'll preserve all restore capabilities. For example, Instant VM Recovery might be helpful in case of full disaster as it allows you to spin up a fully functional workload directly from backup. If you don't process the disk, the only tool which will help you to restore database is Veeam Explorer for SQL and you always need to have a SQL server that can be used as a target for restore.
Thanks!
Who is online
Users browsing this forum: No registered users and 43 guests