Post reply

database goes down

  • November 5, 2009 at 12:47 am

    #206297

    iam from production , databse went dowm due to 100% increase of space in mdf file . how can we bring thwe database up ?

  • November 5, 2009 at 12:53 am

    #1075197

    database is down meaning it went in suspect mode or what

    to solve your problem immediately add another file to primary filegroup or any other filegroup for which 100% growth happened on the drive having enough free space

  • November 5, 2009 at 1:00 am

    #1075201

    can we shrink the mdf file to release some space and bring back up t edb up ?

  • November 5, 2009 at 2:33 am

    #1075215

    could please tell us which anti virus software your production server is having.

    Regards

    Ramu

  • November 5, 2009 at 2:34 am

    #1075218

    first off, is sql server still running. if so allocate more space to the database. if not free more space on the drive.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • November 5, 2009 at 2:35 am

    #1075219

    i am sorry the post was for different topic.

  • November 5, 2009 at 10:07 pm

    #1075711

    Heh... good interview question.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • November 6, 2009 at 1:46 am

    #1075748

    Jeff Moden (11/5/2009)

    Heh... good interview question.

    Seem to be getting a lot of question like this recently...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply