February 7, 2003 at 6:34 pm
What is the best method of not only going from SQL7 to SQL2000 but also moving the it to new hardware. I have moved SQL7 to SQL7 between servers via just shutting down both machines and moving the data files to the new machine.
The two machines this time have the same drive layouts (letters) just much bigger and faster drives plus more ram and CPUs on the new machine.
So is it better to upgrade the OLD/CURRENT sql7 server to sql2000 then move the files over to the new SQL 2000 server or is it better to install sql7 on the new machine move the files then upgrade the dbs to 2000?
Is there any potential issue with file names/directories ie:
SQL7 uses g:\MSSQL7\DATA while 2000 uses g:\Microsoft SQL Server\MSSQL\Data
so if I were to upgrade the CURRENT server to SQL2000 then move the files over to the NEW server which is a CLEAN install of SQL 2000 server will I have problems since the files will not be in exactly the same locations (g:\MSSQL7\DATA to g:\Microsoft SQL Server\MSSQL\Data)?
Thanks!
Randy
Edited by - notrub on 02/07/2003 6:37:00 PM
February 8, 2003 at 7:42 am
I'd avoid installing SQL7 on the new machine, why clutter it with the left over stuff you always get from an upgrade? I'd upgrade in place, then move.
Yes, you'll have problems if the folder structure is different. You can fix it by detaching all the db's on the original server, copy to new server, then attach in their new location. Have to alter registry entries for the location of master and msdb, not hard.
Dont know if an option for you, but easier to just leave the folder names the same!
Andy
February 8, 2003 at 8:32 am
Thanks - so you suggest
1. Install the SQL2000 on the new server and define the install directories as they are on the old SQL7 server (letter:\mssql7\data)
2. Upgrade the SQL7 server to SQL2000
3. Move the data files from the upgraded SQL7 server to the clean server with SQL2000
Correct?
February 8, 2003 at 1:08 pm
Not quite.
1 - Upgrade existing server to SQL2000
2 - Install SQL2000 on new server, put your data folder in same place as original server (actually this is usually the parent folder, the one that contains logs, jobs, data, backup).
3 - Stop service on both.
4 - Rename the container folder on new server (just in case you need to backup)
5 - Copy folder from old to new, start service on new machine.
I've got an article posted from quite a ways back that covers parts of this, might be a good starting point.
Andy
February 8, 2003 at 1:23 pm
Thanks!
I was planning on keeping/backing up the CLEAN data folder on the new server.
I have done this before that way but both were running SQL7 so now throwing in a software upgrade made me a bit unsure.
Thanks again!
Randy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply