May 25, 2005 at 10:07 am
One of the databases on the server are reporting that there is zero space available
However we aren’t seeing any errors in the sql log and database seem to be functioning with no problems.
I have checked disk space, which has over 1gig. Any suggestion are appreciated.
May 26, 2005 at 3:21 am
i would suggest you to shrink the database on a regular basis.
if i would have been in your place, i would not wait till an error is thrown up or a disaster occurs.
if you already know that there is no space availabe, go ahead and shrink the database.
-- Parag
May 26, 2005 at 4:30 am
What mechanism is it that is reporting to you that there is no space available?
Is the database set to autogrow? If not then it makes no difference if there is space on disk or not, if the file runs out of space then it must be manually grown to use the extra space on disk.
May 26, 2005 at 9:52 am
I am looking at the database properties in EM and space available is 0. I have checked disk space and there is more than over a gig. The database is set to autogrow. I tried to shrinking the database, that didn't work.
What I found was that mdf, ldf, transaction log and database backup were all pointing to the same drive. I decided to move the transaction log to another drive, ran a backup to new drive, not thinking this would change anything but it did.
After making the change I looked at the particular database property and it was showing space available. I'm not quite sure how this would have affected any changes in the database properties.
Can someone explain?
May 26, 2005 at 11:53 am
When you moved the log to another drive, was it on the same server?
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
May 26, 2005 at 11:56 am
Yes, I moved the log from D: to F: on the same server.
May 26, 2005 at 1:29 pm
Try running the following to update your space usage:
DBCC UPDATEUSAGE ('your_db_name') WITH NO_INFOMSGS
May 26, 2005 at 1:53 pm
Ok, thanks I'll try that.
May 27, 2005 at 1:27 am
If there is no space available but the files are set to autogrow then you have no problem. As soon as more space is needed SQL Server will grow the files and add more space. Note that it is often recommended to not let SQL Server automatically grow the files and instead handle that manually, to gain more control.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply