cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How and when to truncate log file in database mirroring setup (SQL Anywhere 17.0.11.7458)

fvestjens
Participant
0 Kudos
306

Currently in production environment we create a backup of the database every evening and we truncate the logfile.

In a test environment database mirroring has been setup and we want to truncate the logfile every evening here as well. However that doesn't seem to work. 
We're using "BACKUP DATABASE DIRECTORY 'F:\\transfusion' TRANSACTION LOG ONLY TRANSACTION LOG TRUNCATE;" but that does not work. We get an error see the screenshot belowbbea5dc7-6215-42b5-bed4-def467fc301a.png

How can we truncate the logfile in a database mirror setup?

Accepted Solutions (0)

Answers (0)