I want my SQL server to be set up like this.
Two separate NT Server onwhose SQL server is installed. Now the clients (on which VB Application is running connected to SQL Server) are making transactions to this server. I want to have a separate server so that if the first server gets down automatically the second server should start running and all the transactions should be switched to the second server. This means that all the transactions should update both the servers. But at a time only one should be running thru client.
Pls suggest something...its very urgetn for me
Two separate NT Server onwhose SQL server is installed. Now the clients (on which VB Application is running connected to SQL Server) are making transactions to this server. I want to have a separate server so that if the first server gets down automatically the second server should start running and all the transactions should be switched to the second server. This means that all the transactions should update both the servers. But at a time only one should be running thru client.
Pls suggest something...its very urgetn for me