- Posts: 38
- Liked: 4 times
- Joined: Feb 02, 2018 7:56 pm
- Full Name: Jason Mount
I have B&R 9.5 Enterprise with patch 4 and backing up VM running on ESXi 6.5 U2.
- Product Manager
- Posts: 5633
- Liked: 550 times
- Joined: May 19, 2015 1:46 pm
That cannot be done with VBR as VBR does not actually backs up databases. Instead, it prepares them for backup (ensure consistency), procesess transaction logs (if required). You can try using Veeam Agent for Windows in order to back up only database files (MDF and LDF).
- SVP, Product Management
- Posts: 26728
- Liked: 4281 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
Well, of course VBR does backup databases as a part of the image-level backup, which includes all files on the protected VM's disks - and SQL Server database files are of course no exception. Sorry for this misinformation by P.Tide
Also, in advanced Guest Processing we have the functionality that allows you to include only the required files into an image-level backup, such as SQL Server database files - which is exactly what you're looking for.
However, if you have your databases on separate disks (as recommended by SQL Server best practices), then the better approach will be to only include the required virtual disks in the backup job - by excluding all other disks. This will work much faster than file-level exclusions due to no added processing overhead. Most of our customers with similar requirement do that.
Also, please note that the self-service portal does provide an ability to recover individual SQL Server databases, not just entire VMs. Sounds like you were looking at the Machines tab, whereas this functionality is on the Items tab (application items).
Users browsing this forum: Google [Bot] and 18 guests