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
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\
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