VCS for SQL Server 2008 R2
I need some help and I hope someone here can help me. I am trying to create a disaster recovery cluster for our SQL databases. There are two cluster servers at each location. I have created a cluster in location A with notification option and geocluster option enabled. I created a second cluster in location B also with notification option and geocluster enabled. I have not linked the clusters. I need to install three instances of SQL. I have a few questions though.
- To install three instances of SQL do I link the clusters first?
- Is the installation process (and storage migration) A1 -> A2 and separately B1 -> B2 and geocluster later? or is it geocluster first and install A1 -> A2 -> B1 -> B2?
- Do I repeat this process for EACH instance?
- One of the instances needs to use SQL Reporting services. Can I tie IIS to the SSRS service group? The goal would be that IIS would run on the server hosting SSRS but not on any of the other servers. How would this be done?
All help is appreciated.