Friday, July 27, 2012 1:56 PM
I m configuring mirroing in two databases i m getting below Error.
The mirror database, "xxx", has insufficient transaction log data to preserve the log backup chain of the principal database.
This may happen if a log backup from the principal database has not been taken or has not been restored on the mirror database.
(Microsoft SQL Server, Error: 1478)
Friday, July 27, 2012 2:37 PM
lsn (log sequnce number ) between Principle Server and mirrorired server did not match,
take a Full Backup and transaction log backup from principle server and restore it on mirrored Server
Ramesh Babu Vavilla MCTS,MSBI
- Marked As Answer by subu999 Friday, July 27, 2012 5:03 PM
Friday, July 27, 2012 5:03 PM
database was using alote of member i m doing the same full & t-log backups restoring the db.
I have configured non-business hours.. Mirroring was configured.
- Edited by subu999 Saturday, July 28, 2012 6:02 AM