数据库置疑处理方法（国外英文资料）.doc

数据库置疑处理方法（国外英文资料） Set the database to a state of emergency: Then, in the SQL query analyzer, select the master database and enter the following statement execution (a single execution) Sp_configure allow, 1 Reconfigure with override Update sysdatabases set status = 32768 where name = hbposv6 Rebuild the log file (change the path to your data file path) D: \ MSSQL $PROD \ Data \ to store the path for the database files Kmjxc_log2.ldf is a new non-existing file that will be automatically created when the following statement is executed Dbcc rebuild_log ( hbposv6 , D: \ ProgramFiles \ MicrosoftSQL Server \ MSSQL \ Data \ hbposv6_log2.ldf) Cancel the emergency mode (a single execution) Update sysdatabases set status = 0 where name = hbposv6 Restore the database hbposv6 with recovery Sp_configure allow 0 Reconfigure with override 4. Restart the SQL server Solution 1: you can fix this with the following code: USE the MASTER The GO SP_CONFIGURE ALLOW UPDATES, 1 RECONFIGURE WITH OVERRIDE The GO UPDATE SYSDATABASES SET STATUS = 32768 WHERE NAME = MSDB The Go Sp_dboption MSDB, single user, true The Go DBCC CHECKDB ( MSDB ) The Go Update sysdatabases set status = 28 where name = MSDB The Go Sp_configure allow updates, 0 Reconfigure with override The Go Sp_dboption MSDB, single user, false The Go Solution 2: MSDB database resolution process Difficulties: cannot be deleted because the MSDB database, print out the document, additional database again, but cannot call MSDB new additional database, which is not of the same name, ran into trouble. 1: stop the entire database and paste the file msdbdata.mdf and msdblog.ldf from the database into another directory. 2: copy the above files to another directory, which means duplicating them twice. 3: select the database right-click - all tasks - additional database attach copy of a backup file, the database name call MSDB1, user is SA or ADMINISTRATOR. 4: take the MSDB1 database backup and backup it as a file. My name was MSDB. BAK. Sele