Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Reinstalling SQL 2000?

Author  Topic 

interclubs
Yak Posting Veteran

63 Posts

Posted - 2004-05-10 : 14:34:37
Is there anyway to reinstall SQL w/o having to first uninstall it? Don't know if I can go thru the process of creating all the DBs and adding in users again...

Thanks!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-05-10 : 15:46:39
No. Just detach your databases, uninstall SQL Server, reinstall it, then attach the databases. You won't have to recreate the users, jobs, DTS packages, or anything as everything will be there once you attach them back. Just don't forget the system databases.

http://support.microsoft.com/default.aspx?scid=kb;en-us;224071&Product=sql2k

Tara
Go to Top of Page

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2004-05-11 : 10:01:00
duggan,

Is it required to detach the Databases?



------------------------
I think, therefore I am
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-05-11 : 10:12:31
No, but it's a good idea if you want to use them again.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2004-05-11 : 11:12:41
quote:
Originally posted by derrickleggett

No, but it's a good idea if you want to use them again.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.




When life gives you a lemon, fire the DBA....off the record..what does that mean?

------------------------
I think, therefore I am
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-05-11 : 11:22:12
:) I have NO IDEA!!!

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -