Hi, Is anyone familiar with any known problems/issues
migrating, in place, Nt to 2000 (Server), then SQL v7 to
SQL 2000 ?
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
1) Wipe out the machine and reinstall the NT4. Preserve the original drive
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!
This posting is provided "AS IS" with no warranties, and confers no rights.
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
SQL Server 2000 (4 servers - 10 databases on each - big
one 25 MB (and couple like that))
DSS Primary used for Dataware.