November 19, 2003 at 10:52 am
I am using SQL Server 2000 SP3 (v 8.00.760) on a Windows 2000 Server. I have a backup plan set in my SQL database to APPEND to a Disk Backup File as a Complete Backup Method.
Essentially, this procedure adds each days backup to this file; providing with a unique backup number and also with a Timestamp.
Is there a way in T-SQL or through Management GUIs I can delete jobs that are prior to 1 month or prior to a certain backup identifier?
Thanks.
Naveed
November 19, 2003 at 1:26 pm
No. It's all or nothing. Delete the whole file or none of it.
One solution is to rename the backup file daily/weekly/whatever. Then when you need to delete some of the backups you aren't deleting the current ones also.
-SQLBill
November 20, 2003 at 9:32 am
I think this practice is a bad idea. If your file gets corrupt or you have some issue, you could lose a bunch of backup data. Personally I like the idea of a new file each day for this reason.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply