Meaning of SQL Database Property General Space available 1

[rglane]

My application just blew up. I believe it is from lack of space. How do I change space available.

 

[JayKusch]

The database should automatically grow when it needs space. The real limiting factor will be pyhsical disc space. Check you drive that the MDF and LDF files are on. If there is little space that will be the issue.

You should also find, in Enterprise Manager(EM) in the Management..SQL Server Error Logs an error if the DB was unable to grow. You can also in EM click on the database you are having issues with and from the View options in the top menu bar select TaskPad. This will show you the full size the database is currently allocated for as well as how much space of the allocate database file is currently in use.

If you right mouse click the DB again and Choose properties. You will be able to see how much the DB is trying to grow. It will either be set to grow by Megabyte rate or a percentage of the current size of the DB. Either way, you may be able to adjust the autogrow size to a small value just to get the DB to extend and your app to work until you find a workaround.

If I were to venture a guess ... I would say your transaction log is full. Once again, you can find this in the SQL Server error logs in EM.

Good Luck!

Thanks

J. Kusch