Discussions specific to the VMware vSphere hypervisor
Post Reply
jamcool
Enthusiast
Posts: 25
Liked: 4 times
Joined: Feb 02, 2018 7:56 pm
Full Name: Jason Mount
Contact:

Backing up just SQL DBs or an individual DB

Post by jamcool » Apr 06, 2019 12:17 am

Is it possible to backup just Microsoft SQL databases without having to backup a VM disk? We are looking to replace a product used for backing up SQL with Veeam's ability to backup SQL. Unfortunately in the console you have to select at least one disk and in Self Service you have to select the whole server (did a test install using trial license of Enterprise plus). The SQL DBA persons want to be able to backup just a DB or the DBs without having to backup the server.

I have B&R 9.5 Enterprise with patch 4 and backing up VM running on ESXi 6.5 U2.

PTide
Product Manager
Posts: 5416
Liked: 481 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Backing up just SQL DBs or an individual DB

Post by PTide » Apr 06, 2019 1:01 pm

Hi,

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).

Thanks!

Gostev
SVP, Product Management
Posts: 25530
Liked: 3875 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Backing up just SQL DBs or an individual DB

Post by Gostev » Apr 07, 2019 7:09 pm

P.Tide wrote:
Apr 06, 2019 1:01 pm
That cannot be done with VBR as VBR does not actually backs up databases.
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).

Post Reply

Who is online

Users browsing this forum: No registered users and 34 guests