Database maintenance plan

I use the database maintenance plan to do my backups, I take all the defaults
and this works well for me but one system will not make a backup. Under jobs
all jobs fail but the database maintenance plan history is empty. the plan
name, server name and database name drop down boxes show all but not the
names. I have deleted and remade the jos still not working. What else can I
do.
--
ssovieIf all the scheduled jobs on that server failed, check the account that runs
SQLServerAgent. Maybe the account doesn't have proper rights to the server?
Incorrect password? Did you check Event Viewer? SQL Server Logs?
"SSovie" wrote:
> I use the database maintenance plan to do my backups, I take all the defaults
> and this works well for me but one system will not make a backup. Under jobs
> all jobs fail but the database maintenance plan history is empty. the plan
> name, server name and database name drop down boxes show all but not the
> names. I have deleted and remade the jos still not working. What else can I
> do.
> --
> ssovie|||The localsystem account starts SqlServerAgent, I tried to set ti to the
administrator but it had a logon failure when I tried to start it. I do not
see any errors in the event viewer or Sql logs that have to do with teh
maintenance plan
"Jack" wrote:
> If all the scheduled jobs on that server failed, check the account that runs
> SQLServerAgent. Maybe the account doesn't have proper rights to the server?
> Incorrect password? Did you check Event Viewer? SQL Server Logs?
> "SSovie" wrote:
> > I use the database maintenance plan to do my backups, I take all the defaults
> > and this works well for me but one system will not make a backup. Under jobs
> > all jobs fail but the database maintenance plan history is empty. the plan
> > name, server name and database name drop down boxes show all but not the
> > names. I have deleted and remade the jos still not working. What else can I
> > do.
> > --
> > ssovie|||Interesting... Why is it that you can't start the service using the
administrator account? Check User Right Assignment under Local Security
Settings in Administrative Tools and make sure the admin account can "Log On
As A Service"
"SSovie" wrote:
> The localsystem account starts SqlServerAgent, I tried to set ti to the
> administrator but it had a logon failure when I tried to start it. I do not
> see any errors in the event viewer or Sql logs that have to do with teh
> maintenance plan
> "Jack" wrote:
> > If all the scheduled jobs on that server failed, check the account that runs
> > SQLServerAgent. Maybe the account doesn't have proper rights to the server?
> > Incorrect password? Did you check Event Viewer? SQL Server Logs?
> >
> > "SSovie" wrote:
> >
> > > I use the database maintenance plan to do my backups, I take all the defaults
> > > and this works well for me but one system will not make a backup. Under jobs
> > > all jobs fail but the database maintenance plan history is empty. the plan
> > > name, server name and database name drop down boxes show all but not the
> > > names. I have deleted and remade the jos still not working. What else can I
> > > do.
> > > --
> > > ssovie|||I checked local security settings and found under log on as a service local
policy setting for the administrator was not checked so I checked it. Also
checked Deny logon as a service was empty as was domain security settings. I
still can not start it as administrator.
"SSovie" wrote:
> I use the database maintenance plan to do my backups, I take all the defaults
> and this works well for me but one system will not make a backup. Under jobs
> all jobs fail but the database maintenance plan history is empty. the plan
> name, server name and database name drop down boxes show all but not the
> names. I have deleted and remade the jos still not working. What else can I
> do.
> --
> ssovie