Disable "Database Maintenance Plan"

Question

Disable "Database Maintenance Plan"

dig

SSC-Addicted

Points: 435
More actions
September 10, 2003 at 5:46 pm

#81972

I had settled a "Database Maintenance Plan" for a daily backuping while I was building my site through IIS -- but, now, everything is already on the site. Then, I'll not use my "local" databases anymore.
More: now, in "SQL Server Enterprise Manager", the option "Data Maintenance Planner" (under "Tools", when I click the server) is disabled: probably because my DB is already under the Host site.
So, please help me:
- HOW can I DISABLE (or DELETE) the "Data Maintenance Plan" in MY computer?
Thanks since now.
Dalton, Rio de Janeiro
November 25, 2024 at 7:26 am

This was removed by the editor as SPAM
November 25, 2024 at 7:28 am

This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

Don't think you can disable it. If the login used in SQL Server register property doesn't have 'sa' privilege, you wouldn't see the maintenance plan wizard.

dig SSC-Addicted Points: 435 More actions · Answer 2

Allen

The problem seems to be complex, but, that's strange, it is not: it's me who (actually) does everything in my site, and in my SQL db and tables: inclusions, updates, deletions, etc. So: ?

Thanks since now

Dalton

shahriarplus Newbie Points: 7 More actions · Answer 3

Hi Dig ,

You should disable all your MaintenancePlan related jobs in "sql server agent" .

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 4

shahriarplus wrote:

Hi Dig , You should disable all your MaintenancePlan related jobs in "sql server agent" .

Welcome but, if you're going to say something like that, you should explain why and/or cite some proof of your recommendation. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)