Restoring a database on clustered sql server

Question

Restoring a database on clustered sql server

sql_novice_2007

Hall of Fame

Points: 3307
More actions
March 5, 2014 at 9:41 am

#283064

Hi,
I have clustered SQL server machines(SSserver1 and SSserver2). I need to restore a database from another standalone server to this clustered environment. In this case do I need to restore the DB on both the nodes that are part of the clustering(SSserver1 and SSserver2) or Just can I do it on one of them?
Thanks.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Matt Crowley SSCarpal Tunnel Points: 4163 More actions · Answer 1

If it is a regular old fashioned Windows Failover cluster, you only need to restore the database once, and it is stored on the shared storage. If you have an Always On cluster, you will need to restore the database to one of the instances, then add the database to the Availability Group. The GUI will backup the database, and restore it on the other side for you, but it is always nice to at least see the scripts involved.

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 2

SQLBuddy123

One Orange Chip

Points: 28294

March 5, 2014 at 9:50 am

#1694388

Just do it on the active node.

--

SQLBuddy

sql_novice_2007 Hall of Fame Points: 3307 More actions · Answer 3

When I run the following query I got the result 0 which means AlwaysOn Avaialability groups is disabled.

SELECT SERVERPROPERTY ('IsHadrEnabled');

Does that mean restoring on one Node is good enough?

Thanks.

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 4

sql_novice_2007 (3/5/2014)
When I run the following query I got the result 0 which means AlwaysOn Avaialability groups is disabled.
SELECT SERVERPROPERTY ('IsHadrEnabled');
Does that mean restoring on one Node is good enough?
Thanks.

Yes as Matt mentioned.

--

SQLBuddy

The_SQL_DBA SSChampion Points: 10494 More actions · Answer 5

sql_novice_2007 (3/5/2014)
When I run the following query I got the result 0 which means AlwaysOn Avaialability groups is disabled.
SELECT SERVERPROPERTY ('IsHadrEnabled');
Does that mean restoring on one Node is good enough?
Thanks.

For the sake of clarity, if you log on to the node 2 and do not see any databases on it then it isn't a AlwaysOn pair and wouldn't require any action when performing backups/restores on the Active node (primary instance)

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."