Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wynng
Starting Member
8 Posts |
 Posted - 2006-04-19 : 04:38:07
|
| I have a database that is bugging me at the moment and I'm hoping someone here might be able to help. The database is currently shown in the Enterprise Manager db properties dialog as having 0.00MB free space. In fact it's been like this for several days. However there are no problems with inserting data and when I insert records the database doesn't grow, neither do I get an error. The database is set to automatically grow by 250MB with no upper limit. Auto shrink is not enabled. There are no problems being reported by users of the database. My understanding is that when a new record is added that requires more space than is available in the file, the file should grow by 250MB. Has anyone seen anything like this before or knows of possible causes? As I said it isn't really causing any problem other than I don't understand the behaviour. Many Thanks. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-19 : 04:46:24
|
are you referring to "space available"?it probably grew to the next 250 MB. you can try to do some bulk copies on a staging table to test it out... --------------------keeping it simple... |
 |
|
|
wynng
Starting Member
8 Posts |
Posted - 2006-04-19 : 06:55:12
|
| Thanks Jen. Yes space available. If it grew then why is the space available still 0MB? Wouldn't it show the space as just under 250MB initially? |
|
|
|
schuhtl
Posting Yak Master
102 Posts |
Posted - 2006-04-19 : 07:54:22
|
| Try this...sp_spaceused @updateusage = 'TRUE' |
|
|
|
wynng
Starting Member
8 Posts |
Posted - 2006-04-19 : 08:40:17
|
quote:
Originally posted by schuhtl
Try this...sp_spaceused @updateusage = 'TRUE'
Cheers, that's worked now and the db properties page is showing free space. |
|
|
|
|
|
|
Database Space Available 0.00MB