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
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@.personal.net.py> wrote in message
news:uZ4ByXYeEHA.2812@.tk2msftngp13.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
>
|||Thanks, So, I reinstall and create a new instance but. How can I "uninstall"
the previous instance?
Thanks again
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:eFNF3eYeEHA.3684@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> 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@.personal.net.py> wrote in message
> news:uZ4ByXYeEHA.2812@.tk2msftngp13.phx.gbl...
> SQL2
default
>
|||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@.personal.net.py> wrote in message
news:e9W56nYeEHA.3632@.TK2MSFTNGP11.phx.gbl...
> Thanks, So, I reinstall and create a new instance but. How can I
"uninstall"[vbcol=seagreen]
> the previous instance?
> Thanks again
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:eFNF3eYeEHA.3684@.TK2MSFTNGP09.phx.gbl...
databases[vbcol=seagreen]
like[vbcol=seagreen]
=
> default
>
|||Thanks!
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uK2hs6YeEHA.1732@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> 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@.personal.net.py> wrote in message
> news:e9W56nYeEHA.3632@.TK2MSFTNGP11.phx.gbl...
> "uninstall"
> databases
within[vbcol=seagreen]
> like
name
> =
>
sqlsql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment