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.

Not a Valid Database File

5 posts in General Discussion Last posting was on 2008-04-03 15:40:51.0Z
Gopala Reddy Posted on 2008-04-02 21:33:00.0Z
Sender: 65ca.47f3f95f.1804289383@sybase.com
From: Gopala Reddy
Newsgroups: ianywhere.public.general
Subject: Not a Valid Database File
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <47f3fb8c.65fa.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Apr 2008 13:33:00 -0800
X-Trace: forums-1-dub 1207171980 10.22.241.41 (2 Apr 2008 13:33:00 -0800)
X-Original-Trace: 2 Apr 2008 13:33:00 -0800, 10.22.241.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6792
Article PK: 5031

An error message pops up, when I try to open my sybase db
file using dbeng9.exe.

Error Message: c:\XXX.db is not a valid database file.

I tried opening my db with dben9.exe -f & -0 options etc,
but no luck.

Is there any way I could repair my db file, if it is
corrupted. Could you point me to some useful sybase database
repair tools?


"Nick Elson" < Posted on 2008-04-02 21:46:25.0Z
From: "Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@>
Newsgroups: ianywhere.public.general
References: <47f3fb8c.65fa.1681692777@sybase.com>
Subject: Re: Not a Valid Database File
Lines: 45
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47f3feb1@forums-1-dub>
Date: 2 Apr 2008 13:46:25 -0800
X-Trace: forums-1-dub 1207172785 10.22.241.152 (2 Apr 2008 13:46:25 -0800)
X-Original-Trace: 2 Apr 2008 13:46:25 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6793
Article PK: 5032

That is a fatal error and prevents all the tools available
to you from being able to do anything with the file.

Restoring from backups are always the best approach
with this kind of issue.

The error tells you nothing about what the degree of
damage is here. We know you have a main section of
the file that has been destroyed. Beyound that you don't
know if you have anything useful left or a big bag of
garbage (something all nulls).

If you do not have any backups available then read over
the following information to see what your appropriate
approach should be for your situation:

