Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    3

    Unanswered: Migration SQLSERVER DB from one server to another Server

    Hello,
    How to migrate SQLSERVER DB from one server to another Server?
    We are planning from Compaq server to Dell and vice versa?
    Thx.
    -Seena

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Backup all databases from one server and restore on the other.
    I think BOL has info on how to do this for system databases - if not just do a search.

    Also look at detach/attach.

    Worth reading up about system databases first.

  3. #3
    Join Date
    Oct 2002
    Posts
    7

    Talking Re: Migration SQLSERVER DB from one server to another Server

    Hello,
    It is the same as the other member of dBforums explained to you. It is so simple, you need only to backup the database. If you are using MS SQL Server 2000, you'll have to choose the database:
    - right click
    - all tasks
    - backup database
    - choose the device to which you want to copy (tape/disk)

    Then on the other PC, create these databases manually and:
    -choose the newly created DB
    -right click
    -all tasks
    -restore database
    -choose the source

    Otherwise, you can use the DTS service which is available in SQL Server 2000.

    it is so simple to use.

    Take cares & good luck!

    Alzebdeh
    Originally posted by sqlserverdb
    Hello,
    How to migrate SQLSERVER DB from one server to another Server?
    We are planning from Compaq server to Dell and vice versa?
    Thx.
    -Seena

  4. #4
    Radzi Guest

    Re: Migration SQLSERVER DB from one server to another Server

    The easiest, if you have both computer on-line, is to Detach the databases
    and copy the MDF and LDF files into the new server, then attach those files
    into new SQl.


    "Alzebdeh" wrote in message
    news:2441325.1043640789@dbforums.com...
      > Hello,
      > It is the same as the other member of dBforums explained to you. It is
      > so simple, you need only to backup the database. If you are using MS SQL
      > Server 2000, you'll have to choose the database:
      > - right click
      > - all tasks
      > - backup database
      > - choose the device to which you want to copy (tape/disk)
      > Then on the other PC, create these databases manually and:
      > -choose the newly created DB
      > -right click
      > -all tasks
      > -restore database
      > -choose the source
      > Otherwise, you can use the DTS service which is available in SQL
      > Server 2000.
      > it is so simple to use.
      > Take cares & good luck!
      > Alzebdeh
      > Originally posted by sqlserverdb
         > > Hello,
         > > How to migrate SQLSERVER DB from one server to another Server?
         > > We are planning from Compaq server to Dell and vice versa?
         > > Thx.
      > -Seena
      > --
      > Posted via http://dbforums.com

Posting Permissions

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