May 24, 2002 at 2:28 pm
On a Win2000 server, I created a maintenance plan on an SQLServer 7.0 to backup a database but it won't run at all.
Any idea of what the problem is?
May 24, 2002 at 6:08 pm
What error did it report? Look at the maint plan history, not the job history.
Andy
May 26, 2002 at 2:14 am
There was nothing logged in maintenance history and I didn't see any error reported. Where can I look for errors?
May 26, 2002 at 5:54 am
Do you have logging enabled for the plan? Its on the last tab. Also have it write the text report to a file. If you run the job manually what happens?
Andy
May 26, 2002 at 6:16 pm
This is a silly question, but one that needs to be asked. Is SQLServerAgent running?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
May 29, 2002 at 1:56 pm
You are right! It was SQL Server agent not running.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply