Error While configuring a Backup Job using Maintenance Plan in SQL Server 2005

Hi All,
I am getting an error while trying to schedule a backup job using Maintenance Plan in SQL 2005.
When I try to save it, It keep on saying me "No Description found"
I don'tknow which description it is refering to.
Bcoz, I written some description too on that plan.
saratcmAsked:
Who is Participating?
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Check this Microsoft support:

http://support.microsoft.com/kb/922546
http://sqllearnings.blogspot.com/2009/02/no-description-found-error-when.html

Apply Visio 2003 Service packs to get it fixed..
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Apply SP3 for SQL Server 2005 and try creating it again..
Make sure you are creating Maintenance plan for that instance by logging into the server directly..
0
 
saratcmAuthor Commented:
Yes, I logged into that box, We have SP2 available and I think we have some bugs in version before SP1 and it should be fine with SP2.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Raja Jegan RSQL Server DBA & ArchitectCommented:
And its far more better with SP3..

>> "No Description found"

Check whether you have provided a name for your Schedule.
0
 
saratcmAuthor Commented:
Yes, I provide every thing.
0
 
ProjectChampionCommented:
The error is reffering to a description for the schedule! You can't leave the name and description fields of a schedule blank just fill it with some relevant text and save it.  : )
0
 
saratcmAuthor Commented:
I written all the descripton n every thing,but somehow it is giving me this error. I didn't come across this before.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Any updates on my comments above..
0
 
ProjectChampionCommented:
Please note that when you're creating a Maintenance plan your dealing with at least three object, the plant itself, the underlying job(s) (or steps) and the pertinent schedue(s); each of which, require a separate name and description. My bet is that you've filled in the description field for the paln and/or the underlying job(s) but not the schedule. Happened to me too when I was creating my first maint plan....
0
 
saratcmAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.