SQL 2005 and Mirroring

[qsac]

Any suggestions on how to keep the TLog from growing out of control on the Principal of a mirroring pair?

Can i use traditional TLOG backups? If so, do i need to pause the mirroring?

Any thoughts or insight would be appreciated.

Thanks
Q

 

[mrdenny]

Yes you can use traditional Transaction Log backup techniques when using Mirroring. Nothing needs to be done to the mirroring to do the backups.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog