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 |
|
sourpoodles
Starting Member
1 Post |
 Posted - 2007-05-22 : 16:03:03
|
I'm the web designer for my company and as a result I'm also the server administrator. SO I'm new to MS SQL and I had a question.We have MS SQL 2000 and we have a listserv database that's 3.5 GB. When I use Enterprise Manager > right-click on the db > Properties > Data Files tab > the file properties are set to Automatically grow file and the Maximum file size is set to Unrestricted file growth. But on the General tab it says "Space available: 0.00 MB". We definitely have hard disk space (100+ GB) on the server and we haven't received any error messages about not enough space. Also, the other databases have some amount of MB in the Space available field, only the listserv db says 0.I've found other posts similar to this on this forum but I couldn't find an answer that made sense to me. Do I increase the space available? Am I supposed to run a stored procedure? I'm really new to stored procedures and other SQL operations so please go easy on me  Cheers,Brian |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-23 : 02:55:10
|
| The system will allocate more space as needed.Right now the space which HAS been allocated may be all used up, so there is "zero available", but next time the database is [automatically] extended there will be space available. Right up until the physical disk is full!If you're new to this let me double check a couple of things:Your database is being backed up, right?Have you tried restoring a backup to prove that you can? (Do not overwrite the original database to make this test! Preferably restore to another machine, and to a "temporary" database)Does your database have some maintenance performed on it? (e.g. using the Maintenance Wizard to rebuild indexes and statistics, and to perform database health checks - make sure you are NOT using the "Fix any errors" option)Is the size of the LDF file [for your database] less than 120% of the size of your MDF file? (the LDF might be tiny, it is unusual to to be more than 120% of the MDF file though)Kristen |
 |
|
|
|
|
|
Database Size