Comprehensive data protection for all workloads
Post Reply
arosas
Enthusiast
Posts: 63
Liked: 10 times
Joined: Jun 09, 2015 9:33 pm
Full Name: Tony Rosas
Contact:

SQL Log Shipping Server Selection

Post by arosas »

We have all of our SQL server backups set to automatic selection for Log Shipping Servers.

When the primary job is enabled and the first initial log shipping occurs we are able to see the assigned proxy server for log shipping.
The action window for the SQL Server Transaction Log Backup shows:

"Using guest interaction proxy {PROXYSERVERNAME} (Same subnet)"

After the first interval expires, the action window does not show the assigned proxy.

A couple questions:
When the current interval expires (15 minutes in our case), does a new proxy get assigned for every 15 minute session?

If the job has been running for some time how can we see which log shipping server is currently assigned?
veremin
Product Manager
Posts: 20283
Liked: 2258 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL Log Shipping Server Selection

Post by veremin »

Log shipping server is selected per backup job session. That's why you only see corresponding label once - immediately after source backup job cycle - the selected server stays then unchanged, till the next backup job cycle passes.
arosas
Enthusiast
Posts: 63
Liked: 10 times
Joined: Jun 09, 2015 9:33 pm
Full Name: Tony Rosas
Contact:

Re: SQL Log Shipping Server Selection

Post by arosas »

Thanks for the response. Is there a way to find out which server is assigned after the next backup job cycle passes?
foggy
Veeam Software
Posts: 21070
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Log Shipping Server Selection

Post by foggy »

Seems you're somehow confusing log shipping server with guest interaction proxy in the job session. I'm not sure log shipping server name is displayed there, since there could be several shipping servers selected for different databases within a single job.
Post Reply

Who is online

Users browsing this forum: Bing [Bot], marcin.dudziak, mbrzezinski and 150 guests