bmani27


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




Re: Freeze and Thaws functions in SQL server

Sue Hoegemeier


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:

http://www.microsoft.com/downloads/details.aspx familyid=416f8a51-65a3-4e8e-a4c8-adfe15e850fc&displaylang=en

-Sue






Re: Freeze and Thaws functions in SQL server

Manig

Thanks Sue.

My task is similar to what u said.Can u give links for some more materials






Re: Freeze and Thaws functions in SQL server

Manig

Hi Sue,
I have gone through the specification. But it is concerned with taking backup with snapshot or without snapshot. My Task is to only freeze and thaw the SQL server. Is there a way to do that




Re: Freeze and Thaws functions in SQL server

Buck Woody - MSFT

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






Re: Freeze and Thaws functions in SQL server

Manig

Hi Woody,
Thanks for the reply. I want to do the backup of SQL server. I want the backup to be consistent. So before starting the backup i want to freeze the DB and once i finish i want to thaw it.I read the Microsoft SQL server virtual backup specifications. It is concerned with taking backup of the DB using snapshot or without using snapshot.I dont want the sanpshot to be created. I just want to frreeze it and i will take the backup ( with ot without snapshot ) . After that i want to thaw it. Is it possilble using VDI or is there some other way to do that

Thanks in Advance.




Re: Freeze and Thaws functions in SQL server

Buck Woody - MSFT

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