locked
Re: log file size and mirroring RRS feed

  • Question

  • May I ask a question related issue? Is the participal database should be pause before shrinking?

     

    Regards,

     

    Melih

    Wednesday, September 19, 2007 2:19 PM

Answers

All replies

  • USE XXX
    GO
    CHECKPOINT
    GO
    BACKUP LOG [XXX] TO [XXX_TLOG] WITH NOFORMAT, INIT,  NAME = N'XXX-Transaction Log  Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
    GO
    DBCC SHRINKFILE(XXX_Log, 1)
    GO
    I think its not required to pause the mirroring session while shrinking
    refer http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=377087
    Wednesday, September 19, 2007 2:29 PM
  •  

    Yess, Deepak,

     

    You're right. It's not required to pause. It's working now, but after many try.

    Thank you for suggestion.

     

    Regards,

     

    Melih

    Thursday, September 20, 2007 6:25 AM