mahesh.shinde (5/26/2013)
2. If output column log_reuse_wait_desc is saying LOG_BACKUP then simply take multiple time log backup of mirror database. Mostly 3 continuous T-log backup would enable db to shrink the log file with following command.DBCC Shrinkfile(2,1024)
You can't take log backups of a mirror database, the database is in the restoring state. Nor can you shrink the log of a mirror database (plus shrinking to 1MB is a poor recommendation).
Log backups and shrinks can only be done on the principal database of a mirroring configuration.
p.s. 5 year old thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability