database tagged suspect error 926

[JustATheory]

Greetings,

I'm running a stand alone version of SQL Server 2005, and was setting up an index when, the database was taged suspect with an error 926. How is the best way to remove this tag, is it possible to do this without resorting from backup?

Any help is greatly appreciated.

Thanks,
JustATheory

 

[mrdenny]

The error means that the SQL Server couldn't access the file on the disk. Did the drive go away?

Try putting the database into emergency mode to see if it can access the files.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Blog

 

[JustATheory]

Sorry it took a while to get back, it worked and all is well.

Thanks,
JustATheory