Forum Replies Created

Viewing 15 posts - 916 through 930 (of 3,738 total)

  • RE: Log File Size does not shrink

    Revenant (1/23/2014)

    Welsh Corgi (1/23/2014)

    GilaMonster (1/23/2014)

    Welsh Corgi (1/23/2014)

    GilaMonster (1/23/2014)

    Welsh Corgi (1/23/2014)

    GilaMonster (1/22/2014)

    btw, going through the GUI to shrink the log runs DBCC ShrinkFile, there's no difference between running the command from...

    January 23, 2014 at 4:00 pm

    #1682962

  • RE: Log File Size does not shrink

    GilaMonster (1/23/2014)

    Welsh Corgi (1/23/2014)

    GilaMonster (1/22/2014)

    btw, going through the GUI to shrink the log runs DBCC ShrinkFile, there's no difference between running the command from a script or the GUI.

    By going...

    January 23, 2014 at 3:28 pm

    #1682958

  • RE: Log File Size does not shrink

    GilaMonster (1/23/2014)

    Welsh Corgi (1/23/2014)

    GilaMonster (1/23/2014)

    Welsh Corgi (1/23/2014)

    GilaMonster (1/22/2014)

    btw, going through the GUI to shrink the log runs DBCC ShrinkFile, there's no difference between running the command from a script or...

    January 23, 2014 at 3:16 pm

    #1682955

  • RE: Log File Size does not shrink

    GilaMonster (1/23/2014)

    Welsh Corgi (1/23/2014)

    GilaMonster (1/22/2014)

    btw, going through the GUI to shrink the log runs DBCC ShrinkFile, there's no difference between running the command from a script or the GUI.

    By going...

    January 23, 2014 at 2:56 pm

    #1682951

  • RE: Log File Size does not shrink

    GilaMonster (1/22/2014)

    btw, going through the GUI to shrink the log runs DBCC ShrinkFile, there's no difference between running the command from a script or the GUI.

    By going through the GUI...

    January 23, 2014 at 11:34 am

    #1682887

  • RE: Log File Size does not shrink

    Another command that was very useful in helping me understand what was going on was the following:

    DBCC LogInfo

    January 23, 2014 at 10:08 am

    #1682863

  • RE: Log File Size does not shrink

    I found the following command very useful as to what exactly preventing the log file from shrinking:

    SELECT log_reuse_wait_desc, * FROM sys.databases

    January 23, 2014 at 9:26 am

    #1682848

  • RE: Log File Size does not shrink

    GilaMonster (1/22/2014)

    Welsh Corgi (1/22/2014)

    Another backup, that log file has not changed in size.

    No, it won't. Log backups do not shrink the file. Though, if it hasn't changed in size that...

    January 22, 2014 at 3:05 pm

    #1682602

  • RE: Log File Size does not shrink

    Another backup, that log file has not changed in size.

    Next backup in 4 minutes.

    Turned off shrinking.

    I do not agree with shrinking either.

    January 22, 2014 at 8:25 am

    #1682438

  • RE: Log File Size does not shrink

    The Transaction Log File was backed up 3 minutes ago.

    Right after the backup the transaction log file was over 5 GB.

    January 22, 2014 at 8:03 am

    #1682424

  • RE: Log File Size does not shrink

    GilaMonster (1/22/2014)

    You shouldn't even be shrinking the log. If the log is growing, make the log backup more frequent or identify what is causing the log growth and resolve it.

    btw,...

    January 22, 2014 at 7:59 am

    #1682419

  • RE: Log File Size does not shrink

    Keith Tate (1/21/2014)

    I would stop shrinking the log file. If you want to keep the size of the file smaller take your tlog backups more often than once an hour....

    January 22, 2014 at 6:46 am

    #1682373

  • RE: Log File Size does not shrink

    GilaMonster (1/21/2014)

    What is the exact command you are using to backup the log (or if a maintenance plan, what are the exact options)?

    The T-SQL Code from the Maintenance Plan is...

    January 22, 2014 at 6:42 am

    #1682369

  • RE: Log File Size does not shrink

    Keith Tate (1/21/2014)

    LOG_BACKUP

    I do not understand what is going on.

    This means that it is waiting on a transaction log backup

    If I do the backup in SQL Code how do I...

    January 21, 2014 at 7:16 pm

    #1682242

  • RE: SSIS password problem connecting to AS/400

    bsantosh6 (1/21/2014)

    Thanks Welsh Corgi!

    Your post fixed my issue. (start up as local service)

    Cool glad that worked for you.:cool:

    January 21, 2014 at 9:55 am

    #1682076

Viewing 15 posts - 916 through 930 (of 3,738 total)