.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Repair SQL database that has been marked suspect

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :Sql Server


I woke up this morning to find my company's SQL database inaccessible and marked suspect.


I have used various t-sql commands to bring it into Emergency mode.


Now it is labelled Loading\Offline\Read-Only\Emergency Mode.


I'm using SQL Server 2000


I do not have  a backup and I need to get the database up and running as soon as yesterday.



View Complete Post

More Related Resource Links

Database is looking as (Suspect/readonly/offline/emergency/)

Could not open FCB for invalid file ID 0 in database 'mssc_admin' and database is looking as (Suspect/readonly/offline/emergency/) Actually log file is not visibiling and I was trying to restore it.   PLease PLease help"SQLSERVER DBA" "INDIA"

Unable to repair index issue in database


checkdb  found issues with one of the databases

The issue has been going on longer then we have current backups, so restoring a backup will not fix the issue.

I have tried running the repair in both safe mode and data loss mode but neither process repaired anything.

I even tried scripting the removial of the foriegn keys and the primary key affected and adding them back to try and fix it but the issue is the same.

Does anyone know of anything else I can try or any tech docs to discuss how to fix this?

Here are the error messages from checkdb

Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3855, State 1: Attribute (data_space_id=1) exists without a row (object_id=1053246807,index_id=24) in sys.indexes.
CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'sys.sysidxstats' (ID 54). Data row does not have a matching index row in the index 'nc' (ID 2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (1:7120:26) identified by (id = 1053246807 and indid = 23) with index values 'name = '_WA_Sys_00000016s3EC74557' and id = 1053246807'.
Msg 8952, Level 16, State 1, Line 1
Table error: table 'sys.sysidxstats' (ID 54). Index row

Database goes to suspect mode


Hi Team,


Two days back i went one DBA interview he is asked some dba questions 


Q. we have 25 database in this one database is goes to suspect mode. How do you know x database is goes to suspect mode.


      i said we got one alert or mail x database is goes to suspect mode 


my be my answer is wrong could you any body please give me exact answer for this.


Q. we have 14 instances one instance is correpected or it goes to suspect mode how can we know x instance goes to suspect mode ?



Can you any body please guide me for this one.. i m bit confue on this my expectation instance could not goes to suspect mode right can you correct me.






Suspect SQL database


Deall All

I am getting this error message and my SQL 2005 database is showing "SUSPECT". I need to recover the transcations in the latest transcation log.

The log scan number (195881:359:1) passed to log scan in database 'XXXXXX' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.

Kindly help 

error 3316 and database in suspect mode


Hi all, 

my database fell into suspect mode. I fixed database using dbcc checkdb in emergency mode and now it seems ok. But I dont know why this incident occurs. does anybody know possible reason?

In error log I found these records:

ex_raise2: Exception raised, major=52, minor=42, state=13, severity=22, attempting to create symptom dump... followed by dump information ... and then errors 3316, 3314, 9001 (in this order)

cluster manager does not register any event about SAN outage

thanks for any answer.


SQL SERver 2000 database is in offline\suspect\Emergency mode



I m having sql server 2000 database and 4-5 database is in offline\suspect\Emergency .

I have tried that to take online throgh following step:

EXEC sp_resetstatus 'DBName'

DBCC checkdb('DBname')
DBCC CheckDB ('DBName')





From this command :

but its not coming online and multiuser then i run this command : UPDATE SYSDATABASES SET STATUS=24 WHERE NAME='DBNAME' and it comes online but whenever sql sever services get restarted it again goes into suspect mode.


Please help somebody?


'Suspect' Database



If a database is marked suspect and good backup copies of the database and TLog are available, what steps should be taken to successfully recover the database by restoring the database and Tlog backups?


Multiple database support with Entity Framework

One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

MS SQL Server: Disconnect Users From Database - Kill User Session

If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

Adding Rows in GridView without using a Database

This article describes on how to add rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in the TextBox on Button Click and retain the GridView data on post back.

Adding Multiple Columns and Rows in GridView without using a Database

This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

ASP.NET Database Tutorial

This tutorial will show you how to display data using the .NET GridView Control, ASP.NET 2.0 and VB.NET

The GridView control is a powerful tool and is simple to implement.

First, you will need to import the System.Data.SqlClient namespace.

Connestion string create any database server

This links important to how to create connection string to any data base sever.

SQL Server Database Transaction

A transaction is a group of SQL commands executed together as a single component of work to be accomplished. If all of these commands succeed, then a transaction is committed - the changes to the data are made final. If any of the commands within a transaction fail, then the entire transaction is cancelled, or in SQL Server terms, the transaction will be rolled back.

Transactions are one of the things that keep your data safe, but they're not necessarily easy to understand. Here's some help:

Database Export Wizard for ASP.net and SQL Server

A step wizard for ASP.net to export database objects to CSV, TXT, HTML, XML, or SQL. it guides users through a few simple steps to choose a database object (table, view, or query), select columns, and export the data in any of the standard formats CSV, HTML, XML, or SQL.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend