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.

Missing Transaction Log File

4 posts in General Discussion Last posting was on 2003-11-06 18:33:37.0Z
Mark Cooper Posted on 2003-11-05 13:54:43.0Z
Sender: 5a7.3fa900e8.1804289383@sybase.com
From: Mark Cooper
Newsgroups: ianywhere.public.general
Subject: Missing Transaction Log File
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3fa90123.5ab.846930886@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 5 Nov 2003 05:54:43 -0800
X-Trace: forums-1-dub 1068040483 10.22.241.41 (5 Nov 2003 05:54:43 -0800)
X-Original-Trace: 5 Nov 2003 05:54:43 -0800, 10.22.241.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2023
Article PK: 4245

We have SQL Anywhere version 8 and have a missing
Transaction log file.
Is there anyway we can start the server without it, or with
an older version file.

The backups we have are old & we don't want to restore the
database backup from that time due to the amount of missing
data there would be.

Thank you.

Mark


Stephen Rice Posted on 2003-11-05 14:14:07.0Z
Newsgroups: ianywhere.public.general
Subject: Re: Missing Transaction Log File
From: Stephen Rice <srice_nospam@ianywhere.com>
References: <3fa90123.5ab.846930886@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns942A5C8C0E392sricenospamianywhere@10.22.241.106>
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: srice-pc.sybase.com
X-Original-NNTP-Posting-Host: srice-pc.sybase.com
Date: 5 Nov 2003 06:14:07 -0800
X-Trace: forums-1-dub 1068041647 172.31.141.106 (5 Nov 2003 06:14:07 -0800)
X-Original-Trace: 5 Nov 2003 06:14:07 -0800, srice-pc.sybase.com
Lines: 37
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2025
Article PK: 4238


Mark Cooper wrote in news:3fa90123.5ab.846930886@sybase.com:

> We have SQL Anywhere version 8 and have a missing
> Transaction log file.
> Is there anyway we can start the server without it, or with
> an older version file.
>
> The backups we have are old & we don't want to restore the
> database backup from that time due to the amount of missing
> data there would be.
>
> Thank you.
>
> Mark
>

I assume the server crashed and is not starting because it wants the
transaction log, since it would create a new transaction log if it had
shutdown cleanly.

You could use the -f switch on the database engine. I believe it will
do what you want. Be warned that you will lose all commited
transactions since the last checkpoint.

/steve


--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

- Please Post-
Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
Developer Community at www.ianywhere.com/developer


Mark Cooper Posted on 2003-11-06 11:54:12.0Z
Sender: 16fb.3faa33d2.1804289383@sybase.com
From: Mark Cooper
Newsgroups: ianywhere.public.general
Subject: Re: Missing Transaction Log File
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3faa3664.170f.846930886@sybase.com>
References: <3fa90123.5ab.846930886@sybase.com><Xns942A5C8C0E392sricenospamianywhere@10.22.241.106>
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 Nov 2003 03:54:12 -0800
X-Trace: forums-1-dub 1068119652 10.22.241.41 (6 Nov 2003 03:54:12 -0800)
X-Original-Trace: 6 Nov 2003 03:54:12 -0800, 10.22.241.41
Lines: 52
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2032
Article PK: 4249


> Mark Cooper wrote in
> news:3fa90123.5ab.846930886@sybase.com:
>
> > We have SQL Anywhere version 8 and have a missing
> > Transaction log file.
> > Is there anyway we can start the server without it, or
> > with an older version file.
> >
> > The backups we have are old & we don't want to restore
> > the database backup from that time due to the amount of
> > missing data there would be.
> >
> > Thank you.
> >
> > Mark
> >
>
> I assume the server crashed and is not starting because it
> wants the transaction log, since it would create a new
> transaction log if it had shutdown cleanly.
>
> You could use the -f switch on the database engine. I
> believe it will do what you want. Be warned that you
> will lose all commited transactions since the last
> checkpoint.
>
> /steve
>
>
> --
> Stephen Rice
> Technical Services Manager
> iAnywhere Solutions
>
> - Please Post-
> Whitepapers, TechDocs, and bug fixes are all available
> through the iAnywhere
> Developer Community at www.ianywhere.com/developer
>

Thanks for this - but I am having a problem with the -f
switch. The command keeps telling me it is unable to read
or open the database even though I have tried various
methods of defining the path and database name on the
command line. An example is:

dbsrv8.exe -f Ûpath­min.db -gd all -n %COMPUTERNAME% -gp
4096 -c 50m -ch 150m -x tcpip(ServerPort=2638)

Entering dbsrv8 /? doesn't give any details of the syntax
for this switch - just that it is a method to force db load
without a log file.


Chris Keating (iAnywhere Solutions) Posted on 2003-11-06 18:33:37.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <3fa90123.5ab.846930886@sybase.com><Xns942A5C8C0E392sricenospamianywhere@10.22.241.106> <3faa3664.170f.846930886@sybase.com>
Subject: Re: Missing Transaction Log File
Lines: 93
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: keating-xp.sybase.com
Message-ID: <3faa9533$1@forums-2-dub>
X-Original-Trace: 6 Nov 2003 10:38:43 -0800, keating-xp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 6 Nov 2003 10:25:11 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 6 Nov 2003 10:33:37 -0800
X-Trace: forums-1-dub 1068143617 10.22.108.75 (6 Nov 2003 10:33:37 -0800)
X-Original-Trace: 6 Nov 2003 10:33:37 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2038
Article PK: 4255

just run a simple command to force the engine to start

dbeng8 -f <database filename>

or

dbsrv8 -x shmem -f <database filename>


Make sure that the file name is fully quoted if the path is spacey.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

****************************************************************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

****************************************************************************
*

<Mark Cooper> wrote in message news:3faa3664.170f.846930886@sybase.com...
> Mark Cooper wrote in
> news:3fa90123.5ab.846930886@sybase.com:
>
> > We have SQL Anywhere version 8 and have a missing
> > Transaction log file.
> > Is there anyway we can start the server without it, or
> > with an older version file.
> >
> > The backups we have are old & we don't want to restore
> > the database backup from that time due to the amount of
> > missing data there would be.
> >
> > Thank you.
> >
> > Mark
> >
>
> I assume the server crashed and is not starting because it
> wants the transaction log, since it would create a new
> transaction log if it had shutdown cleanly.
>
> You could use the -f switch on the database engine. I
> believe it will do what you want. Be warned that you
> will lose all commited transactions since the last
> checkpoint.
>
> /steve
>
>
> --
> Stephen Rice
> Technical Services Manager
> iAnywhere Solutions
>
> - Please Post-
> Whitepapers, TechDocs, and bug fixes are all available
> through the iAnywhere
> Developer Community at www.ianywhere.com/developer
>

Thanks for this - but I am having a problem with the -f
switch. The command keeps telling me it is unable to read
or open the database even though I have tried various
methods of defining the path and database name on the
command line. An example is:

dbsrv8.exe -f Ûpath­min.db -gd all -n %COMPUTERNAME% -gp
4096 -c 50m -ch 150m -x tcpip(ServerPort=2638)

Entering dbsrv8 /? doesn't give any details of the syntax
for this switch - just that it is a method to force db load
without a log file.