Restore failed in logshipping process

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

General SQL Server Forums

New to SQL Server Programming

Restore failed in logshipping process

Author

Topic

thugs
Starting Member

13 Posts

Posted - 2007-07-06 : 01:32:47

Hai,

I created log shipping btw two servers using maintenance plan.

maintainanace plan taking the log backups and copying those backups in the standby server but unable to restore thos log backups

i am getting the following error ( for the Log Restore job)
Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

In the logshipping monitor history i found the follwing error
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4305: [Microsoft][ODBC SQL Server Driver][SQL Server]The log in this backup set begins at LSN 4830000001442600001, which is too late to apply to the database. An earlier log backup that includes LSN 4828000001884200001 can be restored.
[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-06 : 10:55:42

Seems you are missing some log backup files. Stop log shipping jobs for the db, do full backup on source and restore it on target then resume log shipping.

thugs
Starting Member

13 Posts

Posted - 2007-07-09 : 04:20:14

I had a Small doubt regarding Logshipping

I implemented Logshipping on a database which is already being backed up different maintanance plan (including Transactional Log backup also)

I don't now whether this maintenance plan creates any problem or not?

Maintenance plan1 - full backup on each day
And log backups for each hour

According to my Logshipping maintenance plan
i am taking full backup on sunday and log backups twice each day.

this is the situation

Can anyone please help me out in this

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-09 : 10:46:38

Don't backup log in other plans if you like to implement log shipping.

thugs
Starting Member

13 Posts

Posted - 2007-07-10 : 02:58:11

thanks for ur replies rmiao

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources