[Webinar] Streamline your web hosting managementRegister Today

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

SQL Server 2005 data replication

Dear Gurus,
We currently have data on SQL server 2000 in our office server.
We need to replicate data from the SQL server in our office(CA) to the disaster recovery server(TX) at a remote location on a daily basis.

We are looking at a product caled "WanSync" to serve this purpose, but it is expensive.

Is there functionality in SQL Server 2005 that has features for data replication from one server to a remote server? In that case we wont have to buy "WanSync" & can upgrade from SQL Server 2000 to SQL Server 2005.

Please advise.

Thanks
0
vdesai_8
Asked:
vdesai_8
  • 3
  • 2
1 Solution
 
YveauCommented:
How about the replication feature of SQL Server ?
http://msdn2.microsoft.com/en-us/library/ms151198.aspx

Hope this helps ...
0
 
vdesai_8Author Commented:
Thanks Yveau. is it too much work to configure the servers for replication or is it fairly easy? The reason I am asking is that, I am not very proficient with setting up Sql replication hence would have to refer to some books. Do you think setting up replication is pretty straightforward or is it complicated? Are there any good books that explain the process step by step?
0
 
YveauCommented:
It's pretty straightforward. Make sure o think it over good and choose the proper kind of replication for you needs. That will be 80% of the hard work. The rest is just 'a few clicks away' :-)

Here is a good 'manual':
http://msdn2.microsoft.com/en-us/library/ms151866.aspx

Hope this helps ...
0
 
vdesai_8Author Commented:
Thanks for your help.
0
 
YveauCommented:
You're welcom and thanks for the grade !
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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