Forum Replies Created

Viewing 15 posts - 2,071 through 2,085 (of 3,738 total)

  • RE: Can't Shrink the Transaction Log

    Kevin Grogan (11/25/2011)

    This solution has worked for me...

    http://blog.sqlauthority.com/2006/12/30/sql-server-shrinking-truncate-log-file-log-full/

    Levin,

    Thanks but I did that. Look at my initial post.

    I need to do what Gail suggested. I really owe it to her for...

    November 25, 2011 at 11:44 am

    #1413051

  • RE: Can't Shrink the Transaction Log

    GilaMonster (11/24/2011)

    Welsh Corgi (11/24/2011)

    So how is your day going so far?

    It's 2:21 AM and I'm still working.

    You are very dedicated and I'm sorry to hear that you are still working...

    November 24, 2011 at 5:33 pm

    #1412826

  • RE: Can't Shrink the Transaction Log

    What do you mean did I do what you suggested?

    Did you try what I suggested? :

    Well, nothing's waiting for the log to be freed, so try to shrink it. If...

    November 24, 2011 at 5:19 pm

    #1412820

  • RE: Can't Shrink the Transaction Log

    Gail,

    I appreciate your time and information.

    The log backup jobs were turned off over a year ago have been neglected.

    Please consider this is not a situation that I created but an...

    November 24, 2011 at 5:13 pm

    #1412819

  • RE: Can't Shrink the Transaction Log

    It was mentioned what can't be done using whatever method.

    You can Shrink the log using the following as was provided in the BOL Link:

    Copy

    USE AdventureWorks;

    GO

    -- Truncate the log...

    November 24, 2011 at 3:10 pm

    #1412805

  • RE: Can't Shrink the Transaction Log

    I'm unable to shrink the log file.

    The log_reuse_wait_desc = REPLICATION and 11% of the log file is used.

    Does anyone have any suggestions?

    Thank you.

    November 24, 2011 at 2:54 pm

    #1412801

  • RE: Predict output

    A poorly worded trick question.

    November 24, 2011 at 2:07 pm

    #1412793

  • RE: Can't Shrink the Transaction Log

    Andeavour (11/24/2011)

    Argh... Shot down in flames by your sharp eyed skills 🙂

    You're right of course. I have actually only used it against Data files in the past, and now I'm...

    November 24, 2011 at 1:38 pm

    #1412784

  • RE: Can't Shrink the Transaction Log

    GilaMonster (11/24/2011)

    The NoTruncate and TruncateOnly options on a shrink are solely for data files. They are completely ignored when shrinking a log file.

    It was my understanding that the NO_TRUNCATE &...

    November 24, 2011 at 1:03 pm

    #1412779

  • RE: Can't Shrink the Transaction Log

    GilaMonster (11/23/2011)

    Welsh Corgi (11/23/2011)

    GilaMonster (11/23/2011)

    Did you read the article?

    I read it, then I scanned it again prior to asking the question.

    Then I search for it and no matches found.

    There's definitely...

    November 24, 2011 at 9:47 am

    #1412763

  • RE: Can't Shrink the Transaction Log

    GilaMonster (11/24/2011)

    [Well, nothing's waiting for the log to be freed, so try to shrink it. If it won't, take a log backup and try to shrink again (and that's not...

    November 24, 2011 at 8:33 am

    #1412726

  • RE: Can't Shrink the Transaction Log

    GilaMonster (11/23/2011)

    Welsh Corgi (11/23/2011)

    GilaMonster (11/23/2011)

    There's definitely a section on what the replication wait means.

    I did not question what the replication wait means and I replied to you on that.

    I...

    November 23, 2011 at 4:24 pm

    #1412514

  • RE: Can't Shrink the Transaction Log

    GilaMonster (11/23/2011)

    Did you read the article?

    Free space with DBCC SQLPERF(LogSpace)

    I read it, then I scanned it again prior to asking the question.

    Then I search for it and no matches found.

    I...

    November 23, 2011 at 12:20 pm

    #1412415

  • RE: Can't Shrink the Transaction Log

    How do I verify that there is free space?

    The log_reuse_wait_desc = REPLICATION

    Apparently this means something to the effect of SQL Server waiting for a replication task to finish before it...

    November 23, 2011 at 11:34 am

    #1412389

  • RE: Replace CASE with PIVOT

    Thanks for the article.:cool:

    November 23, 2011 at 8:22 am

    #1412236

Viewing 15 posts - 2,071 through 2,085 (of 3,738 total)