SQL Server Performance

Mirroring issue

Discussion in 'SQL Server 2005 Log Shipping' started by contactjimmyus, Feb 29, 2008.

  1. I have a server whose databases are mirrored to a stand by server.I wish to take a full backup of a database does it affects the mirroring process any way.
    ie does it clears the transaction log ?
    Thanks a lot for ypur suggestions
  2. dineshasanka Moderator

    Make another log backup and apply to the other server to activate mirroring
  3. satya Moderator

    Is that going to be ongoing backup on day to day basis?
    If so then follow what Dinesh suggested, if its one-off then it is ok to take full backup.

Share This Page