4 weeks ago
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 below
How can we truncate the logfile in a database mirror setup?
User | Count |
---|---|
67 | |
10 | |
10 | |
10 | |
10 | |
8 | |
8 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.