BizTalk Server - Backup Biztalk Job is failing

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server > December 2004 > Backup Biztalk Job is failing





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Backup Biztalk Job is failing
Jayt

2004-10-29, 5:49 pm

Hello I am trying figure out how to get the backup Biztalk job work. Any help
would be greatly appreciated.

I ran the installed sql agent job - Backup Biztalk Server. It gave the
following error. How do i get the backup job work.

Warning: The table '#catalogs' has been created but its maximum row size
(8281) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE
of a row in this table will fail if the resulting row length exceeds 8060
bytes. [SQLSTATE 01000] (Message 1708) Invalid object name
'adm_OtherBackupDatabases'. [SQLSTATE 42S02] (Error 208) Warning: The table
'#catalogs' has been created but its maximum row size (8281) exceeds the
maximum number of bytes per row (8060). INSERT or UPDATE of a row in this
table will fail if the resulting row length exceeds 8060 bytes. [SQLSTATE
01000] (Error 1708). The step failed.

--
Jay
Bill Ticehurst [MSFT]

2004-12-01, 8:46 pm

Hi Jay,

Have you seen the KB article at
http://support.microsoft.com/defaul...KB;EN-US;839626 ? This
sounds like it could be your problems.

Regards,

- Bill Ticehurst [MSFT]

This posting is provided "AS IS" with no warranties, and confers no rights

"Jayt" <Jayt@discussions.microsoft.com> wrote in message
news:D4E10E3A-29BA-458E-AC72-44EB5FD43E6E@microsoft.com...
> Hello I am trying figure out how to get the backup Biztalk job work. Any
> help
> would be greatly appreciated.
>
> I ran the installed sql agent job - Backup Biztalk Server. It gave the
> following error. How do i get the backup job work.
>
> Warning: The table '#catalogs' has been created but its maximum row size
> (8281) exceeds the maximum number of bytes per row (8060). INSERT or
> UPDATE
> of a row in this table will fail if the resulting row length exceeds 8060
> bytes. [SQLSTATE 01000] (Message 1708) Invalid object name
> 'adm_OtherBackupDatabases'. [SQLSTATE 42S02] (Error 208) Warning: The
> table
> '#catalogs' has been created but its maximum row size (8281) exceeds the
> maximum number of bytes per row (8060). INSERT or UPDATE of a row in this
> table will fail if the resulting row length exceeds 8060 bytes. [SQLSTATE
> 01000] (Error 1708). The step failed.
>
> --
> Jay



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com