| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2010-12-30 : 12:21:28
|
| We are producing a recovery guide for two servers. Servers are in cluster (sql server 2005, windows 2003), in case of Disaster we need to build 2 standalone cluster instead of one cluster. Any help in this regard will appreciated.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2010-12-30 : 14:32:18
|
| Tara thanks for reply. Its client requirement, may be they will add another node later on. Right now it is active/passive cluster, only one instance. May be they will use second computer for any other prupose. I just need steps/guide how to install sql server as standalone cluster, what important things I should note before/after installation. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2010-12-30 : 16:40:50
|
| Thanks,As we will recover the standalone cluster, I have following questins:1. Right now cluster is using one ip address and cluster name, how we will split into two standalone clusters? So application can connect them.2. how to restore system databases before restoring user databases? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-01-04 : 17:25:42
|
| After disaster both nodes destroyed, we have backups on network. Now windows team installed os and build cluster on one node (new computer) as stand alone cluster. SQL team will install sql server and sp. Now we have to restore system and user datbases on new build cluster node through netbackup. This new node will use same cluster name and drive letters for storage. I serached google but what I am looking for (rebuilt and recover cluster), I did not find. Any help? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-01-05 : 11:00:43
|
| how to restore system databases (master, msdb etc) on this new rebuilt cluster node from netbackup? Is there any thing I should take care so client should connect without any issue? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-01-05 : 14:28:42
|
| Thanks for your help. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
hftmrock
Starting Member
2 Posts |
Posted - 2011-06-13 : 08:24:56
|
| I am not sure anyone is looking at this thread anymore but I will say that restoring a cluster to a standalone is a very frustrating thing if you are restoring the entire server. If you have 2 nodes (N1 and N2) and at your disaster recovery site you try to restore them both as standalone servers here is the issues you will have.When we restore a server that has a standalone instance of SQL Server, We restore the filesystems and files first, then the Server has the SQL Server program files but not the databases. You cant restore the databases yet because SQL is not in a working condition. You have to rebuild the master database and then restore the master (and then other system databases). If all goes well, you then restore the customer databases and all should be ok.The problem with the cluster is that if you restore the file systems, it thinks that it is a cluster and you will not be able to rebuild master or turn it into a standalone server. You have 2 options at this point. 1 - you can have a fresh OS and not restore any files and install a fresh copy of sql server (same version and patch level). Then you can restore master (and system databases) and then the customer databases and it will be a standalone instance.2 - If you are starting with a server that has the filesystem and files restored already, you can attempt to uninstall SQL Server but this can get messy and can be painful. You delete all the folders that are sql server related. Then you have to remove all the registry entries. I recommend a tool like CC Cleaner to remove all the registry entries of SQL Server. If that goes well you can install sql server and then restore the databases. I have to say I have worked on restoring SQL Servers from a cluster to a standalone probably 100 times in my time at my company over the years and do not know of a better way to do this. |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-06-13 : 18:07:38
|
| Hi hfmrock,Thanks for sharing. In our case we have option 1. We will reinstall fresh os and sql server and then restore databases. |
|
|
|
hftmrock
Starting Member
2 Posts |
Posted - 2011-06-14 : 10:32:06
|
| no worries then.. done it many times. pretty easy. |
|
|
|
|
Breaking cluster into 2 standalone cluster instanc