Post reply

Restoring a database on clustered sql server

  • 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.

  • March 5, 2014 at 9:44 am

    #1694384

    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.

  • March 5, 2014 at 9:50 am

    #1694388

    Just do it on the active node.

    --

    SQLBuddy

  • March 5, 2014 at 9:55 am

    #1694391

    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.

  • March 5, 2014 at 10:06 am

    #1694399

    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

  • March 7, 2014 at 9:04 am

    #1695151

    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."

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

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