Any known problems migrating SQL under NT to SQL 2000

Any known problems migrating SQL under NT to SQL 2000

Post by Rand » Fri, 16 Nov 2001 07:37:10

Hi,  Is anyone familiar with any known problems/issues
migrating, in place, Nt to 2000 (Server), then SQL v7 to
SQL 2000 ?



Any known problems migrating SQL under NT to SQL 2000

Post by Jivko Dobrev [M » Sat, 29 Dec 2001 08:00:16

Dear Randy,

Not many known implications exist with the upgrade path that you have
chosen. However, some prerequisites will be needed :
1) Make a full backup of all the databases, including master, model and msdb
2) Stop the SQL Server service and copy the MSSQL7\DATA folder contents as
well as any other database files anywhere else to a secure place
(preferably to another server).

The contingency plan for rollback in case that anything goes wrong is very
simple -
1) Wipe out the machine and reinstall the NT4. Preserve the original drive
letters structure
2) Install cleanly SQL Server 7.0
3) Stop the service and replace the database with the ones created above.
Make sure you preserve the locations
4) Log on as 'sa' and drop and recreate the BUILTIN\Administrators login
and grant it the sysadmin rights to all the dbs. The SID in the SQL Server
sysxlogins will not reflect the newly created local Administrators group

There's an implication that you must be cautioned about. Please take a look
at the KB article Q300676 FIX: Upgrade from SQL 7.0 Aborts w/Messages.sql
Unable to Connect

Hope that this information is useful for you!
Have a wonderful day!
Jivko Dobrev

This posting is provided "AS IS" with no warranties, and confers no rights.


1. Migrate to Win 2000/Sql 2000 from Win Nt/Sql 7.0


Newbie !! Help appreciated

Thanks in advance.

Planning to migrate from NT/SQL Server 7.0 to Win 2000/SQL
Server 2000  ??

Windows configuration  (4 servers - currently 2 cpus)
1) Size of drives
2) How may drives
3) Drive Formats
4) Drive Raids
5) Backups
6) RAM
7) CPU

SQL Server 2000 (4 servers - 10 databases on each - big
one 25 MB (and couple like that))
DSS Primary used for Dataware.

2. Outsource your Oracle Financials support !!!!!!!!!

3. Msg 4424: problems with joined tables when migrating from SQL 7 to SQL 2000

4. Maximum characters per column

5. Migrate from Old SQL 2000 server to a New SQL 2000 server

6. Q: 'Flicker' effect in Forms 5.0.5

7. Question: How to migrate an existing SQL 7 install from NT to 2000

8. Filemaker 4 & Home Page 3

9. Migrating SQL Server 2000 from a development NT domain to a production domain

10. Migrating from Windows NT 4.0 to Windows 2000 with sql server 6.5

11. migrating sql databases from sql 7.0 to sql 2000

12. Problem in migrating from Access 2002 to SQL server 2000

13. Migrating an SQL Server 7.0 database to an SQL Server 2000