Mirroring Database Failed?

• Thinh Ho

  SSC Veteran

  Points: 230

  More actions

  September 19, 2005 at 8:25 am

  #165327

  I did on the principal instance:

       alter database TCRS set recovery full

       backup database TCRS to disk = 'D:\TCRS.BAK' with format

  then restore on mirror instance:

       restore database TCRS from disk = 'D:\TCRS.BAK' with norecovery

  and start mirroring and received error as follows:

  "Insufficient transaction log data to preserve a 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 (Error: 1478)"

  Any opinion or help is very appreciated

• Thinh Ho

  SSC Veteran

  Points: 230

  More actions

  September 20, 2005 at 7:46 am

  #591317

  Thanks! It worked now.

  On the principal, I did:

       backup transaction <database> to disk = 'd:\db_log.bak'

  On the mirror, I did:

       restore transaction <database> from disk = 'd:\db_log.bak'

       with NORECOVERY

  Start mirrroring again, and it worked.

  Thanks all who put thoughts toward this!

  Thinh Ho

• vambati

  SSCrazy

  Points: 2769

  More actions

  September 22, 2005 at 9:56 am

  #592311

  Its just that the mirror will be getting contineous feed from principle that's the reason to have it in 'NORECOVERY' mode.

  Cheers,

  Babu.

• vambati

  SSCrazy

  Points: 2769

  More actions

  September 22, 2005 at 9:57 am

  #592312

  My bad. Sorry u had that in the code - Babu.