Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bmani27
Starting Member
5 Posts |
 Posted - 2007-08-20 : 05:30:36
|
| Hi, 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 2005Thanks in Advance |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-20 : 22:50:16
|
| You can stop and restart sql services with 'net stop' and 'net start' command in OS. |
 |
|
|
bmani27
Starting Member
5 Posts |
Posted - 2007-08-21 : 04:55:11
|
| Hi rmiao, Thanks for the reply.I cant get u clarly.My task is to use those functions to do the consistent backup of SQL server 2005. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-21 : 22:47:08
|
| Don't have to take down sql server to backup db, it's online process. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-08-30 : 10:27:52
|
| Please do not cross post.CODO ERGO SUM |
|
|
|
SteveRodgers
Starting Member
1 Post |
Posted - 2007-08-30 : 10:36:52
|
| bmani27,EMC provide some freeze/thaw functions as part of their Timefinder SQL software. We use this to make fast disk backups of our SQL Servers.I believe this is what you are referring to.Steve. |
|
|
|
|
|
|
SQL server freeze and thaw functions