Setting a SQL database size limit
Posted on 2010-11-23
I am trying to set a database SIZE limit for a SQL database on my SQL 2005 Standard server. I want a specific database (a SYSLOG database) to limit itself to (1) GB. I have set the maximum database size for this database in the database properties in SQL Enterprise Manager and indeed, the database is NOT growing larger than 1GB.
However, I do see the APPLICATION LOG of the SQL server filling up with THOUSANDS of messages indicating that the database is full and unable to be written to.
What I WANT to happen is for 1GB of data to be retained, with NEWER data pushing OLDER data out. I thought this is what would be happening when I set a database size limit, but looking at the APPLICATION log, it does not seem that this is the case. Can anyone tell me if I misunderstood what LIMIT DATABASE SIZE meant, and if this is NOT what I've configured, can it be done?