Post reply

The database is full!

  • March 9, 2009 at 3:25 am

    #201215

    Any one can help me, how to manage this situation if the database is full.::D

  • March 9, 2009 at 6:59 am

    #955936

    visualserge (3/9/2009)

    Any one can help me, how to manage this situation if the database is full.::D

    What do you mean the database is Full, is this over 4GB or you storage is going bye bye!?

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • March 9, 2009 at 8:17 am

    #956029

    Create another database and move some of the data to that.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • March 9, 2009 at 8:20 am

    #956032

    Create a new database or upgrade to SQL standard edition.

  • March 9, 2009 at 8:36 am

    #956056

    GSquared (3/9/2009)

    Create another database and move some of the data to that.

    Yes if your DB is 4GB this is one of the solutions, you should know that the SQL Server Express Edition doesn't allow the DB over 4GB!!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • March 11, 2009 at 2:30 am

    #957306

    Try changing the maximum size limitation from the database properties.

  • March 20, 2009 at 6:06 am

    #963445

    Can you please tell me which edition you are using??????

    [font="Comic Sans MS"]+++BLADE+++[/font]:cool:

  • September 3, 2012 at 4:32 pm

    #1533072

    SQL SERVER DATABASE FULL HOW DO WE TROUBLESHOOT?

  • September 3, 2012 at 6:29 pm

    #1533079

    Jonathan Mallia (3/11/2009)

    Try changing the maximum size limitation from the database properties.

    I'm pretty sure that's not going to work with SQL Express which has a built in limit of 4GB.

    {Edit} Wow! Didn't see that this was from 2009 until it was too late.

    --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)

  • September 3, 2012 at 6:34 pm

    #1533082

    chandar.sp (9/3/2012)

    SQL SERVER DATABASE FULL HOW DO WE TROUBLESHOOT?

    Just a friendly tip. Most people consider all-caps to be someonne yelling.

    Back to your problem. Troubleshooting is over. You already know what's wrong. You've exceeded the limits of SQL Express.

    First, check the log file and make sure that's not what's hogging all the space. Most people forget to backup SQL Express log files for FULL recovery databases.

    If that's not it, then you really do have a full database and you need to do one of two things... archive some of the data so you can delete it or move some of the data to another database.

    --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)

Viewing 10 posts - 1 through 9 (of 9 total)

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