Phenomenon: Error 926 Severity Level 14 Error Message Text
Database 'XX' Cannot Be Opened - It Has Been Marked Suspect by Recover Explanation
When you use the transact_sql command to command the data of this database, this information is a serious error. If you want to use the database data, you must correct this error. Action
Log in to SQL Server with isql, you must use SA account
1> sp_configure "allow Updates", 1 2> Go 2> Reconfigure with override 2> Go 1> Update master..xysdatabases 2> set status = -32768 3> Where name = "database_name" / * database_name is your database name * / 4> GO 1> Shutdown with NOWAIT 2> Go
At this time, restart SQL Server, and then the SA account is registered to SQL Server.
1> Update master..sysdatabases 2> set status = 0 3> Where name = "database_name" / * database_name is your database name * / 4> Go 1> sp_configure "allow updates", 1 2> Go 1> Reconfigure with Override 2> Go
If your database has DBOPTION, you need to reset these option.