SQL Server Performance

Interrupting LSN transaction log sequence on database mirror

Discussion in 'SQL Server 2005 Database Mirroring' started by Trev256b, Jan 15, 2012.

  1. Trev256b Member

    1) Can I take a full backup of the database on principal, without worrying about interrupting the LSN transaction log sequence? I understand all transactions are sent across to the mirror, therefore taking a full backup shouldn't affect the transaction log in terms of removing uncommitted transactions. Therefore taking a full backup on principal is ok. Is this correct?
    2) Can I take transaction log backups on the principal for the same reason?

Share This Page