Hello, I hope this is the right place to post the thread, if not please excuse me! 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!