balasaukri (7/20/2013)
4. Shrinking the files in PRIMARY will reflect in SECONDARY in LS/ Mirroring. So shrink the log file in Primary.
Attempting to shrink a full log is just a waste of time. It's full, there's no space in the file to release to the OS, so why on earth would you try to shrink (release free space to the OS)?
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