May 14, 2003 at 11:36 am
Hi Guys,
I have a DB Maint plan that backs up SQL db's and emails me the report. This worked flawlessly for months. 2 days ago it stopped backing up and emailing. Absolutely nothing is happening. The only this i have noticed is that in the schedule, in the 'Duration' frame the end date was set to 2 days ago but the radio button for 'No End Date' is selected so surely this shouldnt have mattered? I changed the end date just in case but the backups haven't started up again. Any suggestions?
May 14, 2003 at 1:13 pm
Sometimes the process hangs up. Look in task manager, see if you have sqlmaint running. If so (and no other plans running) kill it. Then try the job again.
Andy
May 15, 2003 at 5:51 am
There's no sqlmaint running in task manager. Ive created new maintenance plans to replace the old ones and they appear to work under the test conditions. I wont know for sure until tomorrow though. Fingers crossed!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply