Post reply

Shrink log file in a specific database which in Mirror/Synchronized/Restoring state

  • August 12, 2015 at 10:09 pm

    #303279

    Hi All,

    I wonder how do I shrink log file in a specific database which in Mirror/Synchronized/Restoring state

    So that database is in Mirror server ( High availability )

    Log file is so big ( 155 GB )

    I am looking forward your feedback . I really appreciate it

    cheers

  • August 13, 2015 at 2:47 am

    #1819576

    The DBCC SHRINKFILE command will be mirrored from the principal to the mirrored database. I think you can just shrink the principal database!

  • August 13, 2015 at 5:24 am

    #1819613

    Thx for the reply ...much appreciate it !

    Nah that what i wanted to do actually ..but i see principal database also at status syncronize / restoring ...

    Any idea?

    I am thinking to stop mirroring , shrink it .

    What do u think ?

  • August 13, 2015 at 7:43 pm

    #1819931

    You can't shrink log on mirrored db directly without removing mirror.

    I think You should do log backup on the principle server regularly so that the log space can be reused.

    have U shrunk the principle server before?

  • August 13, 2015 at 7:51 pm

    #1819933

    I just shrank log file in principal last nite 😀

    I pause mirror session , shrank , and continue mirroring

    It worked well 😀

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply