We should mtonitor database files(both data and log), and if they close to max capacity, manually increase the size.
However it doesn’t give references, how to monitor the free space inside databases.
I’ve tried to look how to do it.
It can be done manually using
execute sp_spaceused for the database in question or
sp_SOS (can be downloaded from
Alternatively you can run SQL commands as suggested in Http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82359 by
[FREE_SPACE_MB] = convert(decimal(12,2),round((a.size-fileproperty(a.name,’SpaceUsed’))/128.000,2))
from dbo.sysfiles a
More useful article Monitor database file sizes with SQL Server Jobs describes how to setup monitoring
Finally I found the excellent article