If your DNN SQL database runs out of space, one of the first symptoms you will notice is that your users will not be able to login. You can take one of two actions in this case.
1. Increase space allocated for the SQL database.
2. Truncate your Log tables.
In order to accomplish no. 1, you will need to follow guidelines in your hosting provider. For no. 2, use the script below. Make sure to make backups beforehand.
USE {databaseName}
TRUNCATE TABLE [SiteLog]
TRUNCATE TABLE [ScheduleHistory]
TRUNCATE TABLE [EventLog]
DBCC SHRINKDATABASE ({databaseName}, 10);GO
Replace {databaseName} with the name of your database.
