General discussion

Locked

Upgrading SQL Server 7.0 to SQL Server 2

By ebartholom ·
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?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Upgrading SQL Server 7.0 to SQL Server 2

by Davis, Gary In reply to Upgrading SQL Server 7.0 ...

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.

Collapse -

Upgrading SQL Server 7.0 to SQL Server 2

by ebartholom In reply to Upgrading SQL Server 7.0 ...

Poster rated this answer

Collapse -

Upgrading SQL Server 7.0 to SQL Server 2

by ebartholom In reply to Upgrading SQL Server 7.0 ...

This question was closed by the author

Back to Networks Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums