![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
I have been installed a cluster SQLSERVER1 and SQLSERVER2\SQL2 When SQL1 fail, SQL2 take the SQL instance and vice-versa My Problem is that the SQLSERVER1 don't have a associated instance like SQL2 I want to configure my SQLSERVER1 to access through the instance name = SQLSERVER1\SQL1 I need to reinstall the SQLSERVER1? or exists something to set the default instance to a particular instance? Thanks a lot AA |
#3
| |||
| |||
|
|
You will need to reinstall SQL and create a new instance. If you have enough disk devices you can create the new instance, detach the databases from the default instance. Copy the files or reassign the device within cluster manager to the new resource group and attach them to the new instance. -- Geoff N. Hiten Microsoft SQL Server MVP Senior Database Administrator Careerbuilder.com I support the Professional Association for SQL Server www.sqlpass.org "AA" <aa (AT) personal (DOT) net.py> wrote in message news:uZ4ByXYeEHA.2812 (AT) tk2msftngp13 (DOT) phx.gbl... I have been installed a cluster SQLSERVER1 and SQLSERVER2\SQL2 When SQL1 fail, SQL2 take the SQL instance and vice-versa My Problem is that the SQLSERVER1 don't have a associated instance like SQL2 I want to configure my SQLSERVER1 to access through the instance name = SQLSERVER1\SQL1 I need to reinstall the SQLSERVER1? or exists something to set the default instance to a particular instance? Thanks a lot AA |
#4
| |||
| |||
|
|
Thanks, So, I reinstall and create a new instance but. How can I "uninstall" the previous instance? Thanks again "Geoff N. Hiten" <SRDBA (AT) Careerbuilder (DOT) com> wrote in message news:eFNF3eYeEHA.3684 (AT) TK2MSFTNGP09 (DOT) phx.gbl... You will need to reinstall SQL and create a new instance. If you have enough disk devices you can create the new instance, detach the databases from the default instance. Copy the files or reassign the device within cluster manager to the new resource group and attach them to the new instance. -- Geoff N. Hiten Microsoft SQL Server MVP Senior Database Administrator Careerbuilder.com I support the Professional Association for SQL Server www.sqlpass.org "AA" <aa (AT) personal (DOT) net.py> wrote in message news:uZ4ByXYeEHA.2812 (AT) tk2msftngp13 (DOT) phx.gbl... I have been installed a cluster SQLSERVER1 and SQLSERVER2\SQL2 When SQL1 fail, SQL2 take the SQL instance and vice-versa My Problem is that the SQLSERVER1 don't have a associated instance like SQL2 I want to configure my SQLSERVER1 to access through the instance name = SQLSERVER1\SQL1 I need to reinstall the SQLSERVER1? or exists something to set the default instance to a particular instance? Thanks a lot AA |
#5
| |||
| |||
|
|
Look at 'Maintaining a Failover Cluster' topic in BOL. -- Geoff N. Hiten Microsoft SQL Server MVP Senior Database Administrator Careerbuilder.com I support the Professional Association for SQL Server www.sqlpass.org "AA" <aa (AT) personal (DOT) net.py> wrote in message news:e9W56nYeEHA.3632 (AT) TK2MSFTNGP11 (DOT) phx.gbl... Thanks, So, I reinstall and create a new instance but. How can I "uninstall" the previous instance? Thanks again "Geoff N. Hiten" <SRDBA (AT) Careerbuilder (DOT) com> wrote in message news:eFNF3eYeEHA.3684 (AT) TK2MSFTNGP09 (DOT) phx.gbl... You will need to reinstall SQL and create a new instance. If you have enough disk devices you can create the new instance, detach the databases from the default instance. Copy the files or reassign the device within cluster manager to the new resource group and attach them to the new instance. -- Geoff N. Hiten Microsoft SQL Server MVP Senior Database Administrator Careerbuilder.com I support the Professional Association for SQL Server www.sqlpass.org "AA" <aa (AT) personal (DOT) net.py> wrote in message news:uZ4ByXYeEHA.2812 (AT) tk2msftngp13 (DOT) phx.gbl... I have been installed a cluster SQLSERVER1 and SQLSERVER2\SQL2 When SQL1 fail, SQL2 take the SQL instance and vice-versa My Problem is that the SQLSERVER1 don't have a associated instance like SQL2 I want to configure my SQLSERVER1 to access through the instance name = SQLSERVER1\SQL1 I need to reinstall the SQLSERVER1? or exists something to set the default instance to a particular instance? Thanks a lot AA |
![]() |
| Thread Tools | |
| Display Modes | |
| |