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 |
|
prashu1183
Starting Member
2 Posts |
 Posted - 2009-04-09 : 01:26:51
|
| Dear Friends, I need a small Favour . Once we retore a database with Set to RECOVERY. Can we change its state from RECOVERY to NORECOVERY Using SQL QUERY. Kindly me help me.Regards,Prashanth. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-04-09 : 07:28:32
|
| You'll need to restore the database again, and specify WITH NORECOVERY. |
 |
|
|
|
|
|
Db - Recovery to NORECOVERY