I recently set up SQL 2005 database mirroring (synchronous with witness) on a couple of environments and enjoyed the experience but have a few questions:
- Does the transaction log chain get broken when a fail-over occurs? Do I need to schedule a full backup to continue transaction log backups on the secondary server?
- I've noticed that DBCC CHECKDB is executed during a fail-over, does anyone know what options are specified? will this impact VLDBs?
- The mirroring endpoints seem to be tied into my domain account I was using whilst configuring mirroring through the wizard. Will mirroring fail if my domain account is ever removed? Should I alter the endpoints to use the server's domain service account?