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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-07-21 : 05:50:52
|
| Dear Experts,i've an application, running with the backend sql server 2005.1) i've selected the option in the logshipping configuration"Allow database to assume primary role option". and finished the configurationnow dev005(mydb) is the primary server, and dev007 is the secondary server.now my doubt is if dev005 is crashed, then automatically the application uses the dev007(mydb) server as backend? or we need to manually change the setting in configuration file of the application?will the database mirroring is advantageous than logshipping in this regard?please expaln meArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-07-21 : 05:53:30
|
| moved from yak corral._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-21 : 08:09:34
|
| Always remember Log-shipping and Transactional replication are warm-standby solution and not High availability solution. While Database Mirroring and clustering are HA solution. To answer to question:You have to manually change it to secondary server if your primary server is down using (sp_change_primaryrole-- I guess check Bol)You can use database mirroring with automatic failover,so if your primary server is down ,secondary server will resume primary role and apps as well. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-21 : 22:15:13
|
| >> if dev005 is crashed, then automatically the application uses the dev007(mydb) server as backend? or we need to manually change the setting in configuration file of the application?Yes, you have to repoint app to secondary server manually. |
|
|
|
shafi.spl
Starting Member
10 Posts |
Posted - 2008-07-24 : 06:25:31
|
| log shipping is manual and replication is automatic.so,we have to make secondury server to primary server manually. ok? thank you and bye |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-24 : 09:12:31
|
quote:
Originally posted by shafi.spl
log shipping is manual and replication is automatic.so,we have to make secondury server to primary server manually. ok? thank you and bye
Who said Replication is automatic for failover? |
|
|
|
|
|
|
logshipping clarification