SQL Server DB Backup job problem -- sql server (alternate)

eddiekwang NO[at]SPAM hotmail.com
5/21/2004 1:09:45 PM

Hello,
I am running SQl Server 7.0. I have a database maintenance plan that
runs once a day to perform backups.

It seemed that the database backup files were created successfully.
The problem is that if i go to "SQL Server Agent" --> "Jobs", the
status of the backup job always shows "Executing" (even after 1 day).
I tried "Refresh" and it didn't work. The database log and windows log
also didn't help me to troubleshoot. The database is configured to
email me after the backup. I didn't get any email notification, so I
assume the backup job never completed.

Does anyone have any idea about about the problem might be?

Thank you in advance!

Greg D. Moore (Strider)
5/22/2004 1:28:10 AM

[quoted text, click to view]

Yes, the email hung.

You've got to get sql mail working consistently.

In this case you MIGHT be able to do a xp_stopmail and then kill the backup
process.

After all that, try killing at the OS level mapi32.dll (I think that's the
dll.)

In any case, your backup job probably finished (check to see where it is)
but the email hung.

This is a common problem I've had and it sucks.

[quoted text, click to view]

sql server (alternate) : SQL Server DB Backup job problem