One of our sites is throwing an error because we have exceeded the maximum database size. Every time a page is loaded an insert is made in an anyltics table.
Should we change the DB to autogrow? How would we di this in SQL 2008?
Could not allocate space for object 'dbo.Analytics'.'PK_Anakytics' in database 'NhmMicrosites' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.