Post reply

Mirroring Database Failed?

  • 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

  • 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

  • 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.

  • September 22, 2005 at 9:57 am

    #592312

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply