May 5, 2004 at 9:46 am
We are surrently running SQL Server 7.0 SP4 on an NT 4.0 SP6 machine. We plan to upgrade to a new server box with Windows Advanced Server and to install SQL Server 2000 on the new machine; the old server will go away. What, in a simple outline, would be the most effective manner to keep the existing databases intact ( logins, jobs, etc ) and bring them into SQL Server 2000.
May 5, 2004 at 12:46 pm
The most effective method we found was based on the database size. For smaller databases we did a detach, copy files to new server, and attach. For larger databases (>5GB or so) we did a remote dump and restore. You'll also have to copy any logins and passwords. You'll also need run an sp_updatestats on the database after you move it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply