Restoring transaction Logs - 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 transaction Logs

Author

Topic

OMB
Yak Posting Veteran

88 Posts

Posted - 2002-07-15 : 06:07:13

I am implementing log shipping using scripts between two SQl2000 servers. when i try to restore the log file it keeps on giving me the following error



[SQLSTATE 42000] (Error 3013)  The log in this backup set terminates
at LSN 4207000000683200001, which is too early to apply to the
database. A more recent log backup that includes LSN
4212000000013100001 can be restored. [SQLSTATE 42000] (Error 4326).  The step failed.

I have taken a full backup then run this step again but no joy, i have created a new backup devise, still no joy,

can anyone help!

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources