SQL Server DB Backup job problem

**Greg D. Moore \(Strider\)** · Jul 20 '05, 03:47 AM

Re: SQL Server DB Backup job problem

"eddie wang" <eddiekwang@hot mail.com> wrote in message
news:879e0e64.0 405211209.801c4 7e@posting.goog le.com...[color=blue]
> 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?
>[/color]

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.

[color=blue]
> Thank you in advance!
> Eddy[/color]

SQL Server DB Backup job problem

SQL Server DB Backup job problem

Comment