Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
soumyaghoshece
Starting Member
3 Posts |
 Posted - 2011-05-16 : 01:18:07
|
| 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.Soumya GhoshSoftware EngineerShriram InsightKolkata,Indiaunspammed |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2011-05-16 : 15:38:29
|
| 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...Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
soumyaghoshece
Starting Member
3 Posts |
Posted - 2011-05-16 : 23:03:40
|
| 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..