Rebuilding master with multiple instances

When having to rebuild the master database (using SQL 2K), and their is
more than one instance of SQL Server running, how do you specify the
appropriate instance to rebuild?
Message posted via http://www.sqlmonster.com
I believe SERVER is one of the parameters.
Sincerely,
Anthony Thomas

"Robert Richards via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:4d7df593846d4924bd55c0797e2e9544@.SQLMonster.c om...
When having to rebuild the master database (using SQL 2K), and their is
more than one instance of SQL Server running, how do you specify the
appropriate instance to rebuild?
Message posted via http://www.sqlmonster.com

Rebuilding master with multiple instances

When having to rebuild the master database (using SQL 2K), and their is
more than one instance of SQL Server running, how do you specify the
appropriate instance to rebuild?
Message posted via http://www.droptable.comI believe SERVER is one of the parameters.
Sincerely,
Anthony Thomas
"Robert Richards via droptable.com" <forum@.droptable.com> wrote in message
news:4d7df593846d4924bd55c0797e2e9544@.SQ
droptable.com...
When having to rebuild the master database (using SQL 2K), and their is
more than one instance of SQL Server running, how do you specify the
appropriate instance to rebuild?
Message posted via http://www.droptable.com

Rebuilding master with multiple instances

When having to rebuild the master database (using SQL 2K), and their is
more than one instance of SQL Server running, how do you specify the
appropriate instance to rebuild?
--
Message posted via http://www.sqlmonster.comI believe SERVER is one of the parameters.
Sincerely,
Anthony Thomas
"Robert Richards via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:4d7df593846d4924bd55c0797e2e9544@.SQLMonster.com...
When having to rebuild the master database (using SQL 2K), and their is
more than one instance of SQL Server running, how do you specify the
appropriate instance to rebuild?
--
Message posted via http://www.sqlmonster.comsql

rebuild sql services; making an instance the default

When installing Dotnet, wound up with TWO Named SQL Server instances for use
by the sample apps. When trying to uninstall the extraneous one, I screwed
up and selected the one I wanted to keep. Canceled the uninstall. Server is
still there. Can start up manually and connect to it. However, the
service(s) got whacked before I canceled out.
Two questions.
1) Can the services be rebuilt by hand?
2) If I can get the single (named) instance working, can I turn it into the
default instance? My sole purpose was to be able to test the DotNet sample
apps, all of which are hardwired to connect to local. It's becoming quite a
nuisance to fix them all.
Any suggestions would be greatly appreciated. TIADo you have the database files still there? I.e., the mdf, ldf and possibly
ndf. If so, just use sp_attach_db to attach the database files to get each
database into your desired instance. You can not rename an instance, so you
need to install a named instance.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Ron Foster" <rlfoster1@.cox.net> wrote in message
news:%23nvQjkbvDHA.2316@.TK2MSFTNGP10.phx.gbl...
> When installing Dotnet, wound up with TWO Named SQL Server instances for
use
> by the sample apps. When trying to uninstall the extraneous one, I screwed
> up and selected the one I wanted to keep. Canceled the uninstall. Server
is
> still there. Can start up manually and connect to it. However, the
> service(s) got whacked before I canceled out.
>
> Two questions.
> 1) Can the services be rebuilt by hand?
> 2) If I can get the single (named) instance working, can I turn it into
the
> default instance? My sole purpose was to be able to test the DotNet sample
> apps, all of which are hardwired to connect to local. It's becoming quite
a
> nuisance to fix them all.
>
> Any suggestions would be greatly appreciated. TIA
>|||Thanks for the response.
Yes, I still have the entire named instance available, and can connect to
it.
What I lost was the services to start/stop/pause it. Currently am having to
start it manually in a cmd box.
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:OVXpctbvDHA.2000@.TK2MSFTNGP11.phx.gbl...
> Do you have the database files still there? I.e., the mdf, ldf and
possibly
> ndf. If so, just use sp_attach_db to attach the database files to get each
> database into your desired instance. You can not rename an instance, so
you
> need to install a named instance.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Ron Foster" <rlfoster1@.cox.net> wrote in message
> news:%23nvQjkbvDHA.2316@.TK2MSFTNGP10.phx.gbl...
> > When installing Dotnet, wound up with TWO Named SQL Server instances for
> use
> > by the sample apps. When trying to uninstall the extraneous one, I
screwed
> > up and selected the one I wanted to keep. Canceled the uninstall. Server
> is
> > still there. Can start up manually and connect to it. However, the
> > service(s) got whacked before I canceled out.
> >
> >
> >
> > Two questions.
> >
> > 1) Can the services be rebuilt by hand?
> >
> > 2) If I can get the single (named) instance working, can I turn it into
> the
> > default instance? My sole purpose was to be able to test the DotNet
sample
> > apps, all of which are hardwired to connect to local. It's becoming
quite
> a
> > nuisance to fix them all.
> >
> >
> > Any suggestions would be greatly appreciated. TIA
> >
> >
>sql

Rebuild fulltext

