Truncate sql transaction log

[DvV]

Hi,

I have a problem with the Arcserve sql backup agent in combination with Arcserve 2000 Advanced Edition. Both with Arcserve service pack 4 installed and both running on (separate) Windows 2000 servers.
The SQL version is 2000.

I have set a backup job to make a complete backup of (most of) the sql databases on our sql server. In the documentation of the sql backup agent a dialog screen is shown in which it is possible to choose whether or not to truncate the transaction log after making a complete backup.

However, when I look at the options after right-clicking on a database the dialog screen looks different than the one in the documentation and I don't have this option. It seems that it is no longer possible to have the transaction log truncated after making a complete backup, which I would really like to do for a particular database.

I hope someone can help me solve this problem.

Regards,

Dennis van Velzen

 

[DvV]

I finally found the solution to my problem. It is correct that the option to truncate the log doesn't show up anymore for SQL 2000 databases (it did in SQL 7.0).

In order to get the transaction log to be truncated automatically a setting in SQL 2000 itself needs to be changed, and not in Arcserve.
The recovery model needs to be set to Simple. It was now set to Full for the database.

Sorry to have bothered you

Regards,
Dennis van Velzen

 

[ArenB]

Dennis,

thanks for your own reply
you solved my problem


Aren