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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-10 : 07:26:30
|
| Ravi chandra writes "Ravi chandra - I am restore the database using device, it succesfully restored, but it shows read only, can any help in this regards....." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-11-10 : 11:02:15
|
| try sp_dboptionorrestore with recovery==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-10 : 12:26:15
|
| RESTORE WITH RECOVERY is probably what is needed. The database is waiting for additional transaction logs to be applied. If you do not have any more to apply, then just reapply the last transaction log again but specify WITH RECOVERY in your command. If you are only restoring the full backup, then you'll need to do it again and specify WITH RECOVERY as well. If you are using EM, then you'll want to go to the second tab and select the first option.Tara |
|
|
|
|
|
|
Database Read only