Post reply

Restoring Master from a clustered server to a stand-alone server?

  • October 11, 2005 at 10:30 am

    #102858

    Good morning,

    I am getting ready to participate in a disaster recovery exercise this week for one of our production SQL boxes. The DR box is at an offsite location. While the real system is an active/passive cluster, the DR will be conducted on a single server. My question is this: can I restore a backup of master from the clustered system onto the standalone system? Does master contain any info about the fact that it is running in a clustered configuration? If it will work OK, great. If not, that's not a problem. Just wanting to see if anyone out there can confirm.

    Thanks,

    James

  • October 12, 2005 at 3:51 am

    #596742

    Hi,

    restoring should be no problem, if the paths to master, model, msdb and tempdb on the dr-server are the same as on the cluster.

    MS SQL Server clustering is mainly an operating system configuration that starts/stops the sql server on different nodes, with shared drives. The sql server itself does not really care if it's clustered or not...

    karl

    Best regards
    karl

  • October 12, 2005 at 8:08 am

    #596815

    Yes you could do that, but look at this first:

    http://www.cryer.co.uk/brian/sqlserver/howtorestorew2ksql2000bkp.htm#RestoreSQLServer2000MasterDatabase

    Vidas

Viewing 3 posts - 1 through 2 (of 2 total)

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