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 |
|
Pidi
Starting Member
5 Posts |
 Posted - 2006-03-10 : 14:19:24
|
| If you restore a database by RESTORE DATABASE ... NORECOVERY RESTORE LOG ... NORECOVERY RESTORE LOG ... NORECOVERY RESTORE LOG ... NORECOVERY ....Incedently you forget to use RECOVERY on the last RESTORE, but there are no more LOGS to restore - what could on do?Does this really mean, that you have to restart with the full backup and restore all files again?I couldn´t find a way, to set a "loading" (I got it all in German) database Online or Ready or whatever its called.Thanks in advance for any hintPidi |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-10 : 14:36:43
|
| You just restore the last tlog again but specify WITH RECOVERY.Tara Kizeraka tduggan |
 |
|
|
Pidi
Starting Member
5 Posts |
Posted - 2006-03-10 : 14:59:50
|
| Great - thanks a lot. I was sure, a LOG wouldn´t be accepted a second time.Should have tried it ...PidiNew owner of SQl Server for Navision |
|
|
|
|
|
|
Forgotten RECOVERY on last RESTORE line