SQL 6.5 Error

[genekr]

I'm running SQL 6.5 on a W2K box. While running a SQL Query I get the following error.

[Microsoft][ODBC SQL Server Driver][SQL Server]Can't allocate space for object '-547' in database 'tempdb' because the 'system' segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.

I increased the Tempdb from 400MB to 700MB but still same error. I can't find where to dump the transaction log.

Any help is appreciated.

Gene

 

[mrdenny]

You dump the transaction log via the DUMP LOG command. Check Books OnLine for the syntax.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[genekr]

Thanks, but I'm sorry, I looked at Books Online and couldn't figure out how to do it. Any help?

Thank you.
Gene

 

[mrdenny]

Sorry the command is DUMP TRANSACTION not DUMP LOG.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[genekr]

Thank you. I found it. Does it have to be dumped somewhere (tape,...) or can it just be deleted?

Gene

 

[mrdenny]

I'm not sure if the old 6.5 command supports with truncate_only. My SQL 6.5 BOL doesn't seem to say.

In SQL 7/2000 this would work.

dump transaction Database with truncate_only

You can try that. Otherwise you'll need to dump it to a device.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com