August 2, 2010 at 2:58 pm
Hi,
I'd like to create do multi-instances SQL Server 2005 install on one physical server that is going to be a DR (disaster recovery) SQL server for the a few production servers.
Is it possible to use the SQL Server 2005 Aliases in the configuration manager?
How to configure them?
The production SQL servers:
Server name= Prod1; SQL instance name=SQL1 (Prod1\SQL1)
Server name= Prod2; SQL instance name=SQL1 (Prod2\SQL1)
Server name= Prod3; SQL instance name=SQL1 (Prod3\SQL1)
The DR SQL Servers:
Server name= DR1; SQL instance name=SQL1 (DR1\SQL1)
SQL instance name=SQL2 (DR1\SQL2)
SQL instance name=SQL3 (DR1\SQL3)
The Prod1\SQL1 connections (calls) goes to DR1\SQL1
The Prod2\SQL1 connections (calls) goes to DR1\SQL2
The Prod3\SQL1 connections (calls) goes to DR1\SQL3
Thank you for your help,
LY
November 9, 2010 at 10:05 am
Are you trying to setup Database Mirroring / Replication / Log Shipping ? Please be specific.
November 9, 2010 at 10:43 am
leonid.yakhkind (8/2/2010)
Hi,I'd like to create do multi-instances SQL Server 2005 install on one physical server that is going to be a DR (disaster recovery) SQL server for the a few production servers.
Is it possible to use the SQL Server 2005 Aliases in the configuration manager?
How to configure them?
The production SQL servers:
Server name= Prod1; SQL instance name=SQL1 (Prod1\SQL1)
Server name= Prod2; SQL instance name=SQL1 (Prod2\SQL1)
Server name= Prod3; SQL instance name=SQL1 (Prod3\SQL1)
The DR SQL Servers:
Server name= DR1; SQL instance name=SQL1 (DR1\SQL1)
SQL instance name=SQL2 (DR1\SQL2)
SQL instance name=SQL3 (DR1\SQL3)
The Prod1\SQL1 connections (calls) goes to DR1\SQL1
The Prod2\SQL1 connections (calls) goes to DR1\SQL2
The Prod3\SQL1 connections (calls) goes to DR1\SQL3
Thank you for your help,
LY
yes, alias will work. you will have to create them on Prod1, Prod2 and Prod3.
on Prod1, create an alias called DR1\SQL1 for instalce SQL1 (or vice vera, not sure if i got your explanation right)
on Prod2, create an alias called DR1\SQL2 for instalce SQL2... etc.....
I think that is your naming strategy :ermm:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply