October 6, 2008 at 7:06 am
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
October 6, 2008 at 9:27 am
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.
October 6, 2008 at 9:55 am
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?
October 6, 2008 at 9:59 am
yulichka (10/6/2008)
can't see the location where we moving
:exclamationmark: :exclamationmark:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2008 at 10:10 am
Well that certainly complicates things.
Whats the transaction volume of your app?
Chris.
Chris.
October 6, 2008 at 10:22 am
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
October 6, 2008 at 10:47 am
You can see them via your VPN/own machine but the Source and Destination servers cannot communicate directly, right?
Chris.
October 6, 2008 at 11:55 am
what type of communication
October 6, 2008 at 12:00 pm
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.
October 6, 2008 at 12:22 pm
No problem, I don't have a direct connection
October 6, 2008 at 1:07 pm
Since you can't have any downtime and neither provider can communicate, then I think your options are quite limited.
Could you set up 3 way merge replication between the 2 providers via your machine? I assume you just want to have the 3 in existence until you can cut over to the new server.
If not, you may have to restore a backup to the new server, then manually apply TLogs to the new provider's server until you're ready for cut over. Then cut over. Restore the old database onto the new provider as a new database or read the transaction logs created. (You will be missing some data from the cut over) to figure out what data was added, and then manually re-add it to the new db.
I can't think of any other way with the constraints you've got, unless you can get the two providers to allow you to have your servers to communicate directly, then this is really easy.
Chris.
October 7, 2008 at 8:15 am
Thank you. I was told that we can do a full backup and move it to the new server and when we ready to go life copy the latest transaction logs. The old servers running out of space what should I check in a new server that we wouldn't have the same problems? What configurations needs to be check?
October 7, 2008 at 8:19 am
compress the backup files see if that works
October 7, 2008 at 8:22 am
Thank you, but what should I check on the server side for configuration?
October 7, 2008 at 10:05 am
Before we get the server, can we shrinked it without any time lost,so it would take less time for me to do a full backup?
Viewing 15 posts - 1 through 15 (of 26 total)
You must be logged in to reply to this topic. Login to reply