MSSQL Synchronisation -question

[goliveuk]

Hello, I would like to ask how to synchronise 2 MSSQL databases on separate servers, so that when you change something in #1, the changes take place in #2 as well. MSSQL #1 is linked to a website, however MSSQL #2 will be on a separate server and it will not be accessible via the website. What needs to be done in this case?

Hope I managed to explain what I mean. If you need any clarification do let me know!
Thanks very much!

 

[Jameschillman]

What version of SQL are you trying to do this on?

 

[vmhosts]

could be worth a read http://msdn.microsoft.com/en-us/library/ms152531

I havent setup SQL replication before but I do know SQL database mirroring isnt the holy grail of high availability and it does have some limitations that you must be aware of - if you plan to use the mirror copy for failover

 

[kitsupport]

Hi

MS SQL has had 'mirroring' built in since the 2005 version, and it is relatively simple to setup (for someone with a bit of SQL knowledge). Plus it can be configured for automatic failover aswell.

I think it is definitely worth a look, I have managed to successfully do it a couple of times.

PM me if you have any questions.

Dave