Saturday, February 25, 2012

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' ??The main reason I've seen options greyed out is insufficient privleges.|||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!!!!!??|||Have you checked with Veritas? My guess is that Backupexec may have permanently disabled those items.|||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???|||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. (http://www.teratrax.com/articles/msde_vs_sql_server.html)|||Thank you for the link to the article!!!!!!!!!! basically, i need to go back to veritas then.

No comments:

Post a Comment