4 years ago,
Your question has been submitted and is awaiting moderation.
We have an SQL Express 2005 DB (connected to DNN via file rather than through SSMS) on DNN 4.
(Yes it's old... and yes it's due to be retired v. v. soon) :-)
The DB is 114MB and the DB log LDF file is 30GB.
How do I reduce the size of the LDF? I've seen loads of articles about using SSMS to do this, but as this isn't connected to SSMS, (and we don't really want to make any changes on it as we're going to retire it soon) is there a way that we can do this through the 'Host > SQL' menu?
I've tried the following, to no avail:
truncate table sitelog
truncate table eventlog
truncate table schedulehistory
Some other options I found required us to know the Database name, which I don't know. Using the seemingly default 'DotNetNuke' database name didn't work (I received not recognised errors)
Can anyone offer any advice please?