June 2, 2008 at 7:33 am
In SQL 2000 I am able to delete files older than 2 hours. In SQL 2005 I don't see a choice for hours. I do hourly backups and don't want to keep more than 2.
June 2, 2008 at 10:59 am
Are you SP2 and above?
June 2, 2008 at 11:14 am
SP 1 Is there an SP 2 for SQL 2005?
June 2, 2008 at 11:55 am
Yes, see here:
There are also cumulative updates above and beyond SP2
"Got no time for the jibba jabba!"
-B.A. Baracus
June 2, 2008 at 1:20 pm
Before SP2 cleanup task was not working properly but there is a cleanup task befor SP2 also...
You can use dbo.xp_delete_file procedure to old files...
https://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=718788&SiteID=17
MohammedU
Microsoft SQL Server MVP
June 5, 2008 at 7:04 am
you can use job maintance plan for the same.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply