on 2020 Apr 03 5:54 AM
I'm trying to schedule full and incremental backups with maintenance plans of database but it seems that It's not truncating logs of database so how can I do that in maintenance plan? Is there a option or do I have to schedule another script for that?
Request clarification before answering.
A maintenance plan is basically a UI that builds an event. You could modify the event to meet your specific needs. See BACKUP DATABASE statement for syntax of the statement used in the event to backup the database. To truncate the log, you will need to use the TRANSACTION LOG TRUNCATE backup option.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In the box ro Run this SQL after the plan, you could put
BACKUP DATABASE DIRECTORY '' TRANSACTION LOG ONLY TRANSACTION LOG TRUNCATE; COMMIT;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
68 | |
16 | |
12 | |
7 | |
7 | |
4 | |
4 | |
4 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.