May 29, 2008 at 6:11 am
Running sql server 2000 sp4 on an 8 year old Server and a shaky SAN.
We have had 3 major outages (corrupted databases) and they are finally biting the bullet and ordering a new Server. The new server will not be in place for about 9 days so until then... limping along with what we have. Is there any way to have SQL Server send an email alert when a specific error occurrs and is logged in the SQL log?
These are the two errors that I want to alert on..
"Error: 823, Severity: 24, State: 2"
or
"I/O error (bad page ID) detected during read at offset"
is this possible?
May 29, 2008 at 7:47 am
You can setup alerts via enterprise manager. On the server, drop down to Management->SQL Server Agent and you'll see alerts. Right-click, select new alert and fill in the blanks (either the severity or error number). On the response tab, setup your email. HTH.
-- You can't be late until you show up.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply