If your database is full, your DNN page will stop working. This means that it is no longer possible to execute an SQL script via your DNN instance.
Remedy in this case only a direct connection with the Microsoft SQL Management Studio to your database. However, this is only possible if they either have direct remote access to the web server or the ports to your SQL server have been enabled in the firewall.
In the event that you have a connection to Microsoft SQL Management Studio with your database, do the following:
- Open Microsoft SQL Server Management Studio
- Connect to your Database
- Click New Query button
- Paste the following Script into the New Query page replacing [database name] with the name of your database
use [database_name]
truncate table sitelog
truncate table eventlog
truncate table schedulehistory
- Click Execute