Shrinking Principal server's LOG.

• Joy Smith San

  SSC-Insane

  Points: 24877

  More actions

  September 30, 2011 at 1:00 am

  #248663

  Hi All,

  I backed up the log of a principal server and executed the command to shrink the file.

  But it's not getting shrunk. I just searched in the forum and nothing worked for me.

  I would like to shrink the file without pausing or removing the mirroring.

  I feel that if I change recovery mode to Simple it might work. But I dont want to disrupt the mirroring.

  Thanks in advance.

  Smith

• jshailendra

  SSCrazy

  Points: 2260

  More actions

  September 30, 2011 at 1:31 am

  #1388707

  Until there are open/active transactions using the VLFs at the end of transaction log file, the shrink will not release the space.

• Joy Smith San

  SSC-Insane

  Points: 24877

  More actions

  September 30, 2011 at 2:07 am

  #1388720

  jshailendra (9/30/2011)

  ---

  Until there are open/active transactions using the VLFs at the end of transaction log file, the shrink will not release the space.

  Thanks for the quick response.

  How to check that..?

• SQLArcher

  SSC Eights!

  Points: 950

  More actions

  September 30, 2011 at 2:35 am

  #1388729

  Hi,

  You can execute the following command:

  SELECT NAME,log_reuse_wait_desc FROM sys.databases

  This will tell you what the log is doing i.e. replication, T-Log backups, etc.

  You can also read my post on VLF's here.

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  September 30, 2011 at 2:40 am

  #1388730

  Please go through following MSDN articles before you take any action.

  Transaction Log Truncation:

  http://msdn.microsoft.com/en-us/library/ms189085.aspx

  Factors That Can Delay Log Truncation:

  http://msdn.microsoft.com/en-us/library/ms345414.aspx

  Shrinking the Transaction Log:

  http://msdn.microsoft.com/en-us/library/ms178037.aspx