Transaction Log Full Error on DNN Site

Plesk Servers > SQL > MSSQL

Transaction Log Full Error on DNN Site

Issue
You you trying to load your DotNetNuke site and are receiving a Transaction Log Full error message.

Cause
Your MSSQL Database transaction log file has grown too large, or had size limitations imposed on it by a previous host.

Resolution
These steps require you to have Microsoft SQL Server Management Studio installed on your computer.  Microsoft SQL Server Mangement Studio Express 2008 is available for free from Microsoft, and can be downloaded through this link: http://www.microsoft.com/download/en/details.aspx?id=22985

 

  1. Log into SQL Server Management Studio.
  2. Expand Databases. Right click on your databse and select Properties.
  3. In the Select a page section click Options
  4. Change the Recovery Model to Simple in the dropdown menu.
  5. In the Select a page section click Files.
  6. If the Autogrowth rules are set to restricted growth for either Rows Data or Log continue to the next step, if not please see our article on How to Shrink Your MS SQL Database Log File
  7. Click on the ... button in the Autogrowth column for the File Type that is incorrect.
    • Change Autogrowth Setting
  8. In the Maximum File Size section select Unlimited File Growth.
  9. Restart your website using the steps in the How to Recycle an IIS Application Pool article.

This will clear the error condition of Transaction Log is Full on your site.

Feedback

Add Feedback
Why don't you run scripts/setup options to handle this issue by default? Why force users to run into this?! Also under 2), what is the DB server name on your site to connect to: just our website domain?!
John Cornelison (October 26, 2015 at 9:58 PM)
Hello John, <br /> <br />Scripts are not automatically run, due to custom nature of sites/SQL setups. What would work for some would break other's installations. <br /> <br />The normal location for MsSQL databases is mssql.<domain> or you can use the domain's IP address.
Charles Middleton (October 29, 2015 at 1:18 PM)

Add Feedback