Forum Replies Created

Viewing 15 posts - 30,631 through 30,645 (of 49,552 total)

  • RE: D: drive is full and transaction log is full

    sqlbuddy123 (9/16/2010)

    1. Free up some space on D drive and see that if the DB recovers. This may include shrinking other databases to free up some space.

    The database will not...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 16, 2010 at 1:17 pm

    #1222524

  • RE: D: drive is full and transaction log is full

    Carl Federl (9/16/2010)

    Will that work if the current drives are 100% full?

    There are some constraints with the solution:

    1. The second transaction log needs to be on a different...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 16, 2010 at 11:30 am

    #1222430

  • RE: D: drive is full and transaction log is full

    hallhome (9/16/2010)

    I am waiting to hear if more space can be made available. The rest of the drive is taken up by the system databases and two...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 16, 2010 at 11:21 am

    #1222417

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (9/16/2010)

    Paul White NZ (9/16/2010)

    Brandie Tarvin (9/16/2010)

    I don't know. I read his apology like a passive-aggressive slap upside the head. "Yes, I'm apologizing, but only because I got called on...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 16, 2010 at 11:21 am

    #1222416

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (9/16/2010)

    What's humour?

    You hanging out with Brit's in TN?

    He's finally learnt to spell properly. 😀

    *ducks and runs away*

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 16, 2010 at 11:13 am

    #1222408

  • RE: Are the posted questions getting worse?

    jcrawf02 (9/16/2010)

    Alvin Ramard (9/16/2010)

    The Dixie Flatline (9/16/2010)

    GilaMonster (9/16/2010)

    CirquedeSQLeil (9/16/2010)

    And is that a bit threaded towel to be thrown in?

    *groan*

    If I can get away in time to drive up to Memphis...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 16, 2010 at 10:38 am

    #1222364

  • RE: D: drive is full and transaction log is full

    Please look in the error log, since the last restart, and post the exact errors that are there. There should be some errors relating to recovering the database (unable to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 16, 2010 at 10:33 am

    #1222355

  • RE: What a nice place to be

    Thank you for the kind words.

    Welcome (belated) to SSC and please stay a long time.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 16, 2010 at 9:35 am

    #1222299

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (9/16/2010)

    And is that a bit threaded towel to be thrown in?

    *groan*

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 16, 2010 at 9:20 am

    #1222285

  • RE: How can you see the Recovery Model?

    Awesome. It's always better to find these things out BEFORE the pawpaw hits the fan.

    You're welcome.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 16, 2010 at 9:09 am

    #1222267

  • RE: How find open transaction statements?

    SureshS_DBA (9/16/2010)

    Thats my poor writing skills if I appeared sarcastic anywhere 🙂

    It's easy to misread tone on the forums. I'll apologise on Dave's behalf, I'm sure he will as soon...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 16, 2010 at 8:42 am

    #1222241

  • RE: How find open transaction statements?

    Dave Ballantyne (9/16/2010)

    SureshS_DBA (9/16/2010)

    Thanks for a long followup Gail....

    That was unnecessary.

    Huh?

    Not sure how it was intended, but I read that as genuine thanks for a long thread.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 16, 2010 at 7:45 am

    #1222193

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (9/16/2010)

    However, the bolded underlined part of his post is what I'm referring to as passive agressive.

    I read it as the 'The person' referring to the OP of that...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 16, 2010 at 7:32 am

    #1222181

  • RE: D: drive is full and transaction log is full

    Ok, that is never going to recover by itself and you won't be able to add log files in that state.

    Please read through the SQL error log and see what...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 16, 2010 at 7:28 am

    #1222176

  • RE: How find open transaction statements?

    SureshS_DBA (9/16/2010)

    So if I use DMV's, I dont see a way to know which statements are open.

    Well you can see the latest statements from an open transaction, but not...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 16, 2010 at 7:21 am

    #1222166

Viewing 15 posts - 30,631 through 30,645 (of 49,552 total)