In SQL server Database mirroring, I need to bring down the Mirror server for maintenance for 2 hours. However If I have a transaction log backup on the Primary database running every 15 mins, Will database mirroring still work, when the mirror server comes back up? Or will the LSN be out of sync due transaction being truncated after log backup?
Assuming I didn't pause the mirroring
However If I have a transaction log backup on the Primary database running every 15 mins, Will database mirroring still work, when the mirror server comes back up? Or will the LSN be out of sync due transaction being truncated after log backup?
Transaction log backup on principal server would NOT affect database mirroring in any way. As a fact it is recommended to take frequent transaction log backup for database which has participated in mirroring.
Dont confuse it with log shipping which involves taking transaction log backup and moving it to secondary server. In mirroring there is NO transaction log backup but Movement of Log information from principal to mirror. This would not be affected in any way by transaction log backup.
LSN comes into picture when you are taking transaction log backup, which you do in log shipping. In mirroring we just have transfer of log information