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 |
|
vijays3
Constraint Violating Yak Guru
354 Posts |
 Posted - 2010-04-12 : 10:10:18
|
| I have some task to accomplish n need your help if you could help me…We have one server that is used for sending alrts like log space, job completion or failure ,backup alerts, server available or unavailable and so on. Our job alerts are completely dependent on this server.if it goes down or become unavailable in this case we can not see the alerts because we don’t have any alternative.So my question is I want to setup the server2 in case of unavailability of the server1 should start sending alerts and all latest database should be on server2 …What could be the solution for this replication or log shipping or any other approach |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
vijays3
Constraint Violating Yak Guru
354 Posts |
Posted - 2010-04-13 : 02:33:02
|
| Thanks for your input on this...We are going to setup the all alerts jobs on SERVER2 as well.By using the log shipping we can get the TLOG of users databases..But How could SERVER2 start sending alerts itself if SERVER1 is down...I read about the clustering it can make it possible on the failure of SERVER1 ,Server2 will start doing the same work as SERVER1 does..But i dont want to use clustering in my case becaz it is expensive..Is there any script which makes it possible.ThanksVIjay SahuDatabase Engineer |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Need to setup stand alone server