I can see the below error in the Event viewer and the SQL Server 2008 Express seem to be timing out when trying to login:
"Could not allocate space for object 'dbo.VerboseLogs'.'PK_Logs' in database 'XXXXX' 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."
Any Ideas? There is plenty of space available on the drive. Also, Log file is set to Autogrow by 10 percent, restricted growth till 2,097,152 MB. MDF is set to Autogrow by 1 MB, unrestricted growth.
Answer by Matt Whitfield ·
Yes, SQL Server Express is limited to 4GB... so you can't exceed that limit no matter how much space you have on the disk.
If you want to have a look at how the space is used, and drill down, then try out my tool for that.