Hi!
I have a problem with a 4-node cluster. It was a 2-node sql2k on w2k.
We installed new hw with w2k3 and installed the old instances there
(restore). After that we added 2 more w2k3 nodes and installed the
original 2 instances on all 4 nodes. We also set up 2 new instances to
be a total of 4.
The problem is that when we put in the new hw (node 3 and 4) we saw
that we lost the control of the fulltext resource on the first 2
instances. It started failing and then failback, sometimes it started,
sometimes not. This started before we actually joined node 3-4 to the
clustrer. Since we don't use fulltext we took away the resource from
the cluster on these 2 instances. On the new instances (3 and 4) there
has newer been a problem. All nodes can run all 4 instances. There is
no problem with any other resource.
I have seen kb 812666 and I think that I should try rebuildning
fulltext. I think it looks very complex, is there anyone that have
done this?
/Peter
Peter,
Yes, KB article 812666 "How to recover a failed full-text search resource on
a clustered instance of SQL Server 2000" at
http://support.microsoft.com/default.aspx?kbid=812666 is complex, but since
you don't use the MSSearch (Fulltext ) service, and have already removed the
fulltext (Microsoft Search) service from the cluster resource, rebuilding
this service is not necessary/
Note, you can also post FTS related questions to the newsgroup:
microsoft.public.sqlserver.fulltext
Regards,
John
"Peter Lindberg" <peter.lindbergTAKE@.AWAYmartinsson.se> wrote in message
news:415bfda4.4507871@.msnews.microsoft.com...
> Hi!
> I have a problem with a 4-node cluster. It was a 2-node sql2k on w2k.
> We installed new hw with w2k3 and installed the old instances there
> (restore). After that we added 2 more w2k3 nodes and installed the
> original 2 instances on all 4 nodes. We also set up 2 new instances to
> be a total of 4.
> The problem is that when we put in the new hw (node 3 and 4) we saw
> that we lost the control of the fulltext resource on the first 2
> instances. It started failing and then failback, sometimes it started,
> sometimes not. This started before we actually joined node 3-4 to the
> clustrer. Since we don't use fulltext we took away the resource from
> the cluster on these 2 instances. On the new instances (3 and 4) there
> has newer been a problem. All nodes can run all 4 instances. There is
> no problem with any other resource.
> I have seen kb 812666 and I think that I should try rebuildning
> fulltext. I think it looks very complex, is there anyone that have
> done this?
> /Peter
|||John,
thanks for the reply. My intention is to get all 4 nodes equal setup.
We want to be able to run new databases where it's best suitet and
don't depend on differenses between instances. That's way I want to do
this. I have to set up my test environment so I can test it before I
go in the production.
Have you done this in a cluster?
/Peter
On Thu, 30 Sep 2004 11:19:01 -0700, "John Kane" <jt-kane@.comcast.net>
wrotc:

>Peter,
>Yes, KB article 812666 "How to recover a failed full-text search resource on
>a clustered instance of SQL Server 2000" at
>http://support.microsoft.com/default.aspx?kbid=812666 is complex, but since
>you don't use the MSSearch (Fulltext ) service, and have already removed the
>fulltext (Microsoft Search) service from the cluster resource, rebuilding
>this service is not necessary/
>Note, you can also post FTS related questions to the newsgroup:
>microsoft.public.sqlserver.fulltext
>Regards,
>John
>
>
>"Peter Lindberg" <peter.lindbergTAKE@.AWAYmartinsson.se> wrote in message
>news:415bfda4.4507871@.msnews.microsoft.com...
>
|||You're welcome, Peter,
Unfortunately, I do not have a clustered environment to test this KB
article, as I have only one home server and a laptop... ;-(
If you do have a test clustered environment, even one with just two nodes,
I'd recommend that you test using that environment.
Regards,
John
"Peter Lindberg" <peter.lindbergTAKE@.AWAYmartinsson.se> wrote in message
news:415d70eb.31078308@.msnews.microsoft.com...[vbcol=seagreen]
> John,
> thanks for the reply. My intention is to get all 4 nodes equal setup.
> We want to be able to run new databases where it's best suitet and
> don't depend on differenses between instances. That's way I want to do
> this. I have to set up my test environment so I can test it before I
> go in the production.
> Have you done this in a cluster?
> /Peter
> On Thu, 30 Sep 2004 11:19:01 -0700, "John Kane" <jt-kane@.comcast.net>
> wrotc:
on[vbcol=seagreen]
since[vbcol=seagreen]
the
>
|||I'll definitive test it. It will be under vmware gsx.
/Peter
On Mon, 4 Oct 2004 10:57:02 -0700, "John Kane" <jt-kane@.comcast.net>
wrotc:

>You're welcome, Peter,
>Unfortunately, I do not have a clustered environment to test this KB
>article, as I have only one home server and a laptop... ;-(
>If you do have a test clustered environment, even one with just two nodes,
>I'd recommend that you test using that environment.
>Regards,
>John
>
>"Peter Lindberg" <peter.lindbergTAKE@.AWAYmartinsson.se> wrote in message
>news:415d70eb.31078308@.msnews.microsoft.com...
>on
>since
>the
>