Standalone backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)
Post Reply
hnhn99
Enthusiast
Posts: 26
Liked: 3 times
Joined: Feb 03, 2017 7:17 am
Full Name: Hakan Hedman
Contact:

always on SQL restore

Post by hnhn99 »

When I try restore in my always on SQL environment, the sql agent seems to want to connect with the replication network that is private and no routing to. How to control this?
DCOM was unable to communicate with the computer xxxx using any of the configured protocols; requested by PID 49f8 (D:\Veeam\Backup & replication\Explorers\SQL\Veeam.SQL.Explorer.exe).
case:07015228
Andreas Neufert
VP, Product Management
Posts: 7242
Liked: 1552 times
Joined: May 04, 2011 8:36 am
Full Name: Andreas Neufert
Location: Germany
Contact:

Re: always on SQL restore

Post by Andreas Neufert »

Maybe try to address this by changing the DNS records on the server where the explorer and the mount server + Veeam backup server is located and point it to the correct address. Maybe by hosts file edit on the 3 servers.
marina.skobeleva
Veeam Software
Posts: 50
Liked: 20 times
Joined: Feb 10, 2020 1:48 pm
Full Name: Marina Skobeleva
Contact:

Re: always on SQL restore

Post by marina.skobeleva »

Hi Hakan,

First of all, you need to make sure that Veeam Explorer for Microsoft SQL Server can access all nodes in the availability group. More details are here.

When you create an Always on Availability Group there is a setting for EndPoint URLs. Probably Microsoft guide will be helpful for this case. The main idea that IP addresses to which these endpoints are resolved should be available for Veeam Explorer for Microsoft SQL Server.

Thanks!
hnhn99
Enthusiast
Posts: 26
Liked: 3 times
Joined: Feb 03, 2017 7:17 am
Full Name: Hakan Hedman
Contact:

Re: always on SQL restore

Post by hnhn99 »

So just to verify veeam dosen't support SQL cluster with an private unrouted replication network?
Andreas Neufert
VP, Product Management
Posts: 7242
Liked: 1552 times
Joined: May 04, 2011 8:36 am
Full Name: Andreas Neufert
Location: Germany
Contact:

Re: always on SQL restore

Post by Andreas Neufert » 1 person likes this post

Why do you think this is the case? The above indicates that the EndPoint URLs are not bound to "public" accessible interfaces or DNS goes to the wrong IPs.
Post Reply

Who is online

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