SQL 2000 Upgrade on Same Server
-
The purchase of a new server was rejected. The existing server is SQL 7.0 and I need to upgrade it to 2000. The MSSQL install and dbs are on the same E: drive, including the programs that access them. The C: drive is too low on space to use for anything.
This is obviously not the ideal situation but I have not choice.
Would the proper way to upgrade be to install 2000 in it's own directory, transfer the databases via some method such as Detach and Reattach, transfer DTS packages and logins, then turn off SQL 7.0? I did not find specific documentation for upgrading when on the same exact machine.
Thanks for the assistance!
-
#1 grab a test machine that you can destroy
#2 after you have wrestled it to within an inch (centimeter) of it's life getting it set-up for your use try
#3 Install SQL 7.0
#4a Upgrade the existing SQL instance to SQL 2K. TEST, TEST, TEST
#4b Install NEW instance of SQL2K (Don't know if it will force you to make it named) Detach/Reattach from SQL 7.0 to SQL2K. Don't forget users, and to change compatibility level on each DB (NOTE DO NOT DO this for SYSTEM DBs). TEST TEST TEST
Good Hunting!AJ Ahrens
webmaster@kritter.net -
Upgrading to SQL2K is straight forward,
1- detach databases
2- install SQL2K and choose upgrade option
3- attach databases
-
One word of advice. In addition to tape backus, if at all possible, copy your mdf and ldf files and/or a current *.bak file off to another safe location - even a workstation if you don't have adequate space on another server. That way if something goes way wrong and you have to restore you're covered.
I concur that the upgrade process itself is pretty straightforward. You can either do a restore or attach after 2000 is installed. SQL Server will recognize it's a 7.0 database and upgrade it while it's restoring or attaching. Best of luck.
My hovercraft is full of eels.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply