I deleted a maintenance plan and after I created a new one and ran that I encountered the above error. So what should I do and what is a proper way to delete maintenance plan? I deleted that by rightclick on that plane and then delete.

asked 05 Apr, 03:43

hg1735's gravatar image

hg1735
5511
accept rate: 0%


This is an internal database error as described here:

An internal database error occurred. If it can be reproduced, it should be reported to SAP. You may be able to work around this problem by modifying the associated query statement.

permanent link

answered 05 Apr, 10:46

Breck%20Carter's gravatar image

Breck Carter
30.1k490672977
accept rate: 20%

2

IMO you should learn how to understand and build your own backup and validation procedures using the proven utilities dbbackup.exe, dbvalid.exe, dbisql.com and so on rather than relying on the mysterious (and apparently unproven) SQL Central wizards.

This blog post might help with the first step (understand).

(05 Apr, 10:56) Breck Carter
Replies hidden
1

Well, I would add: Have a look at the events that are created by the maintenance plan UI, and use those as a starting point for your own backup, validation and restore plans.

(05 Apr, 11:01) Volker Barth

Okay I'll do that Thanks for your help.

(05 Apr, 14:19) hg1735
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×9
×6

question asked: 05 Apr, 03:43

question was seen: 116 times

last updated: 05 Apr, 14:19