Comprehensive data protection for all workloads
Post Reply
bob.baird.xedo
Enthusiast
Posts: 30
Liked: 2 times
Joined: Feb 13, 2013 12:20 pm
Full Name: Bob Baird
Contact:

Exclude SQL Server Databases

Post by bob.baird.xedo » Aug 02, 2013 10:32 am

Hi All,

We have a SQL Server VM that uses RedGate SQL Backup Pro to backup the databases (they get saved to a NAS we have on our LAN).

I also backup the VM using Veeam B&R.

My question is whether there is any way I can prevent B&R from actually saving the database files (.mdf & .ldf) as I already have a copy of these on our NAS.

We are moving away from Symantec Backup Exec, but that was a feature that was available with this product i.e. you could specify specific databases that you didn't want saved to tape.

I can't see any way with Veeam to do this, other than by excluding an entire disk.

Can anyone help at all?


Thanks,
Bob

Vitaliy S.
Product Manager
Posts: 22773
Liked: 1526 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Exclude SQL Server Databases

Post by Vitaliy S. » Aug 02, 2013 10:39 am

Hello Bob,

Veeam B&R in an image based backup solution, and you cannot exclude specific files (except for swap file) from the backup. As a workaround you may want to place your databases files on the separate disk and then exclude it from the backup job.

Thank you!

bob.baird.xedo
Enthusiast
Posts: 30
Liked: 2 times
Joined: Feb 13, 2013 12:20 pm
Full Name: Bob Baird
Contact:

Re: Exclude SQL Server Databases

Post by bob.baird.xedo » Aug 02, 2013 11:04 am

Okay, thanks for clearing that up.

As it happens, we do tend to have our .mdf & .ldf stored on separate disks, so that may work okay.

Just as a mater of interest, how would the restore of the VM handle the fact that it had been backed up without a number of disks that are actually on the live VM?

veremin
Product Manager
Posts: 16699
Liked: 1394 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Exclude SQL Server Databases

Post by veremin » Aug 02, 2013 11:20 am

Hi, Bob.

There is an option in exclusion settings called “Remove excluded disk from VM configuration”. As long as it’s ticked, there wouldn’t be any issues during restore.

Thanks.

bob.baird.xedo
Enthusiast
Posts: 30
Liked: 2 times
Joined: Feb 13, 2013 12:20 pm
Full Name: Bob Baird
Contact:

Re: Exclude SQL Server Databases

Post by bob.baird.xedo » Aug 02, 2013 3:30 pm

Okay, thanks for your help.

veremin
Product Manager
Posts: 16699
Liked: 1394 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Exclude SQL Server Databases

Post by veremin » Aug 05, 2013 7:36 am

You’re welcome. Should any additional help be needed, feel free to contact us. Thanks.

mdc
Lurker
Posts: 1
Liked: never
Joined: May 14, 2014 3:34 am
Contact:

[MERGED] File Level Exclusions

Post by mdc » May 14, 2014 3:39 am

Is there still no option to exclude file types, eg MDF or LDF in the latest versions of Veeam backup and replication??

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

Re: Exclude SQL Server Databases

Post by foggy » May 14, 2014 7:01 am

Yes, nothing has changed in this sense.

pllove
Novice
Posts: 7
Liked: never
Joined: May 24, 2013 3:45 pm
Full Name: Patrick Loveless
Contact:

Re: Exclude SQL Server Databases

Post by pllove » May 21, 2014 3:34 pm

Can we use the DB Exclusion option outlined in KB1051 to exclude db's? Our dba's have db's in standby mode that are generating errors when veeam try's to back them up. We would like to be able to exclude them without excluding the drive.

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

Re: Exclude SQL Server Databases

Post by foggy » May 21, 2014 4:02 pm

The registry setting mentioned in this article does not entirely exclude databases from backup, but excludes them from the actual VSS freeze process (they are still backed up, though without VSS).

thomas23
Novice
Posts: 4
Liked: never
Joined: Jan 15, 2015 10:12 am
Contact:

[MERGED] MS SQL Backup | select databases?

Post by thomas23 » Jan 15, 2015 10:32 am

Hi,
with veeam8 we will go to backup our databases with veeam and we will use the transactionlog-backup feature.
So far so good. Is there a way to select which database are included in this backup? There are some test-databases which is not necessary to backup.

Thank you
thomas

Vitaliy S.
Product Manager
Posts: 22773
Liked: 1526 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Exclude SQL Server Databases

Post by Vitaliy S. » Jan 15, 2015 10:42 am

This is not possible, however you may want to use a workaround that is mentioned above to skip these databases from the backup.

edgonz
Influencer
Posts: 22
Liked: 2 times
Joined: Mar 30, 2015 6:55 pm
Full Name: Ed
Contact:

[MERGED] Exclude SQL Databases from backup

Post by edgonz » Aug 19, 2015 2:58 pm

I think I found the answer to my question - how to exclude some sql databases from Veeam backup - from this link (http://forums.veeam.com/veeam-backup-re ... 17452.html ), but since this is a link from 2013 I wanted to know if this still holds true in Veeam's current release.

Thanks!

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

Re: Exclude SQL Server Databases

Post by foggy » Aug 19, 2015 3:03 pm

Ed, the last response in this thread is dated this year, so yes, this is still the case with the current release.

edgonz
Influencer
Posts: 22
Liked: 2 times
Joined: Mar 30, 2015 6:55 pm
Full Name: Ed
Contact:

Re: Exclude SQL Server Databases

Post by edgonz » Aug 19, 2015 3:12 pm

foggy wrote:Ed, the last response in this thread is dated this year, so yes, this is still the case with the current release.
Hah! You're right, I din't notice the date of the OP, thanks! :)

Post Reply

Who is online

Users browsing this forum: No registered users and 26 guests