Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004

    Exclamation Unanswered: SQL server physical migration

    Hi! I have an SQL server installation with a 6.5GB database online at a particular location. I need to move the Database to another location which is a 1000 Miles away.

    I have an additional physical Server at the other location which I can use to Sync the database from the original location. Can anyone please guide me to the best strategy to sync the database from the original location to the new location with minimum downtime??

    Any help would be greatly appreciated.

    Thanks and Regards

  2. #2
    Join Date
    Apr 2004
    Kansas City, MO
    Are you wanting to continuously sync the database, or just sync it this one time? If it's just a one time deal then backup the database, zip the file, ftp the file, unzip it, and restore it to the other server.
    When life gives you a lemon, fire the DBA.

  3. #3
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Oh yeah, still thinking "one shot" here...

    Be sure to dump the transaction log if you don't really need it, and for a 6.5 Gb file be sure you use WinZip 9.0


Posting Permissions

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