I have two DB servers (MSQ SQL Server 2008) both are different locations, i need to synconize both databases data synchronization on real time means a bit change at 1st db server it will update at 2nd db server if a bit change at 2nd db server it will update at 1st db server.
Is there any simple and effective way by which i can do this please guide i have no idea about it, i would be very great full if someone send me link with snap shoots.
Which edition of MSSQL are you running?
Web and above should provide Replication service and Load Ballancing services, these services are designed to cluster multiple servers together, even across the internet.
Replication service works best when the 2 machines are in the same domain but does not require this