dbTalk Databases Forums  

Cluster and Instances

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Cluster and Instances in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AA
 
Posts: n/a

Default Cluster and Instances - 08-03-2004 , 01:03 PM






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



Reply With Quote
  #2  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Cluster and Instances - 08-03-2004 , 01:28 PM






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

Quote:
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





Reply With Quote
  #3  
Old   
AA
 
Posts: n/a

Default Re: Cluster and Instances - 08-03-2004 , 01:32 PM



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

Quote:
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







Reply With Quote
  #4  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Cluster and Instances - 08-03-2004 , 02:18 PM



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

Quote:
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









Reply With Quote
  #5  
Old   
AA
 
Posts: n/a

Default Re: Cluster and Instances - 08-03-2004 , 03:42 PM



Thanks!


"Geoff N. Hiten" <SRDBA (AT) Careerbuilder (DOT) com> wrote

Quote:
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











Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.