How to do maintenance clean up plan to delete files older than 2 hours?

Question

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 739565 More actions · Answer 1

SSC Guru

Points: 739565

June 2, 2008 at 10:59 am

Are you SP2 and above?

jim-687515 Grasshopper Points: 22 More actions · Answer 2

Grasshopper

Points: 22

June 2, 2008 at 11:14 am

SP 1 Is there an SP 2 for SQL 2005?

the__t Hall of Fame Points: 3260 More actions · Answer 3

Yes, see here:

There are also cumulative updates above and beyond SP2

"Got no time for the jibba jabba!"
-B.A. Baracus

MohammedU SSCoach Points: 19644 More actions · Answer 4

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...

MohammedU
Microsoft SQL Server MVP

satya-619607 SSC Journeyman Points: 92 More actions · Answer 5

SSC Journeyman

Points: 92

June 5, 2008 at 7:04 am

you can use job maintance plan for the same.