Home Forums SQL Server 2008 SQL Server 2008 High Availability How to Shring Data and Log file of Mirrored SQL Database? RE: How to Shring Data and Log file of Mirrored SQL Database?

  • October 18, 2013 at 5:22 am

    #1659650

    logicinside22 (10/17/2013)

    Hi Guys

    Looking for Steps to perfrom for shrinking Data and log files for Mirrored Database. Can any one give insturction step by step . would be great if have script too

    Thanks

    --------------------------------------------------------------------------------

    Is your mirror session synchronised, the transaction log will continue to grow if the mirror session is disconnected for example.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