Backup schedule settings won't save

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sarah_Lund - 02 Jul 2008 14:51 GMT

I have a maintenance plan set up and the optimization and indexing schedules
are ok. The problem is the schedule for the backup does not save. When I am
in the Complete Backup tab to schedule the backup, the dropdown list to
remove files older than time increment (days, weeks...) is empty. On this
server we are running SQL Server Enterprise Edition 8.00.2039 (SP4). This
looks like a bug but I've never run into this except on this server and I
haven't found anyone mention the problem.

Any ideas?
Sarah

Reply to this Message

John Bell - 03 Jul 2008 09:19 GMT

On 2 Jul, 14:51, Sarah_Lund <SarahL...@discussions.microsoft.com>
wrote:

> I have a maintenance plan set up and the optimization and indexing schedules
> are ok. The problem is the schedule for the backup does not save. When I am
[quoted text clipped - 6 lines]
> Any ideas?
> Sarah

Hi Sarah

Are you creating the MP on the server or remotely? Does this occur
when you create the maintenance plan or modify it (or both!).
Do you use the default backup directory or a different one?

If you are using AWE then you should apply one of the post SP4
hotfixes as there was a problem, so you may want to try after that!

John

Reply to this Message

Sarah_Lund - 03 Jul 2008 21:02 GMT

I did more investigation and found someone had uninstalled SQLSERVERAGENT.
The service wasn't even listed in the services.

Thanks for your response.
Sarah

Reply to this Message