Database is suspicious

zhaozj2021-02-16  72

// Newly create a database (file name, file group, and originally the same), then stop the database service, replace the number of new // built with the original file

According to the library file, start the database, the database is set to SUSPECT

Change the database to emergency mode: sp_configure 'allow', 1Reconfigure with overrideUpdate sysdatabases set status = 32768 where name = 'Database name

Remify the LDF file, then execute DBCC Rebuild_Log ('Database Name,' E: /FDZZ/Database/fdzz1204_log.ldf ')

Recovery Database Emergency Mode Update SysDatabases Set Status = 0 Where name = 'Database name' Execute Restore Database Database name with recoverysp_configure 'allow', 0Reconfigure with override

Then use DBCC Checkdb ('Database Name') to see if there is any error

If you still can't do it above, try the database to set up the data, you should be able to see the data, export data to a new database.

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

New Post(0)