“Recently, I ran DBCC CHECKDB command to check the consistency of SQL Database. After running that command, I noticed that the database was not showing online. To fix it, I started SQL Service but it also went in the suspect-mode. I am not able to understand why DBCC CHECKDB fails. Is there any way to resolve this issue?”
There are many scenarios SQL Server database becomes inaccessible because it is marked as Suspected. When the database is in suspected mode, user cannot access and cannot perform transaction on that data until it comes back to online mode. In addition, if the backup is not generated before database corruption, user cannot perform any action.
Most of the users of SQL Server need to deal with several issues while working with the database including corruption related problems. One of the common issue is corruption of clustered index. The data becomes inaccessible to the user when this issue occurs in MS SQL Server. Inaccessibility of the database may be the worst situation for the users working on the database. Continue reading “Effortlessly Repair Clustered Index In SQL Server”