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.

Dumping of Transaction logs for Tempdb and User databases

2 posts in Backup and Recovery Last posting was on 2001-04-18 00:30:10.0Z
Raman Posted on 2001-04-17 14:27:38.0Z
From: raman
Date: Tue, 17 Apr 2001 10:27:38 -0400
Newsgroups: sybase.public.sqlserver.backup+recovery
Subject: Dumping of Transaction logs for Tempdb and User databases
Message-ID: <12D79C535FB99056004F6F7085256A31.004F6F7985256A31@webforums>
Lines: 27
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:310
Article PK: 1060829

The following mesages appear on my Error log. I unchecked the "Truncate log
on Checkpoint" om all the user databases, tempdb.

server Space available in the log segment has fallen critically low in
database 'tempdb'. All future modifications to this database will be
suspended until the log is successfully dumped and space becomes available.
server background task message: LOG FULL: database 'tempdb'
server background task message: LOG DUMP: database 'tempdb', hreshold '16'
server Error: 4205, Severity: 16, State: 1
server Syslogs does not exist in its own segment in database 'tempdb' with
segmap '7' with logical start page number of '0'. You cannot use DUMP
TRANSACTION in this case, use DUMP DATABASE instead.
server background task message: LOG DUMP ERROR: 4205
server background task message: LOG DUMPED TO: device
'd:\sybdumps\prodtempdb_16.04.01_15:52:54
server background task message: LOG DUMP PAGES: Before: '31', After '31'
server background task message: LOG DUMP TIME: Apr 16 2001 3:52PM, Apr 16
2001 3:52PM
kernel Cannot send, host process disconnected: 1380 spid: 53
server Error: 1608, Severity: 18, State: 4
server A client process exited abnormally, or a network error was
encountered. Unless other errors occurred, continue processing normally.

My confusion is should i check the 'Truncate log on checkpoint' box and
still be able to recover if the disk crashes. Any help is appreciated.

Thanks.


Anthony Mandic <amandic Posted on 2001-04-18 00:30:10.0Z
Date: Wed, 18 Apr 2001 10:30:10 +1000
From: Anthony Mandic <amandic@*t.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Dumping of Transaction logs for Tempdb and User databases
References: <12D79C535FB99056004F6F7085256A31.004F6F7985256A31@webforums>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <T6uJ8F6xAHA.274@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 15
NNTP-Posting-Host: 210.9.51.46
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:304
Article PK: 1060821


raman wrote:
>
> The following mesages appear on my Error log. I unchecked the "Truncate log
> on Checkpoint" om all the user databases, tempdb.
...
> My confusion is should i check the 'Truncate log on checkpoint' box and
> still be able to recover if the disk crashes. Any help is appreciated.

Tempdb doesn't ordinarilly have this option displayed as being set
but it is always on in tempdb. There is nothing to recover in tempdb
- it is always rebuilt on server start. If tempdb fills, its either
not large enough or something is filling it up by mistake.

-am © 2001