Restore a database in a SQL AlwaysOn

VMware specific discussions

Restore a database in a SQL AlwaysOn

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

Hello,

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?

Thanks!
SeRo
Service Provider
 
Posts: 4
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).
foggy
Veeam Software
 
Posts: 14742
Liked: 1080 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 8 guests