http://www.sybase.com/detail?id=1010805
["Recovering from a valid backup of the
database and transaction logs" ... and ...
"Recovering if there are no valid backups,
but a valid transaction log exists from
day 1 of the database " ... and ...
"Salvaging the database if there is no valid
backup and the database cannot be started "]

http://www.sybase.com/detail?id=1039322
[skip down to the last section
"What to do if you cannot resolve ...."
if you have no way to resolve this yourself]

<Gopala Reddy> wrote in message news:47f3fb8c.65fa.1681692777@sybase.com...
> An error message pops up, when I try to open my sybase db
> file using dbeng9.exe.
>
> Error Message: c:\XXX.db is not a valid database file.
>
> I tried opening my db with dben9.exe -f & -0 options etc,
> but no luck.
>
> Is there any way I could repair my db file, if it is
> corrupted. Could you point me to some useful sybase database
> repair tools?


John Smirnios Posted on 2008-04-03 13:46:53.0Z
From: John Smirnios <smirnios_at_sybase.com>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Not a Valid Database File
References: <47f3fb8c.65fa.1681692777@sybase.com> <47f3feb1@forums-1-dub>
In-Reply-To: <47f3feb1@forums-1-dub>
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: <47f4dfcd@forums-1-dub>
Date: 3 Apr 2008 05:46:53 -0800
X-Trace: forums-1-dub 1207230413 10.22.241.152 (3 Apr 2008 05:46:53 -0800)
X-Original-Trace: 3 Apr 2008 05:46:53 -0800, vip152.sybase.com
Lines: 63
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6797
Article PK: 5035

In particular, this error means that page zero (the first page) is
corrupt. Sometimes it can happen legitimately if, for example, it is a
newly created database but dbinit did not finish correctly. I don't
recall if this feature is in v9 (or even current software) but backups
may be marked as invalid until the backup is complete. Is it possibly an
incomplete backup file?

-john.

--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

Nick Elson wrote:
> That is a fatal error and prevents all the tools available
> to you from being able to do anything with the file.
>
> Restoring from backups are always the best approach
> with this kind of issue.
>
> The error tells you nothing about what the degree of
> damage is here. We know you have a main section of
> the file that has been destroyed. Beyound that you don't
> know if you have anything useful left or a big bag of
> garbage (something all nulls).
>
> If you do not have any backups available then read over
> the following information to see what your appropriate
> approach should be for your situation:
>
> http://www.sybase.com/detail?id=1010805
> ["Recovering from a valid backup of the
> database and transaction logs" ... and ...
> "Recovering if there are no valid backups,
> but a valid transaction log exists from
> day 1 of the database " ... and ...
> "Salvaging the database if there is no valid
> backup and the database cannot be started "]
>
> http://www.sybase.com/detail?id=1039322
> [skip down to the last section
> "What to do if you cannot resolve ...."
> if you have no way to resolve this yourself]
>
>
> <Gopala Reddy> wrote in message news:47f3fb8c.65fa.1681692777@sybase.com...
>> An error message pops up, when I try to open my sybase db
>> file using dbeng9.exe.
>>
>> Error Message: c:\XXX.db is not a valid database file.
>>
>> I tried opening my db with dben9.exe -f & -0 options etc,
>> but no luck.
>>
>> Is there any way I could repair my db file, if it is
>> corrupted. Could you point me to some useful sybase database
>> repair tools?
>
>


"Frank Ploessel" <fpl... Posted on 2008-04-03 15:10:37.0Z
Subject: Re: Not a Valid Database File
From: "Frank Ploessel" <fpl...@d_e.i_m_s_h_e_a_l_t_h.c_o_m>
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
References: <47f3fb8c.65fa.1681692777@sybase.com>
Content-Transfer-Encoding: 7bit
Message-ID: <op.t81i3zv9j0bybf@bonw00164.internal.imsglobal.com>
User-Agent: Opera Mail/9.21 (Win32)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 3 Apr 2008 07:10:37 -0800
X-Trace: forums-1-dub 1207235437 10.22.241.152 (3 Apr 2008 07:10:37 -0800)
X-Original-Trace: 3 Apr 2008 07:10:37 -0800, vip152.sybase.com
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6799
Article PK: 5038

Gopala,

Just a thought: Are you sure this is not a SQL Anywhere 10 db file?

Frank

On Wed, 02 Apr 2008 23:33:00 +0200, Gopala <Reddy> wrote:

> An error message pops up, when I try to open my sybase db
> file using dbeng9.exe.
>
> Error Message: c:\XXX.db is not a valid database file.
>
> I tried opening my db with dben9.exe -f & -0 options etc,
> but no luck.
>
> Is there any way I could repair my db file, if it is
> corrupted. Could you point me to some useful sybase database
> repair tools?


"Nick Elson" < Posted on 2008-04-03 15:40:51.0Z
From: "Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@>
Newsgroups: ianywhere.public.general
References: <47f3fb8c.65fa.1681692777@sybase.com> <op.t81i3zv9j0bybf@bonw00164.internal.imsglobal.com>
Subject: Re: Not a Valid Database File
Lines: 37
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47f4fa83$1@forums-1-dub>
Date: 3 Apr 2008 07:40:51 -0800
X-Trace: forums-1-dub 1207237251 10.22.241.152 (3 Apr 2008 07:40:51 -0800)
X-Original-Trace: 3 Apr 2008 07:40:51 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6800
Article PK: 5039

Frank is correct about that observation as well.
If it is not a compatabile file format (in this V10)
you can also get this error.

Further, other products (plus anyone who choses to)
can use the .db file name extension at will. Also in
many cases, dbspaces are created with .db as their
extension.

Further, a dbspace is not a database file [in the sense
of this error] but an extension to the main database so
it may also throw the same error.

"Frank Ploessel" <fpl...@d_e.i_m_s_h_e_a_l_t_h.c_o_m> wrote in message
news:op.t81i3zv9j0bybf@bonw00164.internal.imsglobal.com...
> Gopala,
>
> Just a thought: Are you sure this is not a SQL Anywhere 10 db file?
>
> Frank
>
> On Wed, 02 Apr 2008 23:33:00 +0200, Gopala <Reddy> wrote:
>
>> An error message pops up, when I try to open my sybase db
>> file using dbeng9.exe.
>>
>> Error Message: c:\XXX.db is not a valid database file.
>>
>> I tried opening my db with dben9.exe -f & -0 options etc,
>> but no luck.
>>
>> Is there any way I could repair my db file, if it is
>> corrupted. Could you point me to some useful sybase database
>> repair tools?
>