September 25, 2008 at 9:02 am
Hello, I need an advice please, My company have servers in other city that other company supports them. Now we want other company to do it, but I need to get a copy of our servers without loosing anytime or at least a little time to lose it and move it to my city location. What should I do? I thought I should do a backup, but how? Thank you
September 25, 2008 at 9:53 am
When you say 'copy of your server' do you mean just the copy of the DBs or the entire backup of the server including the OS portion and all....
September 25, 2008 at 10:24 am
I need to copy everything from the servers. We are moving it to another place.
September 25, 2008 at 11:07 am
It's not a simple process and you will have downtime.
Backup / restore will move the databases, and you can stage this to minimize time. Do a full backup, move that, restore it.
Do a differential backup, move that , restore it.
Do log backups, etc.
Once you have that process smooth, you can continue to make log backups and move them, minimizing the time between backups until you are ready to cut them over.
Everything else on the server level needs to be scripted out and moved. Jobs, packages, logins (use sp_help_revlogin), and more.
This isn't that hard, but it's got a lot of work and it's not simple if you've never done it. You should engage a consultant in your area to help you.
September 25, 2008 at 11:46 am
Thank you for advise, but could you be more specific of the steps:
1. full backup, move that, restore it.
2.Do a differential backup, move that , restore it.
3.Do log backups
and what's next? when I do Transaction log backups, put them like run every 30 min?Thank you
September 25, 2008 at 12:34 pm
Yulichka -
you can approach this as a piecemeal task, focusing on the easy parts to capture - creating backup files, moving backup files, restoring them on other servers - or you can look at the whole picture, define your overall strategy, and THEN divide and conquer into manageable tasks.
What are your available tools for content transfer? Do you have a VPN to provide a protected pipeline for moving data? Must you use FTP? Is there a WAN type connectivity that allows you to define 'shares' which permit the use of xcopy? So many questions, so little time.
1. Will you be able to 'exactly' replicate the servers in other cities in the location you will use? If not, how close can you get - talking hardware here, down to the BIOS version.
2. Will you have 'fast' transfer capabilities or 'slow' capabilities? What defines fast? Fast enough that SQL Server will not discover time outs and suffer latency problems.
3. In the time that it would take you to properly describe your situation for us to 'give' you the answers, you can search here and other sites to find already written articles that will guide you. When you find the articles you like and feel you mostly understand, we'll be happy to answer your questions about the details that are confusing - narrowly focused questions require much less time to answer.
4. We ARE rooting for you to get this right, hopefully the first time. SQL Server has lots of tools and choices to enable you to make good decisions, but you do have to choose - there's no 'one way' to do it.
October 3, 2008 at 1:40 pm
I will have VPN to do the work. I have 300 GB of data. Thank you Please help me as much as you can
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply