SQLMAINT - no message error

[Phillip Sabotin]

I have a situation where I am running sqlmaint on 10 - 12 databases on
the same server. All of them run successfully; However, one returns a
failure because of no message. MSDB is not full. There is no messages
in the errorlog. And the actual SQLMAINT executed just fine.

Any Clues?

Sometimes MS SQL is very frustrating!!!!!!!

[Frank Garcia (DBA)]

What is the size of the .rpt file ?

On 2/24/99 8:48:19 AM, Phillip Sabotin wrote:
> I have a situation where I am running sqlmaint on 10 - 12 databases on
the
> same server. All of them run successfully; However, one returns a
failure
> because of no message. MSDB is not full. There is no messages
in the
> errorlog. And the actual SQLMAINT executed just fine.

Any
> Clues?

Sometimes MS SQL is very frustrating!!!!!!!

[Phillip Sabotin]

3KB.....
There is some that are 2kb, one that is 4kb and a couple that are 3kb.

On 2/24/99 12:11:05 PM, Frank Garcia (DBA) wrote:
> What is the size of the .rpt file ?

On 2/24/99 8:48:19 AM, Phillip
> Sabotin wrote:
> I have a situation where I am running sqlmaint on 10 -
> 12 databases on
the
> same server. All of them run successfully;
> However, one returns a
failure
> because of no message. MSDB is not
> full. There is no messages
in the
> errorlog. And the actual SQLMAINT
> executed just fine.

Any
> Clues?

Sometimes MS SQL is very
> frustrating!!!!!!!

[Phillip Sabotin]

Sorry.....That's what explorer said. The actual is 2197.

On 2/24/99 1:29:57 PM, Phillip Sabotin wrote:
> 3KB.....
There is some that are 2kb, one that is 4kb and a couple that are
> 3kb.

On 2/24/99 12:11:05 PM, Frank Garcia (DBA) wrote:
> What is the
> size of the .rpt file ?

On 2/24/99 8:48:19 AM, Phillip
> Sabotin
> wrote:
> I have a situation where I am running sqlmaint on 10 -
> 12
> databases on
the
> same server. All of them run successfully;
>
> However, one returns a
failure
> because of no message. MSDB is not
>
> full. There is no messages
in the
> errorlog. And the actual SQLMAINT
>
> executed just fine.

Any
> Clues?

Sometimes MS SQL is very
>
> frustrating!!!!!!!

[Phillip Sabotin]

I have found the answer. Basically there is a problem with the length of STDIO and STDERR.
The fix is in service pack 5a. The work arround is to change something in your sqlmaint
to make the output larger or smaller by two bytes. I found this on MS TECHNET Q171323.


------------
Phillip Sabotin at 2/24/99 8:48:19 AM

I have a situation where I am running sqlmaint on 10 - 12 databases on
the same server. All of them run successfully; However, one returns a
failure because of no message. MSDB is not full. There is no messages
in the errorlog. And the actual SQLMAINT executed just fine.

Any Clues?

Sometimes MS SQL is very frustrating!!!!!!!