msdb database problem with MS SQL Server 6.5

[John Mullan]

Hi
I have a problem creating a backup in SQL Server 6.5. Although, the
backup produced does restore ok, I want to stop this error message
appearing everytime I make a backup. The error message is:

"
[SQL Server ]Can't allocate space for object 'sysbackupdetai l' in
database 'msdb' because the 'default' segment is full. If you ran out
of space in Syslogs, dump the transaction log. Otherwise, use ALTER
DATABASE or sp_extendsegmen t to increase the size of the segment.
"

this articles appears to describe the problem and the solution:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;152354

It recommends creating a stored procedure to delete old entries. The
stored procedure cannot be created due tro a memory problem. What I
was wondering, although the article doesn't mention it, can a new
device be created and added to the msdb database. This should fix the
problem or is there problems doing this ?

Thanks in advance

[Simon Hayes]

Re: msdb database problem with MS SQL Server 6.5


"John Mullan" <smurf010@hotma il.com> wrote in message
news:92554ef7.0 402040935.6fce7 9f1@posting.goo gle.com...[color=blue]
> Hi
> I have a problem creating a backup in SQL Server 6.5. Although, the
> backup produced does restore ok, I want to stop this error message
> appearing everytime I make a backup. The error message is:
>
> "
> [SQL Server ]Can't allocate space for object 'sysbackupdetai l' in
> database 'msdb' because the 'default' segment is full. If you ran out
> of space in Syslogs, dump the transaction log. Otherwise, use ALTER
> DATABASE or sp_extendsegmen t to increase the size of the segment.
> "
>
> this articles appears to describe the problem and the solution:
>
> http://support.microsoft.com/default...b;EN-US;152354
>
> It recommends creating a stored procedure to delete old entries. The
> stored procedure cannot be created due tro a memory problem. What I
> was wondering, although the article doesn't mention it, can a new
> device be created and added to the msdb database. This should fix the
> problem or is there problems doing this ?
>
> Thanks in advance[/color]

I think (from memory) SQL6.5 already has a system stored procedure to clean
up the history for you - look for one called sp_purgehistory or something
similar, and check what the code does. Otherwise, extending the device
should work.

Simon