The eXpress database is marked as "Suspect"

Products

• Deployment Solution

Issue/Introduction

The Deployment Server lost all connections with the SQL Server. When you open the SQL Enterprise Manager it shows the 'eXpress' DB as a 'Suspect'

 The eXpress database was marked as "Suspect'

Resolution

1- Try to Restore 'eXpress' DB from Last Known good backup
2- Noticed this issue is a Known issue with MS SQL> http://support.microsoft.com/kb/889266 BUG #: 470755 (SQL Server 8.0)
3- SQL Server eXpress database marked as "suspect" may still be an issue and suggested to Check/Repair SQL. This issue may have caused other issues with SQL Server.

4-Please run the CHECKDB procedure as outlined in the below Microsoft article:
http://msdn2.microsoft.com/en-us/library/ms176064.aspx

CHECKDB found xxx allocation errors and xx consistency errors in database 'Express'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (Express ).
********************************************************************************

	The following is provided at your responsibility to make a full database backup before proceeding. Please run the below SQL Query - this should attempt to repair the corruption in the database - some data loss can be expected: --1. Set the database in single user mode ALTER DATABASE Express SET single_user WITH ROLLBACK IMMEDIATE; GO --2. Run the DBCC command to attempt to repair corruption: DBCC checkdb ('Express', repair_allow_data_loss); GO --3.Set the database back in multi-user mode ALTER DATABASE Express SET MULTI_USER GO ---------------------------------------------------------------------------- CHECKDB fixed xx allocation errors and xx consistency errors in database 'Express'.

5-Article ID: 22953 SQL Tuning and Maintenance for the Altiris Deployment Server eXpress database. To create a Back up plan

Applies To
Deployment Server all builds

SQL 2000 and 2005