Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    12

    Unanswered: Copy SQL Server Database to another Server

    I have developed a SQL Server 2000 Database on my development system. I need to copy the Database to my client's Server. Unfortunately they are not linked.

    What is the best way to copy the Database? Can I detach it on my Server, make a copy of the file. Copy the file to my Client's Server, and then Attach it?

    OR IS THERE A BETTER WAY?

    Thanks in advance for your help
    JayD
    Boulder, CO, USA

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Detach, copy, reattach is probably the fastest way to copy a database to another box, although there are plenty of other choices. Using BACKUP / RESTORE is probably the safest, and it doesn't take much longer than detach/copy/reattach does.

    -PatP

  3. #3
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    the best way (In My Opinion)
    is to perform a transfer database task in dts
    it copies everything without having to require a detach then copy then attach.
    backing up and restoring is comprehensive but takes a while to perform
    and the objects are in whatever state they were in when you backed em up

    transfering the db is fast and you get brand new objects so for example indexes are created new so they are not fragged..

    [Books Online] DTS tasks, transferring database objects

Posting Permissions

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