Restore a database in a SQL AlwaysOn

Discussions specific to VMware vSphere hypervisor

Restore a database in a SQL AlwaysOn

Veeam Logoby SeRo » Tue Apr 11, 2017 3:52 pm


I have a question about a database restore in a sql always on cluster. When I restore a database into an existing always on cluster, is it important to choose a specific server? How do veeam check on which instance the database is online?

Service Provider
Posts: 13
Liked: never
Joined: Fri Mar 31, 2017 8:17 am

Re: Restore a database in a SQL AlwaysOn

Veeam Logoby foggy » Wed Apr 12, 2017 2:48 pm

If you are talking about restore to alternative location, then database will be restored to the primary node. In case of restore to original location, the original SQL server instance hosting the database will be used (if a database with the same name exists on target, it will be deleted and replaced by the database from backup).
Veeam Software
Posts: 16306
Liked: 1302 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Return to VMware vSphere

Who is online

Users browsing this forum: No registered users and 19 guests