The database is full!

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server Express » The database is full!

The database is full!

Rate Topic

Display Mode

Topic Options

Author

Message

visualserge

Posted Monday, March 09, 2009 3:25 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, August 05, 2012 11:17 PM
Points: 1, Visits: 14

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

Post #671317

Dugi

Posted Monday, March 09, 2009 6:59 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252, Visits: 3,367

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/

Post #671428

GSquared

Posted Monday, March 09, 2009 8:17 AM

SSCoach

Group: General Forum Members
Last Login: Monday, June 17, 2013 1:45 PM
Points: 15,442, Visits: 9,572

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

Post #671531

steveb.

Posted Monday, March 09, 2009 8:20 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 8:56 AM
Points: 2,802, Visits: 7,110

Create a new database or upgrade to SQL standard edition.

Post #671534

Dugi

Posted Monday, March 09, 2009 8:35 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252, Visits: 3,367

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/

Post #671561

Jonathan Mallia

Posted Wednesday, March 11, 2009 2:30 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 4:48 AM
Points: 968, Visits: 993

Try changing the maximum size limitation from the database properties.

Post #673047

BLADE-1043594

Posted Friday, March 20, 2009 6:06 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, June 01, 2009 6:06 AM
Points: 518, Visits: 354

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

+++BLADE+++ Cool

Post #680300

chandar.sp

Posted Monday, September 03, 2012 4:32 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 7:15 AM
Points: 1, Visits: 324

SQL SERVER DATABASE FULL HOW DO WE TROUBLESHOOT?

Post #1353646

Jeff Moden

Posted Monday, September 03, 2012 6:29 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 11:54 PM
Points: 33,113, Visits: 27,041

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."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1353656

Jeff Moden

Posted Monday, September 03, 2012 6:34 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 11:54 PM
Points: 33,113, Visits: 27,041

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

Post #1353659

« Prev Topic | Next Topic »

Permissions