Google

Sunday, February 24, 2008

Error 8114: Error converting data type int to tinyint.

You face problem with Microsoft SQL-DMO(ODBC SQLState:42000) with error message "Error 8114: Error converting data type int to tinyint."

Problem
The problem happen when you try to edit maintenance plan

Workaround
1. Add BackupDirectory registry value for the instance SQL Server
Example:
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\\MSSQLServer

2. The string value is "BackupDirectory" and the data value is"C:\Program Files\Microsoft SQL Server\MSSQL$nameinstance\BACKUP"

3. Other way is to delete existing plan

0 Comments:

Post a Comment

<< Home