Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

Disaster Recovery and SQL 2005

Hi All,

Im setting up a DR server and need to replicate our SQL Database's from the master DC to the DR DC. I have not installed SQL on the DR server yet, just in case I should be setting up different then a standalone version.

Can anyone assist me?

Marc
0
marc_butler
Asked:
marc_butler
  • 5
  • 3
1 Solution
 
chapmandewCommented:
What do you plan on using to move data from your master to your slave system?
0
 
marc_butlerAuthor Commented:
Hi,

To be honest, I was really exspecting you to tell me how to do it. I could use DFS replication or some other form of replication/copy software. But I was kind of exspacting it to be built into SQL some how.

Can I just simply copy the database from one DC to another? I would think it would be harder than that. Microsoft software normally is.

Marc
0
 
chapmandewCommented:
OK, no problem.  

If I were you, I would setup log shipping.  It is a cheap, built in option and you don't have tohave the enterprise version to do it.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
marc_butlerAuthor Commented:
Hi,

I will give it a go. Get back to later with the outcome.

Marc
0
 
chapmandewCommented:
sounds good...hope it works out for you.  I use it frequently.
0
 
marc_butlerAuthor Commented:
Hi chapmandew,

We have got it all up and running now. Thank you for your help.

Marc
0
 
chapmandewCommented:
you're welcome.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now