Sunday, March 11, 2012

error converting data type int to tiny int

While trying to create a new database maintenance plan in SQL 2000 sp3, I'm
receiving the error "error converting data type int to tiny int". No matter
what I select in the plan, the same error appears. I have a bare bone backup
of 1 database to disk, and receive the error. I've not been able to find
anything, except for a few people having the same sort of problem, who are
running more than 1 instance of sql on their server, as is the case with me.
thank you,
I don't know why the error but if you are simply doing a backup why not
create a scheduled job yourself and forget about the Maintenance plan?
Andrew J. Kelly SQL MVP
"Bill" <Bill@.discussions.microsoft.com> wrote in message
news:2F56B630-C272-4125-A5D0-08ADE9E284A8@.microsoft.com...
> While trying to create a new database maintenance plan in SQL 2000 sp3,
> I'm
> receiving the error "error converting data type int to tiny int". No
> matter
> what I select in the plan, the same error appears. I have a bare bone
> backup
> of 1 database to disk, and receive the error. I've not been able to find
> anything, except for a few people having the same sort of problem, who are
> running more than 1 instance of sql on their server, as is the case with
> me.
> thank you,
>
|||Do you mean use a T-SQL statement under Management, SQL agent, Jobs, or from
Management Backup?
"Andrew J. Kelly" wrote:

> I don't know why the error but if you are simply doing a backup why not
> create a scheduled job yourself and forget about the Maintenance plan?
> --
> Andrew J. Kelly SQL MVP
>
> "Bill" <Bill@.discussions.microsoft.com> wrote in message
> news:2F56B630-C272-4125-A5D0-08ADE9E284A8@.microsoft.com...
>
>
|||Yes under Management, SQL agent, Jobs, you can right click and add a new
job. Then in the Jobstep you place the TSQL BACKUP DATABASE xxx command.
You can set a schedule as you see fit.
Andrew J. Kelly SQL MVP
"Bill" <Bill@.discussions.microsoft.com> wrote in message
news:4F8344E5-0A46-499F-9A2C-6B263EB9F23C@.microsoft.com...[vbcol=seagreen]
> Do you mean use a T-SQL statement under Management, SQL agent, Jobs, or
> from
> Management Backup?
>
> "Andrew J. Kelly" wrote:

No comments:

Post a Comment