Comprehensive data protection for all workloads
Post Reply
VanillaMastermind
Enthusiast
Posts: 37
Liked: 7 times
Joined: Nov 23, 2015 4:47 pm
Full Name: VanillaMastermind
Contact:

SQL Server - Back up a single database with long retention

Post by VanillaMastermind »

I have regular backup jobs established for my SQL Servers along with application-aware processing for transaction log backups. If I want to do an extra backup of a database only, such as once a month with a 10 year retention, how would I go about doing that? I am only interested in the database backups for this period, not the filesystem or the server itself.
Gostev
Chief Product Officer
Posts: 31804
Liked: 7298 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL Server - Back up a single database with long retenti

Post by Gostev »

Hi, I would setup a separate monthly job, and exclude all VM disks except the one containing the database, and then select only required database files to be backed up from this remaining disks using v9 file exclusion functionality. Thanks!
rntguy
Enthusiast
Posts: 82
Liked: 1 time
Joined: Jan 29, 2016 8:31 pm
Full Name: Rnt Guy
Contact:

Re: SQL Server - Back up a single database with long retenti

Post by rntguy »

this is old, but so the way you only back up certain databases is by using file level exclusions? seem unrelated and I would think you could choose certain databases.
veremin
Product Manager
Posts: 20400
Liked: 2298 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL Server - Back up a single database with long retenti

Post by veremin »

If you're after excluding certain DB from SQL Log backup, kindly, check this KB article. Thanks.
rntguy
Enthusiast
Posts: 82
Liked: 1 time
Joined: Jan 29, 2016 8:31 pm
Full Name: Rnt Guy
Contact:

Re: SQL Server - Back up a single database with long retenti

Post by rntguy »

Thank you. Is this the same for Exchange Databases where they're all on the same drive but certain ones you don't want to backup?
Post Reply

Who is online

Users browsing this forum: Bing [Bot], DanielJ and 142 guests