Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The database is full! Expand / Collapse
Author
Message
Posted Monday, March 9, 2009 3:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, August 5, 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
Posted Monday, March 9, 2009 6:59 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 20, 2014 3:44 AM
Points: 1,260, Visits: 3,424
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
Posted Monday, March 9, 2009 8:17 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:58 AM
Points: 13,872, Visits: 9,600
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
Posted Monday, March 9, 2009 8:20 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
Create a new database or upgrade to SQL standard edition.
Post #671534
Posted Monday, March 9, 2009 8:35 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 20, 2014 3:44 AM
Points: 1,260, Visits: 3,424
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
Posted Wednesday, March 11, 2009 2:30 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 9:18 AM
Points: 982, Visits: 1,129
Try changing the maximum size limitation from the database properties.
Post #673047
Posted Friday, March 20, 2009 6:06 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, June 1, 2009 6:06 AM
Points: 518, Visits: 354
Can you please tell me which edition you are using??????

+++BLADE+++
Post #680300
Posted Monday, September 3, 2012 4:32 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 3:55 AM
Points: 1, Visits: 436
SQL SERVER DATABASE FULL HOW DO WE TROUBLESHOOT?
Post #1353646
Posted Monday, September 3, 2012 6:29 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 8:47 PM
Points: 35,770, Visits: 32,436
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1353656
Posted Monday, September 3, 2012 6:34 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 8:47 PM
Points: 35,770, Visits: 32,436
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1353659
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse