Networks

Ask something
Discussion Locked

Upgrading SQL Server 7.0 to SQL Server 2

0 helpful
3 replies

by ebartholom

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We currently have a MS SQL Server 7.0 installation running on NT that needs to be upgraded to Windows 2000 and SQL Server 2000.

We currently only have the one SQL Server, but other file servers running NT are available.

What is the best practice for backing up the existing 7.0 databases, installing SQL Server 2000 and then restoring the databases on the SQL Server/Windows 2000 box?

3 replies

by davis, gary

You can either copy the databases off the SQL7 box and then install SQL2000 and then just copy the databases back. or you can just do an upgrade from SQL7 and it will upgrade the databases for you. I would still make backups of the databases in case.

This discussion is closed to new replies.