Post reply

Upgrade Process

  • May 5, 2004 at 9:46 am

    #82755

    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

    #505355

    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