SQL Server Performance Forum – Threads Archive
DBCC commands for making it in single user modeDoes DBCC commands make the db in single user mode.If yes then how can I bring back the state of db again to earlier state as it was before running dbcc commands.
I am wondering whether running dbcc commands will forcibly kill all the users
For few DBCC checks you must specify the single-user mode before running them and if the task of single-user is handled by a DBCC statment then it will bring back the database into multi=user mode without user intervention. DBCC statements will not force the users to drop out, you must take care of this instance manually in order to avoid any overlapping or performance issues, utmost during the execution of DBCCs the performance will be low and new connections may not be accepted. BTW any specified DBCCs you’re looking in this fashion? Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.