Transfering SQL files from location to colo

25 pts.
Tags:
SQL Database
What is the fastest way to get the SQL database files transfered over? i.e. zip the files

Answer Wiki

Thanks. We'll let you know when a new response is added.

Zip up the files and copy them over the network. If the network is really slow, and/or the database is very large burn the files to a DVD and mail the DVD to the other location.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Phatboy812
    Thanks for the suggestion. I wish we could burn them to a DVD and mail it to ourselves. But we have on one in Denver to do this for our company and the people we bought the databasecompany from is not helping all that much. We have tried PKzip and it is going to take over 8 hours to transfer the database. Which means that that database will not be useable during the transfer. This the other problem we run into is that we have to have that database back up and running before the time of opening the store at 7:00am. And we close at 11:00p.m. which does not give us the time to do the transfer and unzip the files and get the database up and running before the store is open. Has anyone used Rocketstream? If they have please let me know what they think of it.Thanks for any and all imput. All of it is appreciated.
    25 pointsBadges:
    report
  • Twlp123
    I think your situation calls for a WAN based system over the internet. You cannot rely on data transfer overland as you will loose youir data while in transit one day. I presume that you have the same system setup at your end?, and that you only want the updated data to be transfered. If this is the case, why not try to do a SQL replication over the internet. This will ensure that only data will be transfered and not all the other sql files. just a thought
    165 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following