I've recently had an error message thats caused my external application (feeding from SQl server database) to crash. The message read 'General SQL error. The log file for database 'Database-name' is full. Back up the transaction log to the database to free up some log space.'.
This has likely been caused due to the fact that I only had 8MB free on the drive the database was sitting on at the time of the message. Or maybe some other reason ?
Is there a way to get the database to e-mail the user (and developer) of a possible problem like this - i.e. sending a mail when the server only has 'X' MB free left on the drive ?
Thanks in advance.
Steve
This has likely been caused due to the fact that I only had 8MB free on the drive the database was sitting on at the time of the message. Or maybe some other reason ?
Is there a way to get the database to e-mail the user (and developer) of a possible problem like this - i.e. sending a mail when the server only has 'X' MB free left on the drive ?
Thanks in advance.
Steve
