Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002

    Unanswered: movig data between server

    We have a situation where we have to transfer all tables from MS SQL database to another nightly. But we want to keep
    the logins as it is for each server/database. The database is a bout 60 GB. What is the fastest and the most efficient way
    to accompolish this task. We plan to recreate the indexes nightly as well.

  2. #2
    Join Date
    Jun 2004
    Long Island
    You can truncate, bcp out/in (if only data)


    or you can backup/load, but just drop the users then add your desired users after the db is loaded. You can "ALTER index all rebuild" to rebuild the idxs.

Posting Permissions

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