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 |
|
SQLCode
Posting Yak Master
143 Posts |
 Posted - 2005-08-22 : 17:32:52
|
| Hi all,I am trying to restore my trans log file. please help me.RESTORE LOG MyDBFROM DISK = 'e:\test\Backup\Log\MyDB_Log_20050822_113000.bak'WITH norecoveryError:Server: Msg 4306, Level 16, State 1, Line 1The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.Server: Msg 3013, Level 16, State 1, Line 1RESTORE LOG is terminating abnormally.QA:Do I have E: drive, answer is yes on the server that I am restoring.I tried looking for basic info on restore from a file on a drive on the same machine. TIA |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-22 : 17:45:57
|
| Looks like you are restoring a Transaction log backup without restoring a Full backup first (or you restored a full backup without using NORECOVERY)1) Restore Full Backup using NORECOVERY2) Restore each Transaction Backup in turn - using NORECOVERY except for the final oneKristen |
 |
|
|
SQLCode
Posting Yak Master
143 Posts |
Posted - 2005-08-23 : 08:53:49
|
| Thanks Kristen, I will try that. Yes I did not realize that I need to restore a full back up first. It is for an already existing db. |
|
|
|
|
|
|
Restore