reinstalling SQL 2000 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

reinstalling SQL 2000

hi<br /><br />I want to reinstall SQL 2k(sp3) on different directory( f<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /> on same machine which has SQL 2k on c:/.<br />should I move system databases(master,msdb and model) first and then reintall SQL 2k or install it before and then move. which is the best way??.<br /><br />Thank you<br />yama
If you want to change the drive for the SQL binaries means its better to reinstall the SQL server alongwith SP3, rather detaching and attaching the system & user databases. I found reinstal is the quickest than other. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Hi, After reinstalling,how do I move all other things if I didnt detach-attach system DBs.
Should I use following procedure??(from MS)…its a lengthy process than detach-attach?? what do you suggest??
yama HOW TO: Move Databases Between Computers That Are Running SQL Server
This article applies to…
This article was previously published under Q314546
IN THIS TASK
SUMMARY Step 1: How to Move User Databases
Step 2: How to Transfer Logins and Passwords
Step 3: How to Resolve Orphaned Users
Step 4: How to Move Jobs, Alerts and Operators
Step 5: How to Move DTS Packages
MORE INFORMATION
REFERENCES
SUMMARY
If you’re comfortable with the detach & attach process then simply follow the KB article referred by you. I’d noted down the sort order and other details from master database and took full backups for all the databases including system and stored at other location. And followed as stated by Vyashttp://vyaskn.tripod.com/moving_sql_server.htm in his link. HTH _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Thank you Satya,<br /><br />one more Qn –<br /><br />After installing to new location (F<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />, <br />Is it perfectly fine to use old DB’s system files(copy and paste)???<br />(assuming that version is same).<br />And then attach the user DB’s??<br /><br />Thank you<br />yama
BTW, don’t forget to update statistics in any method you choose. Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
yes. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>