Data type MSSQL 2008R2 data size 352 MB fault detection Server A few times after the power outage database suspicious cannot attach message 1813, Level 16, State 2, line 1th cannot open the new database ' YXHIS20182 '. CREATE DATABASE abort. Msg 1813, Level 16, State 2, line 1th cannot open the new database ' YXHIS20182 '. CREATE DATABASE abort. Message 9003, Level 20, State 1, the log scan number (2732:125:21) of the log scan operation passed to database ' YXHIS20182 ' in line 1th is invalid. This error may indicate data corruption, or the log file (. ldf) does not match the data file (. mdf). If this error occurs during replication, recreate the publication. Otherwise, if the problem causes an error during startup, restore from a backup. Customer request recovery database data repair Good HISERP can be used directly. Repair results File After the use of excellent SQL database physical Repair tool to correct the consistency of the direct attach database, the installation of ERP test, the restored database is fully used, no problems. For this kind of failure to advise everyone to repair before, must copy an MDF LDF, do not come up on the brutal reconstruction log repair, good luck lost a little uncommitted transaction, rebuild the log is OK. Bad luck, after rebuilding the log you will find the system table corruption or data loss a lot, if you do not protect the original file that is the big trouble.
SQL database suspicious recovery pending recovery suspect recovery SQL database cannot attach fix additional error 9003
