Problem setting up mirroring - 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 2008 Forums

SQL Server Administration (2008)

Problem setting up mirroring

Author

Topic

ferrethouse
Constraint Violating Yak Guru

352 Posts

Posted - 2012-09-20 : 01:41:56

I'm getting this error...

Msg 4305, Level 16, State 1, Line 1
The log in this backup set begins at LSN 338223000025098800067, which is too recent to apply to the database. An earlier log backup that includes LSN 338068000013982300001 can be restored.
Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.

The process I'm following...

1. Backup principal database
2. Restore database on mirror
3. Backup principal log file
4. Attempt to restore log file on mirror
5. Get error
6. Cry

It takes 1 hour to backup and restore the database (it is 150 gigs).

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2012-09-20 : 01:47:02

Why you want to restore the Log backup?

follow the below step by step procedure

http://sqlserver.in/blog/index.php/archive/database-mirroring-step-by-step/

Senthil Kumar C
------------------------------------------------------
MCITP - Database Administration SQL SERVER 2008
MCTS - Database Development SQL SERVER 2008

ferrethouse
Constraint Violating Yak Guru

352 Posts

Posted - 2012-09-20 : 02:04:23

quote:
Originally posted by senthil_nagore

Why you want to restore the Log backup?

follow the below step by step procedure

http://sqlserver.in/blog/index.php/archive/database-mirroring-step-by-step/

Senthil Kumar C
------------------------------------------------------
MCITP - Database Administration SQL SERVER 2008
MCTS - Database Development SQL SERVER 2008

I think you can only not use the log file if the principal server is not live. I follow the procedure here...

http://www.mssqltips.com/sqlservertip/2464/configure-sql-server-database-mirroring-using-ssms/

If I try the method you outline I get this error...

The remote copy of database "blah" has not been rolled forward to a point in time that is encompassed in the local copy of the database log.

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2012-09-20 : 02:34:46

Try this.

http://social.msdn.microsoft.com/Forums/en/sqldatabasemirroring/thread/3916b3cd-f8f1-4471-9ed9-cdb32dce242a

Senthil Kumar C
------------------------------------------------------
MCITP - Database Administration SQL SERVER 2008
MCTS - Database Development SQL SERVER 2008

ferrethouse
Constraint Violating Yak Guru

352 Posts

Posted - 2012-09-20 : 12:46:10

quote:
Originally posted by senthil_nagore

Try this.

http://social.msdn.microsoft.com/Forums/en/sqldatabasemirroring/thread/3916b3cd-f8f1-4471-9ed9-cdb32dce242a

Senthil Kumar C
------------------------------------------------------
MCITP - Database Administration SQL SERVER 2008
MCTS - Database Development SQL SERVER 2008

Thanks. I believe that helped. Either I just got lucky this time or the "NOUNLOAD" flag made the difference.

Cheers!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources