September 6, 2007 at 4:33 pm
Hello,
Here is a question that is probably easy for you folks out there smarter than I am.
When setting up a process to clean up old backups from the SQL Server, is is better to:
1. Delete the old files and then run the new backups
2. Run the new backups and then delete the old files
It would also be great if someone could teach me how to go about getting this answer.
Thanks!
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
September 6, 2007 at 4:48 pm
Well Deleting old backup, then running new backup could be a problem if the new backup fails, and the old one was deleted, that leaves you without a backup.
If you create a sql server maintenence Plan it gives you the option to delete Backups older than (x) days old... thats a good way to do it.
I have created a job that deletes files older than 3 days old.
Unless your tape backup is pulling that fresh backup every night, its a good idea to keep a couple days laying around.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply