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.

tran log backup

2 posts in General Discussion Last posting was on 2010-10-31 17:01:15.0Z
guest1 Posted on 2010-10-25 19:38:51.0Z
Sender: 34d0.4cc5dc43.1804289383@sybase.com
From: guest1
Newsgroups: sybase.public.ase.general
Subject: tran log backup
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4cc5dccb.34dc.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 25 Oct 2010 12:38:51 -0700
X-Trace: forums-1-dub 1288035531 10.22.241.41 (25 Oct 2010 12:38:51 -0700)
X-Original-Trace: 25 Oct 2010 12:38:51 -0700, 10.22.241.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29660
Article PK: 78888

Tran log backup size is very large during reindex operation.
Larger than the allocated size for tran log file. Is this
normal occurrence?


Rob V [ Sybase ] Posted on 2010-10-31 17:01:15.0Z
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: tran log backup
References: <4cc5dccb.34dc.1681692777@sybase.com>
In-Reply-To: <4cc5dccb.34dc.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ccdaeeb$1@forums-1-dub>
Date: 31 Oct 2010 10:01:15 -0700
X-Trace: forums-1-dub 1288548075 10.22.241.152 (31 Oct 2010 10:01:15 -0700)
X-Original-Trace: 31 Oct 2010 10:01:15 -0700, vip152.sybase.com
Lines: 29
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29679
Article PK: 78908


On 25-Oct-2010 21:38, guest1 wrote:
> Tran log backup size is very large during reindex operation.
> Larger than the allocated size for tran log file. Is this
> normal occurrence?

This could well be normal. If,f or example, you're recreating the
clustered index on a table, the amount of transaction log size used will
be a bit bigger than than the table itself. If the table also has a
bunch of nonclustered idnexes, these will also all be rebuilt as a
result, adding to the amount of log records generated. Your existing
transaction log could easily be too small when this sort of things is done.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------