In our current business scenio, all clients are hitting one SQL Server that is the main DB Server and some important tables are replicated as Transactional Replication but if the main database will be down we have no option to continue our business as soon as possible. Can we retrieve the data to another database from the replicated database?It will be helpful for a time. We are not interested in Database Mirroring and Clustering due to the licensing perposes.So if we retrive data to a DUMMY Main Database synchonously from a replicated database it will be helpful or if any other solution for this.Please guide me.
if your primary SQL Server goes down, your replicated server should still be up and available for use. You need to repoint your application server to the replication server and now it might double up as your primary database as well as the other role its already playing. If you are trying to setup something thats automatic look into database mirroring. You dont pay for the secondary server since its in passive mode.. Licensing is a complex area so dont quote me on that.. but typically in mirroring you only pay for one server...
But it is difficult to point,it is hard coded in the front end part so if we point the application to the replication, clients are not able to login through front end.And also the replicated database name and main database name is diffrent.
MSSQL High Availability Needed..
Posted - 05/16/2011 : 01:18:07
