-
- 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
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.
-
- 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
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!
-
- 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
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.
-
- 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
If you're after excluding certain DB from SQL Log backup, kindly, check this KB article. Thanks.
-
- 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
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?
Who is online
Users browsing this forum: Bing [Bot], DanielJ and 142 guests