SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 02:58 AM
| ||||
| ||||
 SQL Server DB Backup job problem 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! Eddy      |
|
02-29-2008, 02:58 AM
| ||||
| ||||
| Re: SQL Server DB Backup job problem "eddie wang" <eddiekwang@hotmail.com> wrote in message news:879e0e64.0405211209.801c47e@posting.google.co m... > 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? > 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. > Thank you in advance! > Eddy |
Linear Mode
