Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How to truncate the log with data and log on the same segment

2 posts in Backup and Recovery Last posting was on 2001-03-09 10:04:38.0Z
Oliver Lorenz Posted on 2001-03-09 08:30:04.0Z
From: "Oliver Lorenz" <o-lorenz@wellcom.de>
Subject: How to truncate the log with data and log on the same segment
Date: Fri, 9 Mar 2001 09:30:04 +0100
Lines: 18
X-Newsreader: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
Message-ID: <tiGP#VHqAHA.258@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
NNTP-Posting-Host: 212.52.226.22.nci.de 212.52.226.22
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:434
Article PK: 1060991

Hi,

is there a way, to truncate the log, when data and log are on the same
segment,
because dump transaction is not possible in this case.

Oliver


--
Oliver Lorenz
projectmanager for payment systems
Jalex Cash Processing GmbH / Germany
o-lorenz@wellcom.de


Anthony Mandic <amandic Posted on 2001-03-09 10:04:38.0Z
Date: Fri, 09 Mar 2001 20:04:38 +1000
From: Anthony Mandic <amandic@*t.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: How to truncate the log with data and log on the same segment
References: <tiGP#VHqAHA.258@forums.sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <eWWJVOIqAHA.199@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 9
NNTP-Posting-Host: CPE-208-111-111-203.syd.dav.net.au 203.111.111.208
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:433
Article PK: 1060951


Oliver Lorenz wrote:

> is there a way, to truncate the log, when data and log are on the same
> segment, because dump transaction is not possible in this case.

That's correct, its not possible. A truncation is the only
thing you can do. The command is 'dump tran <db_name> with
truncate_only'.

-am © 2001