These are undocumented DBCC commands and not supported by Microsft. So please be careful while using.
If we want to suspend write operations on a DB normally we will put that DB in ReadOnly Mode.
We have one more option using undocumented commands:
DBCC FREEZE_IO(DBNAME) --- Suspends all the write operations on the specified database.
DBCC THAW_IO(DBNAME) --- Resumes the database for write operations.
No comments:
Post a Comment