SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 MSSQL High Availability Needed..
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

soumyaghoshece
Starting Member

India
3 Posts

Posted - 05/16/2011 :  01:18:07  Show Profile  Reply with Quote
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 Ghosh
Software Engineer
Shriram Insight
Kolkata,India

unspammed

dinakar
Flowing Fount of Yak Knowledge

USA
2507 Posts

Posted - 05/16/2011 :  15:38:29  Show Profile  Visit dinakar's Homepage  Reply with Quote
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/
Go to Top of Page

soumyaghoshece
Starting Member

India
3 Posts

Posted - 05/16/2011 :  23:03:40  Show Profile  Reply with Quote

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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000