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 |
|
aix_tiger
Starting Member
1 Post |
 Posted - 2009-08-06 : 09:30:06
|
| GuysI know that Microsoft SQL provide freeze and thraw functions for its database ( just like begin & end backup by Oracle ) , but i dont know how to use these functions with SQL server.I want to put my SQL DB in freeze mode so that write suspends for sometime and during that time , i will use HP snapshot storage based utility to create a clone for DB and then release write IO to database .Can anybody help me , by telling the way through which i can put microsoft SQL in write suspend state for some time ?Any guide /documents will be highly appreciableThanks |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-08-06 : 09:49:08
|
I have never heard of freeze and thraw funtions. But if you want to create a copy of the database, why not just use the BACKUP command to backup the database to file ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
SQL Freeze and Thraw functions