February 12, 2003 at 12:00 pm
I backup 3 databases to a network share using jobs. I like the functionality of the maintenance plan where I can create a cutoff date after 7 days worth of backups. Problem is, I can't use the maint. plan and store to a network share (or I have not figured out how to yet). Now, using SQL Server Agent>Jobs to a backup device mapped to a network share, all I can do is create a .BAK file that will continue to grow without an expiration date.
What I would like to do is create 7 days worth of backups to a network disk and then store those 7 days to tape backup on the weekend. The following Monday, start all over again. Any advice on how to best perform this?
February 12, 2003 at 12:47 pm
When you create the maintenance plan for database backup, go to the complete backup tab, choose the disk as backup media and use UNC path as backup directory (For example, \\tordev01\q$\backupdb).
You have to use domain user who has to have the wirte access the network share to run the backup job.
February 12, 2003 at 1:21 pm
There's a three ways that I know of to backup data for 7 days to a file (.bak) and then clear that file out.
1. Create two jobs/maintenance plans. The first will run T,W,TH,F,SA,SU and will append (WITH NOINIT). The second will only run on M and will overwrite (WITH INIT).
2. Create one job/maintenance plan to do daily backups. Do the backups and first thing Monday morning, delete the .bak file.
3. Same as #2, but have your System Admin write a script that will delete the .bak file automatically on Monday morning.
-SQLBill
February 12, 2003 at 6:35 pm
Not bad. I often just use a job that uses some VBScript and the file system object to clean up old files.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply