SQL Server Performance

Transfer DB to different server

Discussion in 'Third Party Tools' started by Raulie, Mar 27, 2004.

  1. Raulie New Member

    What is the quickest way to transfer an 80GB database from on server to another?
  2. derrickleggett New Member

    If the database cannot be down, you need to backup, compress, ship, uncompress, and restore.

    There are tools like SQL LiteSpeed that can do this for you transparently. You should check them out if you need to do this a lot. If you are copying the file, look at robocopy. It's fast and free. RAR tends to shrink the backups better than zips.

    Derrick Leggett

  3. satya Moderator

    If you don't want to depend on the third party tools then only way is to use BACKUP/RESTORE methodology by copy the file between the servers.

    If not ensure the second server SQL services are controlled by a domain account that has privileges on first server, so that you can try restoring the database directly on the network.

    DTS can be a partial solution to transfer data but not all the objects in a database.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. Raulie New Member

    Thanks a lot. My consern is performance wise. What would be the fastest way?
  5. satya Moderator

  6. Raulie New Member

    Reading up on SQL Litespeed I have agreed to test it out. For anyone that has used it before can you please give me some pros and cons of the software. Thanks
  7. satya Moderator

    I would transfer this thread to Third Party tools as you lean towards third party tool and will get required references.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  8. bradmcgehee New Member

    I don't know of any negative reasons not to use SQL Litespeed. It works great!

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  9. satya Moderator

    Check the latest version and more features round 64 bit version.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page