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-27 : 02:06:36
|
| Hi, 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 don't want the snapshot to be created. I just want to freeze it and i will take the backup ( with or without snapshot ) . After that i want to thaw it. Is it possible using VDI or is there some other way to do that ? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-27 : 21:49:55
|
| That's for third party to build tools, you can't use that in regular backup. |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-08-30 : 10:29:16
|
| Please do not cross post.CODO ERGO SUM |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
|
|
|
Microsoft SQL server virtual backup specifications