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)
View Complete Post