SQL Server Performance Forum – Threads Archive

Backup problems

I am trying to back up all of my databases in 1 database maintenence plan. When I try to do this, I keep getting a "Error 8114: Error converting datatype int to tinyint". And whenever I save the plan, and reopen the plan, it loses the directory that I specified for the backups and returns to the default directory. Anyone have any clue as to what is going on? Thanks for any help. Archer

Have you updated the SQL Server with latest service pack which is 4.

would you check if any process / transaction that runing behind that used to convert the datatype and if it failed ! it could lead to failour. Regards. hsGoswami
[email protected]

I think the question about what service pack you are on is valid in this case. DO NOT upgrade to service pack 4 though without knowing the impact. There are a lot of issues currently being experienced with that SP, which you can research. Just search this forum, and you will find a lot of them. Having said that, you should be on at least SP3a. This is SQL Server 2000, correct? Dineshasanka, you should probably not be recommending people upgrade to SP4. Instead, point them to the service pack web page at Microsoft so they can see the warning, and give them advice to research. It’s just something to think about. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Just out of curiosity, how many databases do you have for this one maintenance plan? Are you trying to do anything else besides the backups? The maximum capacity of a tinyint is 255. However, there aren’t any table columns used by a maintenance plan, using tinyint, that would exceed this capacity normally. MeanOldDBA [email protected] When life gives you a lemon, fire the DBA.

<blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by derrickleggett Dineshasanka, you should probably not be recommending people upgrade to SP4. Instead, point them to the service pack web page at Microsoft so they can see the warning, and give them advice to research. It’s just something to think about. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] <hr height="1" noshade id="quote"></blockquote id="quote"> I have heard that sp4 is giving problems only if you have enabled the AWE. and also for this similar kind of a problem some body has suggested to upggrade to sp3 and it seems that it is working

Actually, they have a hotfix for the AWE issue now on SP4; however, they are also having issues with queries running significantly slower on SP4. I believe that particular issue is still unresolved. I need to jump back on the boards and make sure my information is still current. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

thankx for the information
I didn’t know that there are porblems with performance in sp4

]]>