Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2004
    Posts
    99

    Unanswered: Maintenance plans

    We have Veritas' Backupexec running in our Enterprise and the Veritas Install actually installs MS SQL Server MSDN on each Server in the Enterprise.

    It looks like it also sets up a default Maintenance plan within each of the MSDN Instances.

    I guess my question is.. Can I manage the Maintenance Plans on these MSDN Instances via the SQL Server EM GUI from my desktop?? Seems like when I look at the Maintenance plans alot of the options are greyed out or not available. What I am trying to do is modify one of the maintenance plans to have the backups deleted after one week (One of the Instances has been running a complete backup on the Backupexec Databases for a year and there are a years worth of backups on the Server) but the option to "remove files older than" is 'greyed out' ??????

  2. #2
    Join Date
    Dec 2004
    Location
    CA, USA
    Posts
    63
    The main reason I've seen options greyed out is insufficient privleges.

  3. #3
    Join Date
    Mar 2004
    Posts
    99
    I logged into my local MSDN Instance as 'sa' and created a new maintenance plan via EM on my desktop.

    I can create the plan, but the options to "remove files older than" is still missing. This is so puzzling!!!!!????

  4. #4
    Join Date
    Dec 2004
    Location
    CA, USA
    Posts
    63
    Have you checked with Veritas? My guess is that Backupexec may have permanently disabled those items.

  5. #5
    Join Date
    Mar 2004
    Posts
    99
    I thought Veritas might be the culprit also, So I installed MSDE locally on my machine and I get the same results. In a new maintenance plan, on the 'specify backup disk directory' screen, I put a check in the 'remove files older than' box and the dropdrop that should read 'hours, days, weeks, months' is blank and willl not populate. Is this something that is particular to MSDE?????????

  6. #6
    Join Date
    Jan 2005
    Location
    TempDb
    Posts
    228
    There's a reason it is called MSDE and not MS SQL Server 2000. MSDE is intended for disconnected applications and/or development. It is not intended as a way to avoid paying for what you need.

    You need to read up on limitations in MSDE. Here's one article that may be interpreted as a keen marketing ploy.
    I love deadlines. I like the whooshing sound they make as they fly by. Douglas Adams

  7. #7
    Join Date
    Mar 2004
    Posts
    99
    Thank you for the link to the article!!!!!!!!!! basically, i need to go back to veritas then.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •