Restoring a Log Backup - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Restoring a Log Backup

Author

Topic

acm
Starting Member

4 Posts

Posted - 2002-06-25 : 14:31:46

I am trying to restore a Log BackUp in (Destination server) that has been backed up in a different server (Origin) after having restored the FULL DATABASE BACKUP.

I already grabbed the DB_BackUp_Log file from the Origin server and set it up in the Destination server which is where I want to restore it and created a device for the DB_Backup_Log file with the same name.

This is the syntax used:

RESTORE LOG DB
FROM DB_BackUp_Log
WITH NORECOVERY

and the error I get is:

Server: Msg 4306, Level 16, State 1, Line 1
The 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 1
RESTORE LOG is terminating abnormally.

Please notice that this file contains log backups performed every hour since the previous midnight FULL DATABASE BACKUP.

In essence I am trying to automate the process by using FTP to grab the file and then restoring it on the Destination server. I am trying to get away from Log Shipping as what I am trying to implement is meant to be across servers that are not in the same network.

Thanks for your help.

VyasKN
SQL Server MVP & SQLTeam MVY

313 Posts

Posted - 2002-06-25 : 14:46:05

As the message is indicating, you should have restored the full database backup along with either WITH NORECOVERY or WITH STANDBY option.

Go ahead and restore the full database backup again using WITH NORECOVERY or WITH STANDBY option and then attempt the log restore.
--
HTH,
Vyas
http://vyaskn.tripod.com

Edited by - vyASKN on 06/25/2002 14:49:57

acm
Starting Member

4 Posts

Posted - 2002-06-25 : 15:00:17

Thank you for your time.

If I had read more carefuly the word 'preceding' ...

It works.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources