SQL Server Replication Scenario
Sunday July 13, 2008
In a recent forum posting, RAS wrote:
We connected two SQL Server Standard Edition servers using replication. Let me call the first one as the Main Server and the other one Client Server. In the Main Server the database was created and assigned as the Publisher and the Client Server was assigned as the Subscriber.
From a third computer, I can access the database available in the Main Server through ODBC with my application software. The data is getting replicated to the Client Server. Similarly, I can access the database available in the Client Server through ODBC with my application software. The data is getting replicated to the Main Server.
The problem is when the application software is connected to Client Server (using ODBC with the Client Server name) and if the Main Server is switched off, it works until we are in the application software and once we exit out of the application and restart the application it says [Microsoft][ODBC SQL Server Driver] Timeout Expired. The requirement here is even if any one of the servers fails the other server has to take over.
Can you help RAS? Interested in discussing this problem? Visit our forum today!
We connected two SQL Server Standard Edition servers using replication. Let me call the first one as the Main Server and the other one Client Server. In the Main Server the database was created and assigned as the Publisher and the Client Server was assigned as the Subscriber.
From a third computer, I can access the database available in the Main Server through ODBC with my application software. The data is getting replicated to the Client Server. Similarly, I can access the database available in the Client Server through ODBC with my application software. The data is getting replicated to the Main Server.
The problem is when the application software is connected to Client Server (using ODBC with the Client Server name) and if the Main Server is switched off, it works until we are in the application software and once we exit out of the application and restart the application it says [Microsoft][ODBC SQL Server Driver] Timeout Expired. The requirement here is even if any one of the servers fails the other server has to take over.
Can you help RAS? Interested in discussing this problem? Visit our forum today!
Comments
No comments yet. Leave a Comment