Error #1105

[GSMike]

Hello,
I am getting the following error message when I try to run a command from MS Access using a SQL Server linked table.

ODBC-call failed.
[Microsoft][ODBC SQL Server Driver][SQL Server] can't allocate space for object 'Syslogs' in database 'mydb'  because the 'logsegment' 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. (#1105)

I know that sounds like a pretty explicit and instructional error message, but I'm new to SQL Server, and I can't find the transaction log to dump it. I am using SQL Server 6.5.

I already tried going into Enterprise Manager and right-clicking on the appropriate database device, and then changing the size from 1G to 1.25G. This doesn't seem to have any effect.

Any help you can provide is very much appreciated.

Thanks!! Mike K

 

[Andel]

Try this.

DUMP TRAN mydb WITH NO_LOG

Andel
andel@barroga.net

http://andyb.8m.com

 

[GSMike]

Andel,
That worked!!!
Thank you!!
Mike K

 

[GSMike]

Andel,
Would it be too much trouble if I asked you also how to shrink the database?
In the process of trying to make more room for the transaction log, I increased the size of the database by .5G, and would like to roll that back to clear server space.
Thanks again.
Mike K