<div>
What do you plan on using to move data from your master to your slave system?
</div>


What do you plan on using to move data from your master to your slave system?

<div>
Hi,<br />
<br />
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.<br />
<br />
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.<br />
<br />
Marc
</div>


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

<div>
OK, no problem. &nbsp;<br />
<br />
If I were you, I would setup log shipping. &nbsp;It is a cheap, built in option and you don't have tohave the enterprise version to do it.
</div>


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.

<div>
Hi,<br />
<br />
I will give it a go. Get back to later with the outcome.<br />
<br />
Marc
</div>


Hi,

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

Marc

<div>
sounds good...hope it works out for you. &nbsp;I use it frequently.
</div>


sounds good...hope it works out for you.  I use it frequently.

<div>
Hi chapmandew,<br />
<br />
We have got it all up and running now. Thank you for your help.<br />
<br />
Marc
</div>


Hi chapmandew,

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

Marc

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
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.<br />
<br />
Can anyone assist me?<br />
<br />
Marc
</div>
</div>


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

Disaster Recovery and SQL 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.