locked
SQL Server 2005 (X64) Maintenance Clean Up Task Using Hours Option for File Age RRS feed

  • Question

  • I'm running into an issue with SQL Server 2005 64-bit and the maintenance clean up tasks.  I have it set up to delete any transaction logs or backups older than 12 hours.  It seems that there could be some sort of bug because, according to the log files, SQL is running the clean up for 12 days instead.  I've created a work around for this by using execute transact-sql tasks instead, but was wondering if there's a problem with my version of SQL Server, like an SP or patch that I've overlooked.

    Here's my version information: Microsoft SQL Server 2005 - 9.00.1399.06 (X64)   Oct 14 2005 00:35:21   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

    Thursday, September 16, 2010 1:45 PM

Answers

  • Correct there is a bug you need SP2 + KB933508; ideally you should install SP3 and you should be good.
    • Proposed as answer by Amit Banerjee Thursday, September 23, 2010 9:28 AM
    • Marked as answer by Alex Feng (SQL) Thursday, September 23, 2010 12:13 PM
    Thursday, September 16, 2010 3:41 PM