1.

Does Dbcc Checkdb Requires Db To Be In Single_user Mode?

Answer»

Yes and No. This is tricky question. If you are using repair option with CHECKDB then you have to have the DB in single user mode. Following is the METHOD to have your DB in a single user mode.

Use master
GO sp_dboption dbname, single, true

Following is the error which you get when you RUN the DBCC CHECKDB with repair option WO having the DB in single user mode. The same is true for DBCC CHECKDB ALSO

Yes and No. This is tricky question. If you are using repair option with CHECKDB then you have to have the DB in single user mode. Following is the method to have your DB in a single user mode.

Use master
go sp_dboption dbname, single, true

Following is the error which you get when you run the DBCC CHECKDB with repair option wo having the DB in single user mode. The same is true for DBCC CHECKDB also


Discussion

No Comment Found

Related InterviewSolutions