Hi,

In the past I used the following script to truncate my database.
I' am using now sql 2008.
Now this script gives the error message below.
Is there anybody out there with some advice?

With regards, Ton Hermes

BACKUP LOG c1664_dnn WITH TRUNCATE_ONLY
TRUNCATE TABLE {databaseOwner}{objectQualifier}EventLog
TRUNCATE TABLE {databaseOwner}{objectQualifier}SiteLog
TRUNCATE TABLE {databaseOwner}{objectQualifier}schedulehistory
DBCC SHRINKDATABASE (c1664_dnn);

System.Data.SqlClient.SqlException: 'TRUNCATE_ONLY' is not a recognized BACKUP option. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BACKUP LOG c1664_dnn WITH TRUNCATE_ONLY TRUNCATE TABLE dbo.EventLog TRUNCATE TABLE dbo.SiteLog TRUNCATE TABLE dbo.schedulehistory DBCC SHRINKDATABASE (c1664_dnn);

Hi,

So it must be like this?

With Regards, Ton

ALTER DATABASE c1664_dnn SET RECOVERY SIMPLE
TRUNCATE TABLE {databaseOwner}{objectQualifier}EventLog
TRUNCATE TABLE {databaseOwner}{objectQualifier}SiteLog
TRUNCATE TABLE {databaseOwner}{objectQualifier}schedulehistory
DBCC SHRINKDATABASE (c1664_dnn);

Hi,

No I did not got this resolved.

I tell you why I do this truncation, shrinking.
In the past, when I did nothing< the database was growing and growing in size.
Then when, I wanted to empty the site log, I got an error mentioned that the log file was to big to complete the job.
So I had to find another way to empty the log file.
On the forum I discovered above mentioned script to empty the log file.
This script worked fine.
The database was shrinking from 50 to 25 Mb.

Then I saw on a  site a free DNN module to do this job.
I installed this module.
I though everything was ok now.
However, after a couple of weeks I checked the database and event log again and it was big in size.
I tried to manually empty the log file and got again the error that the log file was to big to complete the job.

I used the old script to do the job again.
However, I upgraded the SQL from 2000 to 2008.
Now I got again an error that this script was not valid anymore.

What shall I do now?
using this?
ALTER DATABASE <%YOURDB> SET RECOVERY FULL

or this?
ALTER DATABASE c1664_dnn SET RECOVERY SIMPLE
TRUNCATE TABLE {databaseOwner}{objectQualifier}EventLog
TRUNCATE TABLE {databaseOwner}{objectQualifier}SiteLog
TRUNCATE TABLE {databaseOwner}{objectQualifier}schedulehistory

or this?
ALTER DATABASE <%YOURDB> SET RECOVERY SIMPLE
ALTER DATABASE <%YOURDB> SET RECOVERY FULL

Thanks for responding.

With regards, Ton Hermes