The event log on one of the nodes simply states 'Cluster resource 'SQL Server' failed.   The database instance restarted at that time and we have not been able to connect...

Keith,

Yes,  I'm talking about a SQL Agent Alert.   I sure wish the Agent could run independently of the database....kind of like we used to have to do in SQL 6.5...setting...

Perhaps create an alert for Error Number 14265 or 17147 or...or...or and notify one or more of your operators?

Now my problem is how to notify me when the database is...

Just out of curiousity,  what would happen to a backup transaction log if the database was shut down while the job was still running?

1.  Yes, we are running in full recovery mode.

2.  Running some tests,  Log Explorer does track create/drop table commands.

Actually opening up the a backup log file that was created after...

Of course I know this is DDL not DML !