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.
Thank you for the information. How we can increase the space.
Great information. I like it. Looking for new updates.
What if it still running out of space.
I’m still running out of space.
Hi James, does the sql statement run successfully? What is the total size of your database before and after the the clearing of the event log?