[SQL] KB 961123 - FIX: The SQL Server service stops when you run one of the DBCC CHECK commands

Full Title: FIX: The SQL Server service stops when you run one of the DBCC CHECK commands on a SQL Server 2005 database or when you create a database snapshot for a SQL Server 2005 database

SYMPTOMS

The disk space on a server that stores a Microsoft SQL Server 2005 database runs low. When you run one of the DBCC CHECK commands on the database, the memory usage increases on the server. Additionally, the SQL Server service stops.

Or, when you create a database snapshot for a Microsoft SQL Server 2005 database, the size of the database snapshot reaches the maximum size of the sparse file limitation. Then, the memory usage increases on the server. Additionally, the SQL Server service stops. This issue occurs even when you recover the database snapshot.

http://support.microsoft.com/default.aspx?scid=kb;en-us;961123

Read the complete post at http://wmug.co.uk/blogs/cliffs_blog/archive/2009/02/17/sql-kb-961123-fix-the-sql-server-service-stops-when-you-run-one-of-the-dbcc-check-commands.aspx

Published Tuesday, February 17, 2009 5:04 AM by Cliff Hobbs - FAQShop.com and Microsoft MVP ConfigMgr/ SMS
Filed under: , ,