FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

On Fri, 2002-10-25 at 12:23, Frediano Ziglio wrote:
> Il ven, 2002-10-25 alle 17:38, Lowden, James K ha scritto:
> > > From: ZIGLIO Frediano [mailto:Frediano.Ziglio AT vodafoneomnitel.it]
> > > Sent: October 25, 2002 4:16 AM
> > > 
> > > I tried with command
> > > 
> > > 1> dump tran tempdb to 'output.txt'
> > > 
> > > But it reply with strange error...
> > 
> > Frediano, 
> > 
> > I think "dump tran with no_log" is your friend.  That's the old syntax and
> > should still work.  
> > 
> 
> I tried with "dump tran tempdb with no_log" but I got still
> 
> The transaction log in database tempdb is almost full.  Your transaction
> is being suspended until space is made available in the log.

Right - again this means that you have an open transaction that prevents
Sybase from truncating the log. You can check this by doing:

select * from master..syslogshold

Michael
-- 
Michael Peppler / mpeppler AT peppler.org / http://www.mbay.net/~mpeppler
mpeppler AT zetatools.com / ZetaTools, Inc / http://www.zetatools.com
ZetaTools: Call perl functions as Sybase stored procedures!

Attachment: signature.asc
Description: This is a digitally signed message part