Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115

    Unanswered: Migration of Sql Server 7

    Hi All,
    Greetings,

    We have
    sql server 7
    Sqlserver ServicePack SP3
    Sort Order = 32
    BuildNumber 7.00.961

    on Windows NT,Now we are planning to upgrade operating system from win NT machine to windows 2000.
    Please let me know what and all precausion do i need to take what and what all backup should be done apart from user database.
    How do i take care of the users,logins,roles, DTS Job and Replication.

    Please help me in this and also any links if u have on this topic

    Waiting for reply
    TIA
    Adil

  2. #2
    Join Date
    May 2004
    Posts
    14

    assuming you will run SQL 7.0

    Will you also be upgrading to SQL 2000 ?

    When I moved to a new machine, we shut down SQL Server on both boxes, copied the database files to the new server and then started SQL Server. Because you are moving master you get all the login id's, etc. Just make sure you are running the same version of SQL server, otherwise it can get complicated.

  3. #3
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115
    yes we are running the same version of SQL server.
    pls suggest how do i go about it.

    Thanks for ur reply

    TIA
    Adil

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •