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 |
|
sql_er
Constraint Violating Yak Guru
267 Posts |
 Posted - 2007-07-26 : 18:29:47
|
| Guys,We have active/passive cluster set up. There are 2 machines in a cluster. If machine 1 fails, machine 2 takes over, with no fail back.We had an issue recently - there was a failover, but we never knew about it since SQL Server was working with no problem, until some point in time. This point in time occurred when we began to run out of disk space on a disk to where we back up db and transaction log. Apparently we did not compress the drive on the 'to fail over to' machine.Can anyone share, from their experience, how one can identify and alert if a failover occurs?Thanks a lot |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-26 : 18:37:03
|
| You can't compress drives where SQL Server is anyway. You'd get an error during installation if the drive had that option turned on.We use MS MOM along with custom utilities to identify issues in production.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-26 : 23:12:08
|
| You can set job to send out alert and let it run every time sql agent starts. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2007-07-27 : 10:07:44
|
| Tara, our backups sit on drives separate from database files. As such, they can be compressed.Rmiao, the question is: What would be the contents of that job?Eyechart, I am looking at the link provided.Thanks a lot everyone! |
|
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2007-07-27 : 10:10:30
|
| Rmiao, I think I got your point now ... thanks! |
|
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2007-07-31 : 12:49:04
|
| Would anyone know whether SNMP trap would be generated when a failover occurs?Thank you! |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-07-31 : 12:59:55
|
quote:
Originally posted by sql_er
Would anyone know whether SNMP trap would be generated when a failover occurs?
not unless you are using additional 3rd party software - such as HP insight management agents (if you use HP hardware).EDIT:This article discusses how to take events from the system/application event logs and send them as snmp traps. Looks like a bit of work though so YMMV.http://www.ehsco.com/reading/20050715.html-ec |
|
|
|
|
|
|
|
|
Alert on Failover