Discussions specific to the VMware vSphere hypervisor
Post Reply
jamcool
Enthusiast
Posts: 62
Liked: 11 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 »

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: 6200
Liked: 673 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Backing up just SQL DBs or an individual DB

Post by PTide »

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: 29899
Liked: 5842 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 »

P.Tide wrote: Apr 06, 2019 1:01 pmThat 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).

jamcool
Enthusiast
Posts: 62
Liked: 11 times
Joined: Feb 02, 2018 7:56 pm
Full Name: Jason Mount
Contact:

Re: Backing up just SQL DBs or an individual DB

Post by jamcool »

I was looking for what's new in version 12 of VBR to see if anything changed for backing up Microsoft SQL databases. Namely looking to see if there is a way to just backup a single database and not all the databases on a Microsoft SQL server. I found this old question I raised on it when at VBR 9.5 and found this was not an option. I have not seen it any different in VBR 11 (on 11a).

Mildur
Veeam Software
Posts: 3164
Liked: 1083 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: St. Gallen, Switzerland
Contact:

Re: Backing up just SQL DBs or an individual DB

Post by Mildur »

Hi Jason

Veeam V12 will bring a Enterprise Plugin for MSSQL.
Install it on the MSSQL Server and choose which databases you want to backup.
Have a look at our VeeamOn 2022 session where we announce it.

Thanks
Fabian
Product Management Analyst @ Veeam Software

PetrM
Veeam Software
Posts: 2174
Liked: 351 times
Joined: Aug 28, 2013 8:23 am
Full Name: Petr Makarov
Location: Prague, Czech Republic
Contact:

Re: Backing up just SQL DBs or an individual DB

Post by PetrM »

Hello,

@jamcool It would be awesome to get some feedback on it :) Also, a brief overview of plug-in is provided in this blog.

Thanks!

Post Reply

Who is online

Users browsing this forum: Bing [Bot], karsten123 and 22 guests