There has been an issue in Microsoft SQL Server 2005 SP2. If you installed Microsoft SQL Server 2005 SP2, that you downloaded before March 05, 2007 and created or updated cleanup tasks in your maintenance plans, then you could encounter different runtimes, because SQL Server interpretes intervals wrong.
If you installed SQL Server Service Pack 2 on your system, then download the critical update and apply it on your SQL Server. After restarting the computer, SP2a is active. You must check your tasks' running intervals again.
If you haven't install SQL Server Service Pack 2 yet, then you could check the service pack 2 page and download the updated service pack 2 for your system.
For detailed info, look at the knowledge base item.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment