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 master

we have a sql server instance on a 2003 cluster which was built with the
wrong collation. are their any cluster related steps that need to be taken
into consideration when running the rebuild master utility to correct the
collation? we have multiple instances running on the cluster. does the
cluster have to be stopped for instance or would simply shutting down the
specific instance be adequate.
How To Rebuild the MASTER Database on a Virtual SQL Server 2000 Instance
http://support.microsoft.com/default...b;en-us;298568
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"bjones" <bjones@.discussions.microsoft.com> wrote in message
news:325996A5-AF73-45C4-AE59-D1C3FCA24CA1@.microsoft.com...
> we have a sql server instance on a 2003 cluster which was built with the
> wrong collation. are their any cluster related steps that need to be taken
> into consideration when running the rebuild master utility to correct the
> collation? we have multiple instances running on the cluster. does the
> cluster have to be stopped for instance or would simply shutting down the
> specific instance be adequate.
|||The instance is pretty isolated from other instances if you're only touching
stuff inside the database and not at the OS/MSCS level. You can rebuild that
instance's master without hitting the other instances.
joe.
"bjones" <bjones@.discussions.microsoft.com> wrote in message
news:325996A5-AF73-45C4-AE59-D1C3FCA24CA1@.microsoft.com...
> we have a sql server instance on a 2003 cluster which was built with the
> wrong collation. are their any cluster related steps that need to be taken
> into consideration when running the rebuild master utility to correct the
> collation? we have multiple instances running on the cluster. does the
> cluster have to be stopped for instance or would simply shutting down the
> specific instance be adequate.
sql

Re-attaching database

I have upgraded my OS and reinstall a new fresh instance of SQL Server.
Before I backed up my database and saved it on a CD Rom, but now I can't re-attach it to the server. I receive an error message saying the my data file is not an SQL server database server file.

I am afraid of loosing all my data, view and procedures. I really need some help here...

Thanksdid u actually 'back up' or did you copy the data folder onto your CD.|||I back up the database first and copied the back up file on the CD, I did not copy the files from the data folder.

Reasons to go SQL 2005 over SQL 2000

Hi all,

I am working with an outside consultant to upgrade our SQL 7 instance. He wants to upgrade to SQL 2000 and I want to go to SQL 2005. I want to have concrete reasons backed up with documentation as to why we should go SQL 2005 as opposed to SQL 2000.

For eg. support (why 2005 is better, ie. longer support), security(More secure, documentation), management, stability (number of patches released last year) etc.

I'd really appreciate it if someone could point me to an appropriate resource.

Thanks all,

SA.

Online Articles Regarding 2005 Enhancements over 2000

http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx|||Derek thank you for the informative post.

SA.|||

Hi,

This message was a useful one.

Can u throw some light on the cost as well.

regards
Shiv

|||One more thing to note is the product life cycle of Microsoft products. Check out http://www.microsoft.com/sql/support/lifecycle.mspx for more information. Initial cost outlay may be frightening for some but operations and maintenance cost have to be considered as part of your overall cost|||

Bass_player,

Thanks for the info on the lifecycle of Microsoft products.

By mentioning operation and maintenance costs did u mean that it would cost more to support SQL 2000 in the long run since the mainstream support ends much sooner than SQL 2005.

SA3446.

really appreciated.

Is it possible through front end like I can call DTS package on demand like
on button click.. for instance on button PUSH click I want to call Package1
and on button PULL click I want to call Package2... how can it be possible?
any help is available ?
I would really appreciate....
Thanks
Try SQLDTS.com. There you will find examples of invoking DTS packages from
VB, ASP, .NET languages etc.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Roy" <roy@.hotmail.com> wrote in message
news:%23n3rRKWcFHA.1448@.TK2MSFTNGP14.phx.gbl...
Is it possible through front end like I can call DTS package on demand like
on button click.. for instance on button PUSH click I want to call Package1
and on button PULL click I want to call Package2... how can it be possible?
any help is available ?
I would really appreciate....
Thanks