Mirroring Database Failed?

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