Solve the Sybase ASE database is marked as "SUSPECT"

zhaozj2021-02-16  76

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.

转载请注明原文地址:https://www.9cbs.com/read-11511.html

New Post(0)