Deleting old backup files -- sql server new users

sql server new users : Deleting old backup files

Steve Gr
1/26/2007 9:49:46 AM

Hi,

I want to make a maintenance plan to remove old .bak and .trn files. (SQL
2005 on W2K3 R2 std edition)
I have lots of databases which are all backing up into separate folders. The
Maintenance Cleanup Task is not very versatile! It seems I have to set up a
separate task for each folder and each type of backup file. Is this right?
Is there any way I can make one task search subfolders as well? Or even put
more than one file type into the plan? At least that would reduce the number
of jobs by half.

Thanks in advance

Steve

Andrew J. Kelly
1/26/2007 10:59:42 AM

If you are running SP1 there is an option to delete one level down in
subfolders. If you have a different extension you will need a different
task. Why not use .bak for all? Other than that you would need to write
your own code to do the deletes.

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

Steve Gr
1/26/2007 5:27:12 PM

Thanks Andrew

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

home · blog · groups

Questions? Comments? Contact the dn