April 24, 2002 at 4:03 am
I have upgraded a test installation of SQL7 to SQL2k. I notice that after installation, the old C:\MSSQL7 subdirectory and files are still retained, with the new SQL2k files installed to C:\Program Files\Microsoft SQL Server\. Wondering if the old MSSQL7 subdirectory could be deleted, I renamed it to C:\MSSQL7_OLD, rebooted, and find that the SQL2k services and programs do not run.
Is this normal or did I miss something during the upgrade?
April 24, 2002 at 4:10 am
This is normal, the data files should still be in the old 7 path, they did not get moved. Also most things like log files are not moved as well. When you changed the path 2K could not access the master and other system databases is why it failed.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 24, 2002 at 4:21 am
Our databases (including master, msdb, etc) and log files are located on a separate drive from the program files - D:\MSSQL7\Data and D:\MSSQL7\Log.
Is this normal for SQL2k to keep and use C:\MSSQL7 files? Seems rather messy.
April 24, 2002 at 5:12 am
I still think something is left in one of the subfolders that is causing this. You stated the log files are on a seperate drive. I am refering to the SQLServerLog files which are generated in the LOG subfolder unless you changed the path in the SQL Servers startup options. To find out for sure if it is not just some file that data, errors, or other items are stored in rename the main folder back and then do each subfolder individually to see if a particular folder is the problem. MS is notorious for app upgrades to leave something in use from the previous but I do not know specifically what may be the case here as I try to install clean and of the few servers that went from 7 to 2000 that was the case.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 24, 2002 at 6:11 am
I shut down the server, restarted, then did a DIR /OD /TA /S
(order date, last access date, all subdirs) in C:\MSSQL7, and trimmed out all the files with old dates. Here are the files that are still being accessed by the system. Note: we are not running SQL7 at all on this server, only SQL2k. No replication either. All the files appear to be program files. Can this be correct? Thanks for your help.
Directory of C:\Mssql7\Binn
04/24/02 01:33p 7,442,513 sqlservr.exe
04/24/02 01:33p 24,639 opends60.dll
04/24/02 01:33p 49,228 ums.dll
04/24/02 01:33p 590,396 sqlsort.dll
04/24/02 01:33p 32,825 sqlboot.dll
04/24/02 01:33p 86,588 ssnetlib.dll
04/24/02 01:33p 25,148 ssnmpn70.dll
04/24/02 01:33p 29,244 ssmslpcn.dll
04/24/02 01:33p 303,680 sqlagent.exe
04/24/02 01:33p 29,248 sqlresld.dll
04/24/02 01:33p 94,784 sqlsvc.dll
04/24/02 01:33p 49,216 w95scm.dll
04/24/02 01:33p 62,016 semmap.dll
04/24/02 01:33p 28,672 sqlagent.dll
04/24/02 01:33p 24,643 xpsqlbot.dll
04/24/02 01:33p 53,824 sqlcmdss.dll
04/24/02 01:33p 33,344 sqlrepss.dll
04/24/02 01:33p 45,632 sqlatxss.dll
166 File(s) 42,676,629 bytes
Directory of C:\Mssql7\Binn\Resources\1033
04/24/02 01:33p 28,672 sqlevn70.rll
04/24/02 01:33p 24,576 sqlsvc.rll
04/24/02 01:33p 32,768 semmap.rll
04/24/02 01:33p 49,152 sqlagent.rll
04/24/02 01:33p 12,288 sqlcmdss.rll
04/24/02 01:33p 24,576 sqlrepss.rll
04/24/02 01:33p 24,576 sqlatxss.rll
40 File(s) 6,840,389 bytes
Directory of C:\Mssql7\Install
04/24/02 01:20p 21,829 replmerg.out
April 24, 2002 at 6:11 am
I shut down the server, restarted, then did a DIR /OD /TA /S
(order date, last access date, all subdirs) in C:\MSSQL7, and trimmed out all the files with old dates. Here are the files that are still being accessed by the system. Note: we are not running SQL7 at all on this server, only SQL2k. No replication either. All the files appear to be program files. Can this be correct? Thanks for you help.
Directory of C:\Mssql7\Binn
04/24/02 01:33p 7,442,513 sqlservr.exe
04/24/02 01:33p 24,639 opends60.dll
04/24/02 01:33p 49,228 ums.dll
04/24/02 01:33p 590,396 sqlsort.dll
04/24/02 01:33p 32,825 sqlboot.dll
04/24/02 01:33p 86,588 ssnetlib.dll
04/24/02 01:33p 25,148 ssnmpn70.dll
04/24/02 01:33p 29,244 ssmslpcn.dll
04/24/02 01:33p 303,680 sqlagent.exe
04/24/02 01:33p 29,248 sqlresld.dll
04/24/02 01:33p 94,784 sqlsvc.dll
04/24/02 01:33p 49,216 w95scm.dll
04/24/02 01:33p 62,016 semmap.dll
04/24/02 01:33p 28,672 sqlagent.dll
04/24/02 01:33p 24,643 xpsqlbot.dll
04/24/02 01:33p 53,824 sqlcmdss.dll
04/24/02 01:33p 33,344 sqlrepss.dll
04/24/02 01:33p 45,632 sqlatxss.dll
166 File(s) 42,676,629 bytes
Directory of C:\Mssql7\Binn\Resources\1033
04/24/02 01:33p 28,672 sqlevn70.rll
04/24/02 01:33p 24,576 sqlsvc.rll
04/24/02 01:33p 32,768 semmap.rll
04/24/02 01:33p 49,152 sqlagent.rll
04/24/02 01:33p 12,288 sqlcmdss.rll
04/24/02 01:33p 24,576 sqlrepss.rll
04/24/02 01:33p 24,576 sqlatxss.rll
40 File(s) 6,840,389 bytes
Directory of C:\Mssql7\Install
04/24/02 01:20p 21,829 replmerg.out
April 24, 2002 at 5:12 pm
Check out the following KB Article about 6.5 upgrade to 7 http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q236989, I bet that it follows suite in 7 to 2000. Most likely Microsoft just assumes that the upgrade should be done to the existing path as it may have been a custom choice previously and they don't want to upset some customers. Also, I would be curious what items are in the other folder and if you had done a custom install if it would have put all in the same place, emptying the old 7 directory. I may try one day when I get chance and can wipe my local box or have a free test box.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply