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
-
- Novice
- Posts: 4
- Liked: never
- Joined: Aug 17, 2020 3:38 pm
- Full Name: Stephan
- Contact:
-
- Veeam Software
- Posts: 2331
- Liked: 554 times
- Joined: Jun 28, 2016 12:12 pm
- Contact:
Re: Remove former SQL-servers from Guest-Processing
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.
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
-
- Novice
- Posts: 4
- Liked: never
- Joined: Aug 17, 2020 3:38 pm
- Full Name: Stephan
- Contact:
Re: Remove former SQL-servers from Guest-Processing
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?
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?
-
- Novice
- Posts: 4
- Liked: never
- Joined: Aug 17, 2020 3:38 pm
- Full Name: Stephan
- Contact:
Re: Remove former SQL-servers from Guest-Processing
For now I added the neccessary exclusions. Thanks for the hint.
Anyway I'd like to know if there is a smarter way...
Anyway I'd like to know if there is a smarter way...
-
- Veeam Software
- Posts: 2331
- Liked: 554 times
- Joined: Jun 28, 2016 12:12 pm
- Contact:
Re: Remove former SQL-servers from Guest-Processing
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.
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

David Domask | Product Management: Principal Analyst
Who is online
Users browsing this forum: Bing [Bot] and 83 guests