Comprehensive data protection for all workloads
Post Reply
tinto1970
Veeam Legend
Posts: 109
Liked: 32 times
Joined: Sep 26, 2013 8:40 am
Full Name: Alessandro T.
Location: Bologna, Italy
Contact:

How to understand if an MSSQL Maintenance plan is processing logs

Post by tinto1970 »

good day, I beg for an help with MSSQL.
A customer is protecting an SQL server with a Veeam Job ("process transaction logs with this job" is active) AND with a maintenance plan. I know this is wrong but I cannot act freely for "non technical reasons".

I tried to understand from maint plan settings if it's processing logs. I did not succeed. How should I do? Ot it's sure the maint plan does process logs?

Maybe the most easy and safe workaround is to switch the setting in veeam to "perform copy only"? At least on the days before a datacenter physical relocation, which is currently our main concern?

thanks in advance
Alessandro aka Tinto | VMCE 2024 | Veeam Legend | VCP-DCV 2023 | VVSPHT2023 | vExpert 2024
blog.tinivelli.com
HannesK
Product Manager
Posts: 14322
Liked: 2890 times
Joined: Sep 01, 2014 11:46 am
Full Name: Hannes Kasparick
Location: Austria
Contact:

Re: How to understand if an MSSQL Maintenance plan is processing logs

Post by HannesK »

Hello,
there are maintenance plans for "everything", so one has to read the SQL code in the maintenance plan. If the maintenance plan causes issues with logs, then you posted the solution with "copy only" đź‘Ť

Best regards,
Hannes
Post Reply

Who is online

Users browsing this forum: Google [Bot] and 99 guests