Comprehensive data protection for all workloads
Post Reply
drehstrom
Novice
Posts: 4
Liked: never
Joined: Aug 17, 2020 3:38 pm
Full Name: Stephan
Contact:

Remove former SQL-servers from Guest-Processing

Post by drehstrom »

Hi,

I would like to know how Veeam determins if a server is running SQL.
We have a few servers which formerly were hosting SQL-services. We migrated these to a SQL-cluster and removed all remaining SQL-services. But still Veeam tries to backup transaction logs on these servers. So how can we tell Veeam that there is no SQL anymore?
It's not a problem right now, but it made me curious...

Regards
Stephan
david.domask
Veeam Software
Posts: 2331
Liked: 554 times
Joined: Jun 28, 2016 12:12 pm
Contact:

Re: Remove former SQL-servers from Guest-Processing

Post by david.domask »

Hi Stephan,

SQL log backup jobs run as a "child" job of the parent job; it's a continually running job that is aware when its parent job is running or not and adjust itself accordingly.

Did you disable the SQL Log Backup for these machines in the job?

Similarly, you should be able to just disable the parent job (the actual backup job for these VMs), wait until the SQL Log Backup job stops itself and unloads, then re-enable the parent job.
David Domask | Product Management: Principal Analyst
drehstrom
Novice
Posts: 4
Liked: never
Joined: Aug 17, 2020 3:38 pm
Full Name: Stephan
Contact:

Re: Remove former SQL-servers from Guest-Processing

Post by drehstrom »

Already did that. Disabled an reenabled the parent job. Still the child-job finds the old servers. Btw. it's not doing anything since it states "Skipping deleted database: xxxx".
I didn't remove the old servers from Guest Processing since I thought Veeam would recognise that there is no more SQL to back up and I don't want to have too many exclusions.
Is it possible, that it keeps trying as long as there are backups containing these old databases? So I'd just have to remove the corresponding backups and everything would be fine?
drehstrom
Novice
Posts: 4
Liked: never
Joined: Aug 17, 2020 3:38 pm
Full Name: Stephan
Contact:

Re: Remove former SQL-servers from Guest-Processing

Post by drehstrom »

For now I added the neccessary exclusions. Thanks for the hint.
Anyway I'd like to know if there is a smarter way...
david.domask
Veeam Software
Posts: 2331
Liked: 554 times
Joined: Jun 28, 2016 12:12 pm
Contact:

Re: Remove former SQL-servers from Guest-Processing

Post by david.domask »

Hi Stephan,

Disabling will be the best way -- it's not about dependent backups so much as the job is configured to try to do SQL Log backups, and it will dutifully try to do so while it's enabled.

Is this a situation you would expect frequently? If not I think then stick with just disabling SQL Log Backup from the job settings; I did test in lab and I was wrong on the idea of disabling the parent job, though in retrospect it makes sense because of the above :) So just disable SQL Log Processing on the job settings and that will be all you need.
David Domask | Product Management: Principal Analyst
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 83 guests