configuring Mirroirng

Question

Hi Team,

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)

---

subu

Answer 1

hi subu

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

Answer 2

Hi Team,

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.

Thanks babu.

Tx

---

subu