|
|
|
SSC-Addicted
 
Group: General Forum Members
Last Login: 2 days ago @ 1:33 PM
Points: 435,
Visits: 602
|
|
| Hello, I need to move through VPN 300GB of data from one server to another. We are moving from one company to another our servers. Is any one have experience doing it? Do you have a plan of migration data. I need to move the data without any time lost and configure the servers. What should I be looking at configuration sql servers? My plan was to move the data and then do a full backup of missed dates, any advise is this correct?Thank you
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, June 26, 2009 11:27 AM
Points: 108,
Visits: 222
|
|
How fast is your connection between sites? Can the sites see each other?
Lets assume it isn't very fast and the two sites cannot see each other at all.
Do you have access to any tools that compress db backups such as Quest's LiteSpeed or SQL Safe?
If I were you, I'd probably do something like obtain one of these tools. (I think Idera may offer a free version but I'm not 100%)
I'd put my database in full recovery mode (if it isn't already there) and setup transaction log backups. (Also if not already there)
I'd take a full backup, (compressed) and restore it over to the new server, then I'd restore transaction logs until the cut over.
This is assuming you can have a few moments of downtime.
If the sites can see each other, and if you can't have ANY downtime, I'd be really tempted to setup merge replication between the sites but they would have to be able to see each other.
Hope that helps.
Chris.
Chris.
|
|
|
|
|
SSC-Addicted
Group: General Forum Members
Last Login: 2 days ago @ 1:33 PM
Points: 435,
Visits: 602
|
|
| Thank you for your information: I have a RadGate and wanted to use that. I can't have anytime down. The location from where we moving server can't see the location where we moving the server. How can I check if it is fast or not?
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, July 01, 2009 1:15 PM
Points: 1,058,
Visits: 3,504
|
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, June 26, 2009 11:27 AM
Points: 108,
Visits: 222
|
|
Well that certainly complicates things.
Whats the transaction volume of your app?
Chris.
Chris.
|
|
|
|
|
SSC-Addicted
Group: General Forum Members
Last Login: 2 days ago @ 1:33 PM
Points: 435,
Visits: 602
|
|
| Sorry,Let me correct myself. I see both locations where the data is coming from and where the data is going.Transaction logs run every 15 minutes. Thank you
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, June 26, 2009 11:27 AM
Points: 108,
Visits: 222
|
|
You can see them via your VPN/own machine but the Source and Destination servers cannot communicate directly, right?
Chris.
|
|
|
|
|
SSC-Addicted
Group: General Forum Members
Last Login: 2 days ago @ 1:33 PM
Points: 435,
Visits: 602
|
|
| what type of communication
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, June 26, 2009 11:27 AM
Points: 108,
Visits: 222
|
|
Any... :)
I'm assuming you can't copy files directly between the servers, that you need to copy them locally first, right?
(Sorry for all the questions, its hard to troubleshoot more complex problems in this way.)
Chris.
Chris.
|
|
|
|
|
SSC-Addicted
Group: General Forum Members
Last Login: 2 days ago @ 1:33 PM
Points: 435,
Visits: 602
|
|
| No problem, I don't have a direct connection
|
|
|
|
