SQL Log Shipping Server Selection

Availability for the Always-On Enterprise

SQL Log Shipping Server Selection

Veeam Logoby arosas » Mon Apr 24, 2017 4:56 pm

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?
arosas
Influencer
 
Posts: 21
Liked: 4 times
Joined: Tue Jun 09, 2015 9:33 pm
Full Name: Tony Rosas

Re: SQL Log Shipping Server Selection

Veeam Logoby v.Eremin » Tue Apr 25, 2017 12:52 pm

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.
v.Eremin
Veeam Software
 
Posts: 13546
Liked: 1004 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: SQL Log Shipping Server Selection

Veeam Logoby arosas » Tue Apr 25, 2017 2:22 pm

Thanks for the response. Is there a way to find out which server is assigned after the next backup job cycle passes?
arosas
Influencer
 
Posts: 21
Liked: 4 times
Joined: Tue Jun 09, 2015 9:33 pm
Full Name: Tony Rosas

Re: SQL Log Shipping Server Selection

Veeam Logoby foggy » Tue Apr 25, 2017 3:05 pm

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.
foggy
Veeam Software
 
Posts: 15086
Liked: 1110 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Google Feedfetcher, nmdange, PTide, Shestakov and 101 guests