March 27, 2003 at 9:32 am
Hi,
I am about to upgrade an SQL 7 SP4 to SQL 2000 SP3. The OS is NT4 SP6. I am using the Enterprise Edition.
My questions are:
Anyone encountered any problems using SQL 2000 on NT4?
What upgrade option do you recommend? I only need to use one instance on the same server.
Also, the SQL 7 was upgraded from 6.5 about two years ago. Although I have not experienced any problems related to that upgrade.
Thanks!
/Minh
March 27, 2003 at 9:52 am
Upgrade from 7.0 to 2000 will upgrade all program files and all data stored in SQL Server 7.0 databases is preserved. If you want to come back 7.0, make sure you have good backups.
After you upgrade from SQL Server 7.0 to SQL Server 2000, it is recommended that you repopulate full-text catalogs and update statistics.
Run setup and choose upgrade in installation selection and default instance installation.
March 27, 2003 at 10:19 am
also if you have replication set on the server, remember to backup the published db, before applying the Service pack 3 for SQL2000.
And read carefully the read me file of the SP3 if you have define Master/Target servers.
March 27, 2003 at 12:55 pm
A good option if you need to test the upgrade is to install SQL Server 2000 as a named instance and copy the database to the new instance. If everything works ok you can stop the old SQL 7 instance and change all apps to use the new instance. If you have trouble you still have the old instance.
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
March 27, 2003 at 1:23 pm
Very good suggestion. In order for your client to work with named instance, you have to upgrade client MDAC to version 2.6 at least.
March 28, 2003 at 12:25 am
Thanks for your advice guys/gals. My first upgrade choice will probably be install 2000 over 7 (default instance). I will of course have to test it out first before going live.
Since there are more than one server that is to be upgraded, I want to minimize the impact of the changes. That's the reason why I haven't (yet) recommended the server administrators to upgrade from NT4 to W2K. But I have somewhere deep deep in my memory that SQL2000 does not work well on NT4. That is unconfirmed and will be tested but I wanted to see here if anyone is using this combination.
/Minh
March 28, 2003 at 1:45 am
I don't know of any common problems running SQL 2000 on NT4 and have done so myself without trouble. One thing to note however is that SQL 2000 will update your MDAC version (if you haven't done so manually already), which might lead to trouble with some clients running a different version of MDAC.
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply