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-06-05 : 02:50:44
|
| Dear All,we have one production server and continuously getting the data from application.we have replication server with transactional replication for the main database.so, for taking the data, we are using prod server, and for fetching the data, we are using replication server.now what i'm expecting from you is, if something happend to the main server, there is no cluster except backup. what is the best plan for this?and one more thing, if replication server fails, then the application will not fetch the data then what is the plan for this?please give me a good plan for this kind of strategy. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-05 : 03:47:46
|
| Depends how time critical the application is. For the replicated database, if it is essential that you have the data, you could always replicate to a 3rd server and let your application handle the change of server on downtime. As far as your publisher goes, there are many scenarios you could implement, but again they depend on how critical the app is. One of them is log shipping, another would be snapshotting your database on a regular basis, then there is clustering or just having a hot standby.It really does depend on the application and no one answer fits all situations. |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-06-05 : 04:06:02
|
| the application relates to a call centre. so that is very critical. and it is not possible for them to provide another server. these are the constraints. based on these please suggest me.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-05 : 23:29:20
|
| Repoint one of the app to whatever live server, get failed server back asap and resync db. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-06-06 : 00:41:45
|
quote:
Originally posted by rmiao
Repoint one of the app to whatever live server, get failed server back asap and resync db.
what exactly resync means....please provide me a good article....ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-07 : 00:33:52
|
| Resync is sending whatever changes happened on live server to failed server once it comes back, you can use backup/restore or other means. |
|
|
|
|
|
|
|
|
replication failover suggetion help