Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
menu search
person
Welcome To Ask or Share your Answers For Others

Categories

My database was unexpectedly went into suspect mode. After analyzing I found that this is because of the log issue. So, I rebuild the log once again. After rebuilding the log file, I ran the SQL command DBCC CHECKDB(MYDATATBASE).

It throws some errors so I tried to repair the database by using the following command

DBCC CHECKDB (MYDATATBASE, REPAIR_ALLOW_DATA_LOSS) 
WITH NO_INFOMSGS, ALL_ERRORMSGS;

The above command executed with the below following errors:

CHECKDB found 0 allocation errors and 218 consistency errors in table 'MYDATATBASE' (object ID 1509580416).

CHECKDB found 0 allocation errors and 1625 consistency errors in database 'CORRESPONDENCE'.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
1.1k views
Welcome To Ask or Share your Answers For Others

1 Answer

Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
...