Error

When attempting to adjust the maitenance plan on one of my SQL Servers I get
the followign error message after adjusting how long logs and reports are
kept.
Microsoft SQL - DMO (ODBC SQLState: 42000)
Error 8114: Error converting data type int to tinyint.
What does all this mean?
Hi George,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you encounter the error message "Error
converting data type int to tinyint" when re-saving the maintenance plan.
If I have misunderstood your concern, please feel free to point it out.
Yes, this is a known issue when you tried to edit an existing maintenance
plan in MSDE and then click on "Apply" button or "OK" button. You may work
around with the method below
1) Add the BackupDirectory registry value for the instance SQL server in
registry, you will be able to re-save and edit the maintenance job without
problem.
For example, (if you have a named instance), put it in
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\<instance name>\MSSQLServer.
The String value is "BackupDirectory" and the data value is "C:\Program
Files\Microsoft SQL Server\MSSQL$nameinstance\BACKUP"
- or -
2) Delete the original existing maint plan and re-create a new one with
your desired changes.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.