I saw in some websites that there are functions freeze and thaw in SQL server.I want to freeze the SQL server for some time and then use the thaw to unfreeze.I want to know how it could be done in SQL server 2005
Thanks in Advance
SQL Server Tools General
I saw in some websites that there are functions freeze and thaw in SQL server.I want to freeze the SQL server for some time and then use the thaw to unfreeze.I want to know how it could be done in SQL server 2005
Thanks in Advance
Are you referring to doing a freeze I\O for backups If so, it's documented in the VDI specs. Not really something to just play around with - it's generally used for writing third party backup programs. You can download the specs from:
-Sue
Thanks Sue.
My task is similar to what u said.Can u give links for some more materials
I'm not certain what you're referring to here - do you mean just to stop a database in it's current state but leave the data accessible If so, just set the database to "Read Only" when you want to stop data flowing in, and set it back off when you're ready to "unfreeze" it again.
Buck Woody
Microsoft SQL Server Team
I see what you need now. Since we guarentee consistency as of the end of the backup and not the start, I would recommend either terminating all connections, or using the read-only setting if you still need the data accessible.
- Buck