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.

Specified database not found using DBBackup

13 posts in General Discussion Last posting was on 2003-12-08 21:45:24.0Z
Richard Posted on 2003-12-01 16:33:50.0Z
Sender: 764b.3fcb6d2d.1804289383@sybase.com
From: Richard
Newsgroups: ianywhere.public.general
Subject: Specified database not found using DBBackup
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3fcb6d6e.764f.846930886@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 1 Dec 2003 08:33:50 -0800
X-Trace: forums-1-dub 1070296430 10.22.241.41 (1 Dec 2003 08:33:50 -0800)
X-Original-Trace: 1 Dec 2003 08:33:50 -0800, 10.22.241.41
Lines: 34
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2152
Article PK: 4364

I know this is probably an easy one but I can't seem to find
the right combination for this to work. I am trying to
backup a database that is running as a Service. The Service
is running when I am trying to backup the database (that is
the desired ability). Here is the command that I am
executing

dbbackup.exe -c "eng=sybase7;dbn=Mydb5;uid=dba;pwd=sql"
c:\temp

This is the messages that follows:
Adaptive Server Anywhere Backup Utility Version 8.0.2.4239
Specified database not found

In the Configuration for the service on Sybase Central it
looks like this:

-x "tcpip,shmem" -u -gb high -gp 4096 -p 4096 -c 64M -n
sybase7
c:\ldsdata7\mydb1.db
c:\ldsdata7\mydb2.db
C:\ldsdata7\mydb3.db
c:\ldsdata7\mydb4.db
C:\ldsdata7\mydb5.db
c:\ldsdata7\vramydb1.db
c:\ldsdata7\vramydb2.db
C:\ldsdata7\vramydb3.db
c:\ldsdata7\vramydb4.db
C:\ldsdata7\vramydb5.db

Does anyone have any ideas what I am missing?

Thanks!
Richard


Nick Elson Posted on 2003-12-02 17:53:50.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <3fcb6d6e.764f.846930886@sybase.com>
Subject: Re: Specified database not found using DBBackup
Lines: 43
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
NNTP-Posting-Host: nicelson-xp.sybase.com
X-Original-NNTP-Posting-Host: nicelson-xp.sybase.com
Message-ID: <3fccd1ae@forums-1-dub>
Date: 2 Dec 2003 09:53:50 -0800
X-Trace: forums-1-dub 1070387630 172.31.143.54 (2 Dec 2003 09:53:50 -0800)
X-Original-Trace: 2 Dec 2003 09:53:50 -0800, nicelson-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2162
Article PK: 4371

The "Specified database not found" error usually occurs because
you are connecting to the wrong engine. Any other engines or
servers running on that machine? Is dbbackup being ran on
a different machine than the database server?

<Richard> wrote in message news:3fcb6d6e.764f.846930886@sybase.com...
> I know this is probably an easy one but I can't seem to find
> the right combination for this to work. I am trying to
> backup a database that is running as a Service. The Service
> is running when I am trying to backup the database (that is
> the desired ability). Here is the command that I am
> executing
>
> dbbackup.exe -c "eng=sybase7;dbn=Mydb5;uid=dba;pwd=sql"
> c:\temp
>
> This is the messages that follows:
> Adaptive Server Anywhere Backup Utility Version 8.0.2.4239
> Specified database not found
>
> In the Configuration for the service on Sybase Central it
> looks like this:
>
> -x "tcpip,shmem" -u -gb high -gp 4096 -p 4096 -c 64M -n
> sybase7
> c:\ldsdata7\mydb1.db
> c:\ldsdata7\mydb2.db
> C:\ldsdata7\mydb3.db
> c:\ldsdata7\mydb4.db
> C:\ldsdata7\mydb5.db
> c:\ldsdata7\vramydb1.db
> c:\ldsdata7\vramydb2.db
> C:\ldsdata7\vramydb3.db
> c:\ldsdata7\vramydb4.db
> C:\ldsdata7\vramydb5.db
>
> Does anyone have any ideas what I am missing?
>
> Thanks!
> Richard


Richard Posted on 2003-12-02 18:10:04.0Z
Sender: 3dd3.3fccd652.1804289383@sybase.com
From: Richard
Newsgroups: ianywhere.public.general
Subject: Re: Specified database not found using DBBackup
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3fccd70c.3ddb.846930886@sybase.com>
References: <3fcb6d6e.764f.846930886@sybase.com><3fccd1ae@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 2 Dec 2003 10:16:44 -0800, 10.22.241.42
Lines: 50
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 2 Dec 2003 09:59:05 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 2 Dec 2003 10:10:04 -0800
X-Trace: forums-1-dub 1070388604 10.22.108.75 (2 Dec 2003 10:10:04 -0800)
X-Original-Trace: 2 Dec 2003 10:10:04 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2163
Article PK: 17368

It is running locally on the server...There are two engines
running sybase8 and sybase7. Do I need to specify and How?

Thanks
Richard

> The "Specified database not found" error usually occurs
> because you are connecting to the wrong engine. Any other
> engines or servers running on that machine? Is dbbackup
> being ran on a different machine than the database server?
>
>
> <Richard> wrote in message
> > news:3fcb6d6e.764f.846930886@sybase.com... I know this
> > is probably an easy one but I can't seem to find the
> > right combination for this to work. I am trying to
> backup a database that is running as a Service. The
> > Service is running when I am trying to backup the
> > database (that is the desired ability). Here is the
> > command that I am executing
> >
> > dbbackup.exe -c "eng=sybase7;dbn=Mydb5;uid=dba;pwd=sql"
> > c:\temp
> >
> > This is the messages that follows:
> > Adaptive Server Anywhere Backup Utility Version
> > 8.0.2.4239 Specified database not found
> >
> > In the Configuration for the service on Sybase Central
> > it looks like this:
> >
> > -x "tcpip,shmem" -u -gb high -gp 4096 -p 4096 -c 64M -n
> > sybase7
> > c:\ldsdata7\mydb1.db
> > c:\ldsdata7\mydb2.db
> > C:\ldsdata7\mydb3.db
> > c:\ldsdata7\mydb4.db
> > C:\ldsdata7\mydb5.db
> > c:\ldsdata7\vramydb1.db
> > c:\ldsdata7\vramydb2.db
> > C:\ldsdata7\vramydb3.db
> > c:\ldsdata7\vramydb4.db
> > C:\ldsdata7\vramydb5.db
> >
> > Does anyone have any ideas what I am missing?
> >
> > Thanks!
> > Richard
>
>


Nick Elson Posted on 2003-12-02 19:19:23.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <3fcb6d6e.764f.846930886@sybase.com><3fccd1ae@forums-1-dub> <3fccd70c.3ddb.846930886@sybase.com>
Subject: Re: Specified database not found using DBBackup
Lines: 57
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: nicelson-xp.sybase.com
Message-ID: <3fcce74b$1@forums-2-dub>
X-Original-Trace: 2 Dec 2003 11:26:03 -0800, nicelson-xp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 2 Dec 2003 11:08:23 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 2 Dec 2003 11:19:23 -0800
X-Trace: forums-1-dub 1070392763 10.22.108.75 (2 Dec 2003 11:19:23 -0800)
X-Original-Trace: 2 Dec 2003 11:19:23 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2164
Article PK: 17334

Show your command lines for both of those servers. You will also
want to capture the -z -o output while those are starting up.

<Richard> wrote in message news:3fccd70c.3ddb.846930886@sybase.com...
> It is running locally on the server...There are two engines
> running sybase8 and sybase7. Do I need to specify and How?
>
> Thanks
> Richard
>
> > The "Specified database not found" error usually occurs
> > because you are connecting to the wrong engine. Any other
> > engines or servers running on that machine? Is dbbackup
> > being ran on a different machine than the database server?
> >
> >
> > <Richard> wrote in message
> > > news:3fcb6d6e.764f.846930886@sybase.com... I know this
> > > is probably an easy one but I can't seem to find the
> > > right combination for this to work. I am trying to
> > backup a database that is running as a Service. The
> > > Service is running when I am trying to backup the
> > > database (that is the desired ability). Here is the
> > > command that I am executing
> > >
> > > dbbackup.exe -c "eng=sybase7;dbn=Mydb5;uid=dba;pwd=sql"
> > > c:\temp
> > >
> > > This is the messages that follows:
> > > Adaptive Server Anywhere Backup Utility Version
> > > 8.0.2.4239 Specified database not found
> > >
> > > In the Configuration for the service on Sybase Central
> > > it looks like this:
> > >
> > > -x "tcpip,shmem" -u -gb high -gp 4096 -p 4096 -c 64M -n
> > > sybase7
> > > c:\ldsdata7\mydb1.db
> > > c:\ldsdata7\mydb2.db
> > > C:\ldsdata7\mydb3.db
> > > c:\ldsdata7\mydb4.db
> > > C:\ldsdata7\mydb5.db
> > > c:\ldsdata7\vramydb1.db
> > > c:\ldsdata7\vramydb2.db
> > > C:\ldsdata7\vramydb3.db
> > > c:\ldsdata7\vramydb4.db
> > > C:\ldsdata7\vramydb5.db
> > >
> > > Does anyone have any ideas what I am missing?
> > >
> > > Thanks!
> > > Richard
> >
> >


Richard Posted on 2003-12-02 19:42:55.0Z
Sender: 4022.3fccec4e.1804289383@sybase.com
From: Richard
Newsgroups: ianywhere.public.general
Subject: Re: Specified database not found using DBBackup
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3fccecd0.4027.846930886@sybase.com>
References: <3fcb6d6e.764f.846930886@sybase.com><3fccd1ae@forums-1-dub> <3fccd70c.3ddb.846930886@sybase.com><3fcce74b$1@forums-2-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 2 Dec 2003 11:49:36 -0800, 10.22.241.42
Lines: 63
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 2 Dec 2003 11:31:56 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 2 Dec 2003 11:42:55 -0800
X-Trace: forums-1-dub 1070394175 10.22.108.75 (2 Dec 2003 11:42:55 -0800)
X-Original-Trace: 2 Dec 2003 11:42:55 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2165
Article PK: 17363

I was wrong about the two engines running there were two
Services running...I deleted one of the services and still
having the same problem...I will try your logging at
startup..and send post in a minute

> Show your command lines for both of those servers. You
> will also want to capture the -z -o output while those are
> starting up.
>
>
> <Richard> wrote in message
> > news:3fccd70c.3ddb.846930886@sybase.com... It is running
> > locally on the server...There are two engines running
> sybase8 and sybase7. Do I need to specify and How? >
> > Thanks
> > Richard
> >
> > > The "Specified database not found" error usually
> > > occurs because you are connecting to the wrong engine.
> > > Any other engines or servers running on that machine?
> > > Is dbbackup being ran on a different machine than the
> > database server? >
> > >
> > > <Richard> wrote in message
> > > > news:3fcb6d6e.764f.846930886@sybase.com... I know
> > > > this is probably an easy one but I can't seem to
> > > > find the right combination for this to work. I am
> > > trying to backup a database that is running as a
> > > > Service. The Service is running when I am trying to
> > > > backup the database (that is the desired ability).
> > > > Here is the command that I am executing
> > > >
> > > > dbbackup.exe -c "eng=sybase7;dbn=Mydb5;uid=dba
> > > > ;pwd=sql" c:\temp
> > > >
> > > > This is the messages that follows:
> > > > Adaptive Server Anywhere Backup Utility Version
> > > > 8.0.2.4239 Specified database not found
> > > >
> > > > In the Configuration for the service on Sybase
> > > > Central it looks like this:
> > > >
> > > > -x "tcpip,shmem" -u -gb high -gp 4096 -p 4096 -c 64M
> > > > -n sybase7
> > > > c:\ldsdata7\mydb1.db
> > > > c:\ldsdata7\mydb2.db
> > > > C:\ldsdata7\mydb3.db
> > > > c:\ldsdata7\mydb4.db
> > > > C:\ldsdata7\mydb5.db
> > > > c:\ldsdata7\vramydb1.db
> > > > c:\ldsdata7\vramydb2.db
> > > > C:\ldsdata7\vramydb3.db
> > > > c:\ldsdata7\vramydb4.db
> > > > C:\ldsdata7\vramydb5.db
> > > >
> > > > Does anyone have any ideas what I am missing?
> > > >
> > > > Thanks!
> > > > Richard
> > >
> > >
>
>


Richard Posted on 2003-12-02 19:57:50.0Z
Sender: 4065.3fccf002.1804289383@sybase.com
From: Richard
Newsgroups: ianywhere.public.general
Subject: Re: Specified database not found using DBBackup
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3fccf04e.406d.846930886@sybase.com>
References: <3fcb6d6e.764f.846930886@sybase.com><3fccd1ae@forums-1-dub> <3fccd70c.3ddb.846930886@sybase.com><3fcce74b$1@forums-2-dub><3fccecd0.4027.846930886@sybase.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-2-dub3fccf04e"
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 2 Dec 2003 12:04:30 -0800, 10.22.241.42
Lines: 236
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 2 Dec 2003 11:46:50 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 2 Dec 2003 11:57:50 -0800
X-Trace: forums-1-dub 1070395070 10.22.108.75 (2 Dec 2003 11:57:50 -0800)
X-Original-Trace: 2 Dec 2003 11:57:50 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2166
Article PK: 17361

Here is the Logfile

> I was wrong about the two engines running there were two
> Services running...I deleted one of the services and still
> having the same problem...I will try your logging at
> startup..and send post in a minute
>
> > Show your command lines for both of those servers. You
> > will also want to capture the -z -o output while those
> > are starting up.
> >
> >
> > <Richard> wrote in message
> > > news:3fccd70c.3ddb.846930886@sybase.com... It is
> > > running locally on the server...There are two engines
> > running sybase8 and sybase7. Do I need to specify and
> > > How? > Thanks
> > > Richard
> > >
> > > > The "Specified database not found" error usually
> > > > occurs because you are connecting to the wrong
> > > > engine. Any other engines or servers running on
> > > > that machine? Is dbbackup being ran on a different
> > > machine than the database server? >
> > > >
> > > > <Richard> wrote in message
> > > > > news:3fcb6d6e.764f.846930886@sybase.com... I know
> > > > > this is probably an easy one but I can't seem to
> > > > > find the right combination for this to work. I am
> > > > trying to backup a database that is running as a
> > > > > Service. The Service is running when I am trying
> > > > > to backup the database (that is the desired
> > > > > ability). Here is the command that I am executing
> > > > >
> > > > > dbbackup.exe -c "eng=sybase7;dbn=Mydb5;uid=dba
> > > > > ;pwd=sql" c:\temp
> > > > >
> > > > > This is the messages that follows:
> > > > > Adaptive Server Anywhere Backup Utility Version
> > > > > 8.0.2.4239 Specified database not found
> > > > >
> > > > > In the Configuration for the service on Sybase
> > > > > Central it looks like this:
> > > > >
> > > > > -x "tcpip,shmem" -u -gb high -gp 4096 -p 4096 -c
> > > > > 64M -n sybase7
> > > > > c:\ldsdata7\mydb1.db
> > > > > c:\ldsdata7\mydb2.db
> > > > > C:\ldsdata7\mydb3.db
> > > > > c:\ldsdata7\mydb4.db
> > > > > C:\ldsdata7\mydb5.db
> > > > > c:\ldsdata7\vramydb1.db
> > > > > c:\ldsdata7\vramydb2.db
> > > > > C:\ldsdata7\vramydb3.db
> > > > > c:\ldsdata7\vramydb4.db
> > > > > C:\ldsdata7\vramydb5.db
> > > > >
> > > > > Does anyone have any ideas what I am missing?
> > > > >
> > > > > Thanks!
> > > > > Richard
> > > >
> > > >
> >
> >

I. 12/02 13:42:23. 1: -o
I. 12/02 13:42:23. 2: c:\myLog
I. 12/02 13:42:23. 3: -z
I. 12/02 13:42:23. 4: -x
I. 12/02 13:42:23. 5: tcpip,shmem
I. 12/02 13:42:23. 6: -u
I. 12/02 13:42:23. 7: -gb
I. 12/02 13:42:23. 8: high
I. 12/02 13:42:23. 9: -gp
I. 12/02 13:42:23. 10: 4096
I. 12/02 13:42:23. 11: -p
I. 12/02 13:42:23. 12: 4096
I. 12/02 13:42:23. 13: -c
I. 12/02 13:42:23. 14: 64M
I. 12/02 13:42:23. 15: -n
I. 12/02 13:42:23. 16: sybase7
I. 12/02 13:42:23. 17: c:\ldsdata7\AmericanIndustrial.db
I. 12/02 13:42:23. 18: c:\ldsdata7\gmsme_rb.db
I. 12/02 13:42:23. 19: C:\ldsdata7\SummitCold7.db
I. 12/02 13:42:23. 20: c:\ldsdata7\vraAmericanIndustrial.db
I. 12/02 13:42:23. 21: c:\ldsdata7\vragmsme_rb.db
I. 12/02 13:42:23. 22: C:\ldsdata7\vraSummitCold7.db

I. 12/02 13:42:23. Sybase Adaptive Server Anywhere Network Server Version 8.0.2.4339

I. 12/02 13:42:23. Copyright © 1989-2002 Sybase, Inc.
I. 12/02 13:42:23. Portions Copyright © 2002, iAnywhere Solutions, Inc.
I. 12/02 13:42:23. All rights reserved. All unpublished rights reserved.
I. 12/02 13:42:23.
I. 12/02 13:42:23. This software contains confidential and trade secret information of
I. 12/02 13:42:23. iAnywhere Solutions, Inc.
I. 12/02 13:42:23. Use, duplication or disclosure of the software and documentation
I. 12/02 13:42:23. by the U.S. Government is subject to restrictions set forth in a license
I. 12/02 13:42:23. agreement between the Government and iAnywhere Solutions, Inc. or
I. 12/02 13:42:23. other written agreement specifying the Government's rights to use the
I. 12/02 13:42:23. software and any applicable FAR provisions, for example, FAR 52.227-19.
I. 12/02 13:42:23.
I. 12/02 13:42:23. Sybase, Inc., One Sybase Drive, Dublin, CA 94568, USA

I. 12/02 13:42:23. Concurrent Seat model. Access to the server is limited to 10 concurrent seat(s).
I. 12/02 13:42:23. This server is licensed to:
I. 12/02 13:42:23. Support 2000
I. 12/02 13:42:23. LDS
I. 12/02 13:42:23. 65536K of memory used for caching
I. 12/02 13:42:23. Minimum cache size: 65536K, maximum cache size: 262144K
I. 12/02 13:42:23. Using a maximum page size of 4096 bytes
I. 12/02 13:42:23. Starting database "AmericanIndustrial" (c:\ldsdata7\AmericanIndustrial.db) at Tue Dec 02 2003 13:42
I. 12/02 13:42:23. Starting database "gmsme_rb" (c:\ldsdata7\gmsme_rb.db) at Tue Dec 02 2003 13:42
I. 12/02 13:42:23. Starting database "SummitCold7" (C:\ldsdata7\SummitCold7.db) at Tue Dec 02 2003 13:42
I. 12/02 13:42:23. Starting database "vraAmericanIndustrial" (c:\ldsdata7\vraAmericanIndustrial.db) at Tue Dec 02 2003 13:42
I. 12/02 13:42:23. Starting database "vraSummitCold7" (C:\ldsdata7\vraSummitCold7.db) at Tue Dec 02 2003 13:42
I. 12/02 13:42:23. Starting database "vragmsme_rb" (c:\ldsdata7\vragmsme_rb.db) at Tue Dec 02 2003 13:42
I. 12/02 13:42:23. Database file "c:\ldsdata7\AmericanIndustrial.db" consists of 713 disk fragments
I. 12/02 13:42:23. Database file "c:\ldsdata7\vraAmericanIndustrial.db" consists of 10 disk fragments
I. 12/02 13:42:23. Database file "C:\ldsdata7\vraSummitCold7.db" consists of 10 disk fragments
I. 12/02 13:42:23. Database file "c:\ldsdata7\vragmsme_rb.db" consists of 15 disk fragments
I. 12/02 13:42:26. Transaction log: C:\Ldsdata7\VRAsummitcold7.log
I. 12/02 13:42:26. Transaction log: C:\Ldsdata7\VRAamericanindustrial.log
I. 12/02 13:42:26. Transaction log: C:\Ldsdata7\VRAgmsme_rb.log
I. 12/02 13:42:27. Starting checkpoint of "vraSummitCold7" (vraSummitCold7.db) at Tue Dec 02 2003 13:42
I. 12/02 13:42:27. Starting checkpoint of "vraAmericanIndustrial" (vraAmericanIndustrial.db) at Tue Dec 02 2003 13:42
I. 12/02 13:42:27. Starting checkpoint of "vragmsme_rb" (vragmsme_rb.db) at Tue Dec 02 2003 13:42
I. 12/02 13:42:28. Transaction log: summitcold_rb.log
I. 12/02 13:42:28. Starting checkpoint of "SummitCold7" (SummitCold7.db) at Tue Dec 02 2003 13:42
I. 12/02 13:42:28. Finished checkpoint of "vraSummitCold7" (vraSummitCold7.db) at Tue Dec 02 2003 13:42
I. 12/02 13:42:28. Finished checkpoint of "vraAmericanIndustrial" (vraAmericanIndustrial.db) at Tue Dec 02 2003 13:42
I. 12/02 13:42:28. Finished checkpoint of "vragmsme_rb" (vragmsme_rb.db) at Tue Dec 02 2003 13:42
I. 12/02 13:42:28. Finished checkpoint of "SummitCold7" (SummitCold7.db) at Tue Dec 02 2003 13:42
I. 12/02 13:42:28. Database "vraSummitCold7" (vraSummitCold7.db) started at Tue Dec 02 2003 13:42
I. 12/02 13:42:29. Database "vraAmericanIndustrial" (vraAmericanIndustrial.db) started at Tue Dec 02 2003 13:42
I. 12/02 13:42:29. Database "vragmsme_rb" (vragmsme_rb.db) started at Tue Dec 02 2003 13:42
I. 12/02 13:42:29. Database "SummitCold7" (SummitCold7.db) started at Tue Dec 02 2003 13:42
I. 12/02 13:42:29. Database was created with older software and may benefit from being rebuilt
I. 12/02 13:42:29. Transaction log: C:\Ldsdata7\americanindustrial.log
I. 12/02 13:42:29. Starting checkpoint of "AmericanIndustrial" (AmericanIndustrial.db) at Tue Dec 02 2003 13:42
I. 12/02 13:42:30. Finished checkpoint of "AmericanIndustrial" (AmericanIndustrial.db) at Tue Dec 02 2003 13:42
I. 12/02 13:42:30. Transaction log: c:\ldsdata7\gmsme_rb.log
I. 12/02 13:42:30. Starting checkpoint of "gmsme_rb" (gmsme_rb.db) at Tue Dec 02 2003 13:42
I. 12/02 13:42:30. Finished checkpoint of "gmsme_rb" (gmsme_rb.db) at Tue Dec 02 2003 13:42
I. 12/02 13:42:31. Database "gmsme_rb" (gmsme_rb.db) started at Tue Dec 02 2003 13:42
I. 12/02 13:42:31. Database was created with older software and may benefit from being rebuilt
I. 12/02 13:42:31. Database "AmericanIndustrial" (AmericanIndustrial.db) started at Tue Dec 02 2003 13:42
I. 12/02 13:42:31. Database was created with older software and may benefit from being rebuilt
I. 12/02 13:42:31. Database server started at Tue Dec 02 2003 13:42
I. 12/02 13:42:31. Trying to start SharedMemory link ...
I. 12/02 13:42:31. SharedMemory link started successfully
I. 12/02 13:42:31. Trying to start TCPIP link ...
I. 12/02 13:42:31. Loading ws2_32.dll
I. 12/02 13:42:31. TCP using Winsock version 2.0
I. 12/02 13:42:31. Starting TCP listener on IP address 0.0.0.0:2638
I. 12/02 13:42:31. Starting on port 2638
I. 12/02 13:42:31. Starting UDP listener on IP address 127.0.0.1:2638
I. 12/02 13:42:31. This is a class A network address
I. 12/02 13:42:31. Starting UDP listener on IP address 209.242.115.131:2638
I. 12/02 13:42:31. This is a class C network address
I. 12/02 13:42:31. Looking for server with name sybase7
I. 12/02 13:42:31. Sending broadcast to find server
I. 12/02 13:42:31. Using broadcast address of: 127.255.255.255:2638
I. 12/02 13:42:31. Looking for server with name sybase7
I. 12/02 13:42:31. Sending broadcast to find server
I. 12/02 13:42:31. Using broadcast address of: 209.242.115.255:2638
I. 12/02 13:42:36. Server not found (no reply received)
I. 12/02 13:42:36. TCPIP link started successfully
I. 12/02 13:42:36. Now accepting requests


Nick Elson Posted on 2003-12-03 06:42:00.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <3fcb6d6e.764f.846930886@sybase.com><3fccd1ae@forums-1-dub> <3fccd70c.3ddb.846930886@sybase.com><3fcce74b$1@forums-2-dub><3fccecd0.4027.846930886@sybase.com> <3fccf04e.406d.846930886@sybase.com>
Subject: Re: Specified database not found using DBBackup
Lines: 74
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
NNTP-Posting-Host: cpe0050bf17594c-cm014370028576.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpe0050bf17594c-cm014370028576.cpe.net.cable.rogers.com
Message-ID: <3fcd85b8@forums-1-dub>
Date: 2 Dec 2003 22:42:00 -0800
X-Trace: forums-1-dub 1070433720 65.48.253.93 (2 Dec 2003 22:42:00 -0800)
X-Original-Trace: 2 Dec 2003 22:42:00 -0800, cpe0050bf17594c-cm014370028576.cpe.net.cable.rogers.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2169
Article PK: 4376

Okay that is great. Which database is Mydb5?

<Richard> wrote in message news:3fccf04e.406d.846930886@sybase.com...
> Here is the Logfile
>
>
> > I was wrong about the two engines running there were two
> > Services running...I deleted one of the services and still
> > having the same problem...I will try your logging at
> > startup..and send post in a minute
> >
> > > Show your command lines for both of those servers. You
> > > will also want to capture the -z -o output while those
> > > are starting up.
> > >
> > >
> > > <Richard> wrote in message
> > > > news:3fccd70c.3ddb.846930886@sybase.com... It is
> > > > running locally on the server...There are two engines
> > > running sybase8 and sybase7. Do I need to specify and
> > > > How? > Thanks
> > > > Richard
> > > >
> > > > > The "Specified database not found" error usually
> > > > > occurs because you are connecting to the wrong
> > > > > engine. Any other engines or servers running on
> > > > > that machine? Is dbbackup being ran on a different
> > > > machine than the database server? >
> > > > >
> > > > > <Richard> wrote in message
> > > > > > news:3fcb6d6e.764f.846930886@sybase.com... I know
> > > > > > this is probably an easy one but I can't seem to
> > > > > > find the right combination for this to work. I am
> > > > > trying to backup a database that is running as a
> > > > > > Service. The Service is running when I am trying
> > > > > > to backup the database (that is the desired
> > > > > > ability). Here is the command that I am executing
> > > > > >
> > > > > > dbbackup.exe -c "eng=sybase7;dbn=Mydb5;uid=dba
> > > > > > ;pwd=sql" c:\temp
> > > > > >
> > > > > > This is the messages that follows:
> > > > > > Adaptive Server Anywhere Backup Utility Version
> > > > > > 8.0.2.4239 Specified database not found
> > > > > >
> > > > > > In the Configuration for the service on Sybase
> > > > > > Central it looks like this:
> > > > > >
> > > > > > -x "tcpip,shmem" -u -gb high -gp 4096 -p 4096 -c
> > > > > > 64M -n sybase7
> > > > > > c:\ldsdata7\mydb1.db
> > > > > > c:\ldsdata7\mydb2.db
> > > > > > C:\ldsdata7\mydb3.db
> > > > > > c:\ldsdata7\mydb4.db
> > > > > > C:\ldsdata7\mydb5.db
> > > > > > c:\ldsdata7\vramydb1.db
> > > > > > c:\ldsdata7\vramydb2.db
> > > > > > C:\ldsdata7\vramydb3.db
> > > > > > c:\ldsdata7\vramydb4.db
> > > > > > C:\ldsdata7\vramydb5.db
> > > > > >
> > > > > > Does anyone have any ideas what I am missing?
> > > > > >
> > > > > > Thanks!
> > > > > > Richard
> > > > >
> > > > >
> > >
> > >
>


Richard Posted on 2003-12-03 13:46:40.0Z
Sender: 4aef.3fcdea53.1804289383@sybase.com
From: Richard
Newsgroups: ianywhere.public.general
Subject: Re: Specified database not found using DBBackup
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3fcdead3.4af9.846930886@sybase.com>
References: <3fcb6d6e.764f.846930886@sybase.com><3fccd1ae@forums-1-dub> <3fccd70c.3ddb.846930886@sybase.com><3fcce74b$1@forums-2-dub><3fccecd0.4027.846930886@sybase.com> <3fccf04e.406d.846930886@sybase.com><3fcd85b8@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 3 Dec 2003 05:53:23 -0800, 10.22.241.42
Lines: 77
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Dec 2003 05:35:36 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Dec 2003 05:46:40 -0800
X-Trace: forums-1-dub 1070459200 10.22.108.75 (3 Dec 2003 05:46:40 -0800)
X-Original-Trace: 3 Dec 2003 05:46:40 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2171
Article PK: 4377

summitcold7.db ...it doesn't matter which one I pick they
all get the same result...

> Okay that is great. Which database is Mydb5?
>
>
>
> <Richard> wrote in message
> > news:3fccf04e.406d.846930886@sybase.com... Here is the
> Logfile >
> >
> > > I was wrong about the two engines running there were
> > > two Services running...I deleted one of the services
> > > and still having the same problem...I will try your
> > > logging at startup..and send post in a minute
> > >
> > > > Show your command lines for both of those servers.
> > > > You will also want to capture the -z -o output while
> > > > those are starting up.
> > > >
> > > >
> > > > <Richard> wrote in message
> > > > > news:3fccd70c.3ddb.846930886@sybase.com... It is
> > > > > running locally on the server...There are two
> > > > engines running sybase8 and sybase7. Do I need to
> > > > > specify and How? > Thanks
> > > > > Richard
> > > > >
> > > > > > The "Specified database not found" error usually
> > > > > > occurs because you are connecting to the wrong
> > > > > > engine. Any other engines or servers running on
> > > > > > that machine? Is dbbackup being ran on a
> > > > > different machine than the database server? >
> > > > > >
> > > > > > <Richard> wrote in message
> > > > > > > news:3fcb6d6e.764f.846930886@sybase.com... I
> > > > > > > know this is probably an easy one but I can't
> > > > > > > seem to find the right combination for this to
> > > > > > work. I am trying to backup a database that is
> > > > > > > running as a Service. The Service is running
> > > > > > > when I am trying to backup the database (that
> > > > > > > is the desired ability). Here is the command
> > > > > > that I am executing >
> > > > > > > dbbackup.exe -c "eng=sybase7;dbn=Mydb5;uid=dba
> > > > > > > ;pwd=sql" c:\temp
> > > > > > >
> > > > > > > This is the messages that follows:
> > > > > > > Adaptive Server Anywhere Backup Utility
> > > > > > > Version 8.0.2.4239 Specified database not
> > > > > > found >
> > > > > > > In the Configuration for the service on Sybase
> > > > > > > Central it looks like this:
> > > > > > >
> > > > > > > -x "tcpip,shmem" -u -gb high -gp 4096 -p 4096
> > > > > > > -c 64M -n sybase7
> > > > > > > c:\ldsdata7\mydb1.db
> > > > > > > c:\ldsdata7\mydb2.db
> > > > > > > C:\ldsdata7\mydb3.db
> > > > > > > c:\ldsdata7\mydb4.db
> > > > > > > C:\ldsdata7\mydb5.db
> > > > > > > c:\ldsdata7\vramydb1.db
> > > > > > > c:\ldsdata7\vramydb2.db
> > > > > > > C:\ldsdata7\vramydb3.db
> > > > > > > c:\ldsdata7\vramydb4.db
> > > > > > > C:\ldsdata7\vramydb5.db
> > > > > > >
> > > > > > > Does anyone have any ideas what I am missing?
> > > > > > >
> > > > > > > Thanks!
> > > > > > > Richard
> > > > > >
> > > > > >
> > > >
> > > >
> >
>
>


Nick Elson Posted on 2003-12-03 14:24:12.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <3fcb6d6e.764f.846930886@sybase.com><3fccd1ae@forums-1-dub> <3fccd70c.3ddb.846930886@sybase.com><3fcce74b$1@forums-2-dub><3fccecd0.4027.846930886@sybase.com> <3fccf04e.406d.846930886@sybase.com><3fcd85b8@forums-1-dub> <3fcdead3.4af9.846930886@sybase.com>
Subject: Re: Specified database not found using DBBackup
Lines: 100
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: surfec007.sybase.com
Message-ID: <3fcdf38c@forums-2-dub>
X-Original-Trace: 3 Dec 2003 06:30:36 -0800, surfec007.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Dec 2003 06:13:08 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Dec 2003 06:24:12 -0800
X-Trace: forums-1-dub 1070461452 10.22.108.75 (3 Dec 2003 06:24:12 -0800)
X-Original-Trace: 3 Dec 2003 06:24:12 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2172
Article PK: 4381

Great. Now debug the connection.

If you had

dbbackup.exe -c "eng=sybase7;dbn=summitcold7;uid=dba;pwd=sql"
c:\temp

try this instead

dbbackup.exe -c
"log=<yourchoice_of_a_filename>.log;eng=sybase7;dbn=summitcold7;uid=dba;pwd=
sql" c:\temp

after which see whatever you called your <yourchoice_of_a_filename>.log
has in it.

Adding -z and -zr all to the server will show even more details of the
connection
from the server side.

<Richard> wrote in message news:3fcdead3.4af9.846930886@sybase.com...
> summitcold7.db ...it doesn't matter which one I pick they
> all get the same result...
>
> > Okay that is great. Which database is Mydb5?
> >
> >
> >
> > <Richard> wrote in message
> > > news:3fccf04e.406d.846930886@sybase.com... Here is the
> > Logfile >
> > >
> > > > I was wrong about the two engines running there were
> > > > two Services running...I deleted one of the services
> > > > and still having the same problem...I will try your
> > > > logging at startup..and send post in a minute
> > > >
> > > > > Show your command lines for both of those servers.
> > > > > You will also want to capture the -z -o output while
> > > > > those are starting up.
> > > > >
> > > > >
> > > > > <Richard> wrote in message
> > > > > > news:3fccd70c.3ddb.846930886@sybase.com... It is
> > > > > > running locally on the server...There are two
> > > > > engines running sybase8 and sybase7. Do I need to
> > > > > > specify and How? > Thanks
> > > > > > Richard
> > > > > >
> > > > > > > The "Specified database not found" error usually
> > > > > > > occurs because you are connecting to the wrong
> > > > > > > engine. Any other engines or servers running on
> > > > > > > that machine? Is dbbackup being ran on a
> > > > > > different machine than the database server? >
> > > > > > >
> > > > > > > <Richard> wrote in message
> > > > > > > > news:3fcb6d6e.764f.846930886@sybase.com... I
> > > > > > > > know this is probably an easy one but I can't
> > > > > > > > seem to find the right combination for this to
> > > > > > > work. I am trying to backup a database that is
> > > > > > > > running as a Service. The Service is running
> > > > > > > > when I am trying to backup the database (that
> > > > > > > > is the desired ability). Here is the command
> > > > > > > that I am executing >
> > > > > > > > dbbackup.exe -c "eng=sybase7;dbn=Mydb5;uid=dba
> > > > > > > > ;pwd=sql" c:\temp
> > > > > > > >
> > > > > > > > This is the messages that follows:
> > > > > > > > Adaptive Server Anywhere Backup Utility
> > > > > > > > Version 8.0.2.4239 Specified database not
> > > > > > > found >
> > > > > > > > In the Configuration for the service on Sybase
> > > > > > > > Central it looks like this:
> > > > > > > >
> > > > > > > > -x "tcpip,shmem" -u -gb high -gp 4096 -p 4096
> > > > > > > > -c 64M -n sybase7
> > > > > > > > c:\ldsdata7\mydb1.db
> > > > > > > > c:\ldsdata7\mydb2.db
> > > > > > > > C:\ldsdata7\mydb3.db
> > > > > > > > c:\ldsdata7\mydb4.db
> > > > > > > > C:\ldsdata7\mydb5.db
> > > > > > > > c:\ldsdata7\vramydb1.db
> > > > > > > > c:\ldsdata7\vramydb2.db
> > > > > > > > C:\ldsdata7\vramydb3.db
> > > > > > > > c:\ldsdata7\vramydb4.db
> > > > > > > > C:\ldsdata7\vramydb5.db
> > > > > > > >
> > > > > > > > Does anyone have any ideas what I am missing?
> > > > > > > >
> > > > > > > > Thanks!
> > > > > > > > Richard
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> >
> >


Richard Posted on 2003-12-03 20:23:29.0Z
Sender: 1f8d.3fce460a.1804289383@sybase.com
From: Richard
Newsgroups: ianywhere.public.general
Subject: Re: Specified database not found using DBBackup
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3fce4641.1f9a.846930886@sybase.com>
References: <3fcb6d6e.764f.846930886@sybase.com><3fccd1ae@forums-1-dub> <3fccd70c.3ddb.846930886@sybase.com><3fcce74b$1@forums-2-dub><3fccecd0.4027.846930886@sybase.com> <3fccf04e.406d.846930886@sybase.com><3fcd85b8@forums-1-dub> <3fcdead3.4af9.846930886@sybase.com><3fcdf38c@forums-2-dub>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-1-dub3fce4641"
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 3 Dec 2003 12:23:29 -0800
X-Trace: forums-1-dub 1070483009 10.22.241.41 (3 Dec 2003 12:23:29 -0800)
X-Original-Trace: 3 Dec 2003 12:23:29 -0800, 10.22.241.41
Lines: 187
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2175
Article PK: 4380

Here are the logs

> Great. Now debug the connection.
>
> If you had
>
> dbbackup.exe -c "eng=sybase7;dbn=summitcold7;uid=dba
> ;pwd=sql" c:\temp
>
> try this instead
>
> dbbackup.exe -c
> "log=<yourchoice_of_a_filename>.log;eng=sybase7
> ;dbn=summitcold7;uid=dba;pwd= sql" c:\temp
>
> after which see whatever you called your
> <yourchoice_of_a_filename>.log has in it.
>
> Adding -z and -zr all to the server will show even more
> details of the connection
> from the server side.
>
> <Richard> wrote in message
> > news:3fcdead3.4af9.846930886@sybase.com...
> > summitcold7.db ...it doesn't matter which one I pick
> they all get the same result... >
> > > Okay that is great. Which database is Mydb5?
> > >
> > >
> > >
> > > <Richard> wrote in message
> > > > news:3fccf04e.406d.846930886@sybase.com... Here is
> > > the Logfile >
> > > >
> > > > > I was wrong about the two engines running there
> > > > > were two Services running...I deleted one of the
> > > > > services and still having the same problem...I
> > > > > will try your logging at startup..and send post in
> > > > a minute >
> > > > > > Show your command lines for both of those
> > > > > > servers. You will also want to capture the -z -o
> > > > > > output while those are starting up.
> > > > > >
> > > > > >
> > > > > > <Richard> wrote in message
> > > > > > > news:3fccd70c.3ddb.846930886@sybase.com... It
> > > > > > > is running locally on the server...There are
> > > > > > two engines running sybase8 and sybase7. Do I
> > > > > > > need to specify and How? > Thanks
> > > > > > > Richard
> > > > > > >
> > > > > > > > The "Specified database not found" error
> > > > > > > > usually occurs because you are connecting to
> > > > > > > > the wrong engine. Any other engines or
> > > > > > > > servers running on that machine? Is
> > > > > > > dbbackup being ran on a different machine than
> > > > > > > the database server? > >
> > > > > > > > <Richard> wrote in message
> > > > > > > > > news:3fcb6d6e.764f.846930886@sybase.com...
> > > > > > > > > I know this is probably an easy one but I
> > > > > > > > > can't seem to find the right combination
> > > > > > > > for this to work. I am trying to backup a
> > > > > > > > > database that is running as a Service.
> > > > > > > > > The Service is running when I am trying to
> > > > > > > > > backup the database (that is the desired
> > > > > > > > ability). Here is the command that I am
> > > > > > > > > executing > dbbackup.exe -c "eng=sybase7
> > > > > > > > > ;dbn=Mydb5;uid=dba ;pwd=sql" c:\temp
> > > > > > > > >
> > > > > > > > > This is the messages that follows:
> > > > > > > > > Adaptive Server Anywhere Backup Utility
> > > > > > > > > Version 8.0.2.4239 Specified database not
> > > > > > > > found >
> > > > > > > > > In the Configuration for the service on
> > > > > > > > > Sybase Central it looks like this:
> > > > > > > > >
> > > > > > > > > -x "tcpip,shmem" -u -gb high -gp 4096 -p
> > > > > > > > > 4096 -c 64M -n sybase7
> > > > > > > > > c:\ldsdata7\mydb1.db
> > > > > > > > > c:\ldsdata7\mydb2.db
> > > > > > > > > C:\ldsdata7\mydb3.db
> > > > > > > > > c:\ldsdata7\mydb4.db
> > > > > > > > > C:\ldsdata7\mydb5.db
> > > > > > > > > c:\ldsdata7\vramydb1.db
> > > > > > > > > c:\ldsdata7\vramydb2.db
> > > > > > > > > C:\ldsdata7\vramydb3.db
> > > > > > > > > c:\ldsdata7\vramydb4.db
> > > > > > > > > C:\ldsdata7\vramydb5.db
> > > > > > > > >
> > > > > > > > > Does anyone have any ideas what I am
> > > > > > > > missing? >
> > > > > > > > > Thanks!
> > > > > > > > > Richard
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > >
> > >
> > >
>
>


Reg Domaratzki Posted on 2003-12-04 16:12:10.0Z
From: "Reg Domaratzki" <Spam_bad_rdomarat@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <3fcb6d6e.764f.846930886@sybase.com><3fccd1ae@forums-1-dub> <3fccd70c.3ddb.846930886@sybase.com><3fcce74b$1@forums-2-dub><3fccecd0.4027.846930886@sybase.com> <3fccf04e.406d.846930886@sybase.com><3fcd85b8@forums-1-dub> <3fcdead3.4af9.846930886@sybase.com><3fcdf38c@forums-2-dub> <3fce4641.1f9a.846930886@sybase.com>
Subject: Re: Specified database not found using DBBackup
Lines: 119
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
NNTP-Posting-Host: rdomarat-pc.sybase.com
X-Original-NNTP-Posting-Host: rdomarat-pc.sybase.com
Message-ID: <3fcf5cda$1@forums-1-dub>
Date: 4 Dec 2003 08:12:10 -0800
X-Trace: forums-1-dub 1070554330 172.31.143.163 (4 Dec 2003 08:12:10 -0800)
X-Original-Trace: 4 Dec 2003 08:12:10 -0800, rdomarat-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2177
Article PK: 4383

Is MS Terminal Services involved in this at all? That would explain why we
can't connect over shared memory.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

<Richard> wrote in message news:3fce4641.1f9a.846930886@sybase.com...
> Here are the logs
>
> > Great. Now debug the connection.
> >
> > If you had
> >
> > dbbackup.exe -c "eng=sybase7;dbn=summitcold7;uid=dba
> > ;pwd=sql" c:\temp
> >
> > try this instead
> >
> > dbbackup.exe -c
> > "log=<yourchoice_of_a_filename>.log;eng=sybase7
> > ;dbn=summitcold7;uid=dba;pwd= sql" c:\temp
> >
> > after which see whatever you called your
> > <yourchoice_of_a_filename>.log has in it.
> >
> > Adding -z and -zr all to the server will show even more
> > details of the connection
> > from the server side.
> >
> > <Richard> wrote in message
> > > news:3fcdead3.4af9.846930886@sybase.com...
> > > summitcold7.db ...it doesn't matter which one I pick
> > they all get the same result... >
> > > > Okay that is great. Which database is Mydb5?
> > > >
> > > >
> > > >
> > > > <Richard> wrote in message
> > > > > news:3fccf04e.406d.846930886@sybase.com... Here is
> > > > the Logfile >
> > > > >
> > > > > > I was wrong about the two engines running there
> > > > > > were two Services running...I deleted one of the
> > > > > > services and still having the same problem...I
> > > > > > will try your logging at startup..and send post in
> > > > > a minute >
> > > > > > > Show your command lines for both of those
> > > > > > > servers. You will also want to capture the -z -o
> > > > > > > output while those are starting up.
> > > > > > >
> > > > > > >
> > > > > > > <Richard> wrote in message
> > > > > > > > news:3fccd70c.3ddb.846930886@sybase.com... It
> > > > > > > > is running locally on the server...There are
> > > > > > > two engines running sybase8 and sybase7. Do I
> > > > > > > > need to specify and How? > Thanks
> > > > > > > > Richard
> > > > > > > >
> > > > > > > > > The "Specified database not found" error
> > > > > > > > > usually occurs because you are connecting to
> > > > > > > > > the wrong engine. Any other engines or
> > > > > > > > > servers running on that machine? Is
> > > > > > > > dbbackup being ran on a different machine than
> > > > > > > > the database server? > >
> > > > > > > > > <Richard> wrote in message
> > > > > > > > > > news:3fcb6d6e.764f.846930886@sybase.com...
> > > > > > > > > > I know this is probably an easy one but I
> > > > > > > > > > can't seem to find the right combination
> > > > > > > > > for this to work. I am trying to backup a
> > > > > > > > > > database that is running as a Service.
> > > > > > > > > > The Service is running when I am trying to
> > > > > > > > > > backup the database (that is the desired
> > > > > > > > > ability). Here is the command that I am
> > > > > > > > > > executing > dbbackup.exe -c "eng=sybase7
> > > > > > > > > > ;dbn=Mydb5;uid=dba ;pwd=sql" c:\temp
> > > > > > > > > >
> > > > > > > > > > This is the messages that follows:
> > > > > > > > > > Adaptive Server Anywhere Backup Utility
> > > > > > > > > > Version 8.0.2.4239 Specified database not
> > > > > > > > > found >
> > > > > > > > > > In the Configuration for the service on
> > > > > > > > > > Sybase Central it looks like this:
> > > > > > > > > >
> > > > > > > > > > -x "tcpip,shmem" -u -gb high -gp 4096 -p
> > > > > > > > > > 4096 -c 64M -n sybase7
> > > > > > > > > > c:\ldsdata7\mydb1.db
> > > > > > > > > > c:\ldsdata7\mydb2.db
> > > > > > > > > > C:\ldsdata7\mydb3.db
> > > > > > > > > > c:\ldsdata7\mydb4.db
> > > > > > > > > > C:\ldsdata7\mydb5.db
> > > > > > > > > > c:\ldsdata7\vramydb1.db
> > > > > > > > > > c:\ldsdata7\vramydb2.db
> > > > > > > > > > C:\ldsdata7\vramydb3.db
> > > > > > > > > > c:\ldsdata7\vramydb4.db
> > > > > > > > > > C:\ldsdata7\vramydb5.db
> > > > > > > > > >
> > > > > > > > > > Does anyone have any ideas what I am
> > > > > > > > > missing? >
> > > > > > > > > > Thanks!
> > > > > > > > > > Richard
> > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > >
> > > >
> >
> >
>


Richard Posted on 2003-12-08 21:45:24.0Z
Sender: 7c9c.3fd4f0cf.1804289383@sybase.com
From: Richard
Newsgroups: ianywhere.public.general
Subject: Re: Specified database not found using DBBackup
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3fd4f0f4.7c9f.846930886@sybase.com>
References: <3fcb6d6e.764f.846930886@sybase.com><3fccd1ae@forums-1-dub> <3fccd70c.3ddb.846930886@sybase.com><3fcce74b$1@forums-2-dub><3fccecd0.4027.846930886@sybase.com> <3fccf04e.406d.846930886@sybase.com><3fcd85b8@forums-1-dub> <3fcdead3.4af9.846930886@sybase.com><3fcdf38c@forums-2-dub> <3fce4641.1f9a.846930886@sybase.com><3fcf5cda$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 8 Dec 2003 13:45:24 -0800
X-Trace: forums-1-dub 1070919924 10.22.241.41 (8 Dec 2003 13:45:24 -0800)
X-Original-Trace: 8 Dec 2003 13:45:24 -0800, 10.22.241.41
Lines: 126
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2191
Article PK: 4398

It looks like it was a MS Terminal Services issue

Thanks!

> Is MS Terminal Services involved in this at all? That
> would explain why we can't connect over shared memory.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer
> Version 8 Please reply only to the newsgroup
>
> iAnywhere Developer Community :
> http://www.ianywhere.com/developer ASA Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> <Richard> wrote in message
> > news:3fce4641.1f9a.846930886@sybase.com... Here are the
> logs >
> > > Great. Now debug the connection.
> > >
> > > If you had
> > >
> > > dbbackup.exe -c "eng=sybase7;dbn=summitcold7
> > > ;uid=dba ;pwd=sql" c:\temp
> > >
> > > try this instead
> > >
> > > dbbackup.exe -c
> > > "log=<yourchoice_of_a_filename>.log;eng=sybase7
> > > ;dbn=summitcold7;uid=dba;pwd= sql" c:\temp
> > >
> > > after which see whatever you called your
> > > <yourchoice_of_a_filename>.log has in it.
> > >
> > > Adding -z and -zr all to the server will show even
> > > more details of the connection
> > > from the server side.
> > >
> > > <Richard> wrote in message
> > > > news:3fcdead3.4af9.846930886@sybase.com...
> > > > summitcold7.db ...it doesn't matter which one I pick
> > > they all get the same result... >
> > > > > Okay that is great. Which database is Mydb5?
> > > > >
> > > > >
> > > > >
> > > > > <Richard> wrote in message
> > > > > > news:3fccf04e.406d.846930886@sybase.com... Here
> > > > > is the Logfile >
> > > > > >
> > > > > > > I was wrong about the two engines running
> > > > > > > there were two Services running...I deleted
> > > > > > > one of the services and still having the same
> > > > > > > problem...I will try your logging at
> > > > > > startup..and send post in a minute >
> > > > > > > > Show your command lines for both of those
> > > > > > > > servers. You will also want to capture the
> > > > > > > > -z -o output while those are starting up.
> > > > > > > >
> > > > > > > >
> > > > > > > > <Richard> wrote in message
> > > > > > > > > news:3fccd70c.3ddb.846930886@sybase.com...
> > > > > > > > > It is running locally on the
> > > > > > > > server...There are two engines running
> > > > > > > > > sybase8 and sybase7. Do I need to specify
> > > > > > > > > and How? > Thanks Richard
> > > > > > > > >
> > > > > > > > > > The "Specified database not found" error
> > > > > > > > > > usually occurs because you are
> > > > > > > > > > connecting to the wrong engine. Any
> > > > > > > > > > other engines or servers running on
> > > > > > > > > that machine? Is dbbackup being ran on a
> > > > > > > > > different machine than the database
> > > > > > > > > > server? > > <Richard> wrote in message
> > > > > > > > > > >
> > > > > > > > > > >
> news:3fcb6d6e.764f.846930886@sybase.com... I know this is
> > > > > > > > > > > probably an easy one but I can't seem
> > > > > > > > > > to find the right combination for this
> > > > > > > > > > > to work. I am trying to backup a
> > > > > > > > > > > database that is running as a Service.
> > > > > > > > > > > The Service is running when I am
> > > > > > > > > > trying to backup the database (that is
> > > > > > > > > > > the desired ability). Here is the
> > > > > > > > > > > command that I am executing >
> dbbackup.exe -c "eng=sybase7 ;dbn=Mydb5;uid=dba ;pwd=sql"
> > > > > > > > > > c:\temp >
> > > > > > > > > > > This is the messages that follows:
> > > > > > > > > > > Adaptive Server Anywhere Backup
> > > > > > > > > > > Utility Version 8.0.2.4239 Specified
> > > > > > > > > > database not found >
> > > > > > > > > > > In the Configuration for the service
> > > > > > > > > > > on Sybase Central it looks like this:
> > > > > > > > > > >
> > > > > > > > > > > -x "tcpip,shmem" -u -gb high -gp 4096
> > > > > > > > > > > -p 4096 -c 64M -n sybase7
> > > > > > > > > > > c:\ldsdata7\mydb1.db
> > > > > > > > > > > c:\ldsdata7\mydb2.db
> > > > > > > > > > > C:\ldsdata7\mydb3.db
> > > > > > > > > > > c:\ldsdata7\mydb4.db
> > > > > > > > > > > C:\ldsdata7\mydb5.db
> > > > > > > > > > > c:\ldsdata7\vramydb1.db
> > > > > > > > > > > c:\ldsdata7\vramydb2.db
> > > > > > > > > > > C:\ldsdata7\vramydb3.db
> > > > > > > > > > > c:\ldsdata7\vramydb4.db
> > > > > > > > > > > C:\ldsdata7\vramydb5.db
> > > > > > > > > > >
> > > > > > > > > > > Does anyone have any ideas what I am
> > > > > > > > > > missing? >
> > > > > > > > > > > Thanks!
> > > > > > > > > > > Richard
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > >
> > > > >
> > >
> > >
> >
>
>


Nick Elson Posted on 2003-12-04 05:28:47.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <3fcb6d6e.764f.846930886@sybase.com><3fccd1ae@forums-1-dub> <3fccd70c.3ddb.846930886@sybase.com><3fcce74b$1@forums-2-dub><3fccecd0.4027.846930886@sybase.com> <3fccf04e.406d.846930886@sybase.com><3fcd85b8@forums-1-dub> <3fcdead3.4af9.846930886@sybase.com><3fcdf38c@forums-2-dub> <3fce4641.1f9a.846930886@sybase.com>
Subject: Re: Specified database not found using DBBackup
Lines: 150
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: cpe0050bf17594c-cm014370028576.cpe.net.cable.rogers.com
Message-ID: <3fcec7a4@forums-2-dub>
X-Original-Trace: 3 Dec 2003 21:35:32 -0800, cpe0050bf17594c-cm014370028576.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Dec 2003 21:17:39 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Dec 2003 21:28:47 -0800
X-Trace: forums-1-dub 1070515727 10.22.108.75 (3 Dec 2003 21:28:47 -0800)
X-Original-Trace: 3 Dec 2003 21:28:47 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2176
Article PK: 4386

Well that explains some parts of the problem. [albeit somewhat odd
behaviour]

First off, it's not finding that server at all over shared memory. The
giveaway
is this

13:58:59 No server found, attempting to start a personal server...

Secondly it then goes on to try and start a local engine (aka personal
server)
with the same name (even though there is no DBF specified) and then attempts
to connect to that. Since you are not finding the named DBN, this is why
you are getting the error

13:59:00 Connecting to database unsuccessful because database is not
running

Since the server started shared memory successfully can I assume that
the machine dbbackup is running on (SUPPORT2000) is different than
the one the server is running (the hostname for 209.242.115.131).

A quick simple solution for this could just be adding

CommLinks=tcpip;

to your dbbackup connection string. If these two machines are on
different subnets you may need to make that

CommLinks=tcpip(host=209.242.115.131)

[which if very common].


That should at least get you going.


I guess you could also try deleting the asasrv.ini file first (as a quick
test).
It may be a case of permissions for the account running dbbackup.

Let us know if this works.

<Richard> wrote in message news:3fce4641.1f9a.846930886@sybase.com...
> Here are the logs
>
> > Great. Now debug the connection.
> >
> > If you had
> >
> > dbbackup.exe -c "eng=sybase7;dbn=summitcold7;uid=dba
> > ;pwd=sql" c:\temp
> >
> > try this instead
> >
> > dbbackup.exe -c
> > "log=<yourchoice_of_a_filename>.log;eng=sybase7
> > ;dbn=summitcold7;uid=dba;pwd= sql" c:\temp
> >
> > after which see whatever you called your
> > <yourchoice_of_a_filename>.log has in it.
> >
> > Adding -z and -zr all to the server will show even more
> > details of the connection
> > from the server side.
> >
> > <Richard> wrote in message
> > > news:3fcdead3.4af9.846930886@sybase.com...
> > > summitcold7.db ...it doesn't matter which one I pick
> > they all get the same result... >
> > > > Okay that is great. Which database is Mydb5?
> > > >
> > > >
> > > >
> > > > <Richard> wrote in message
> > > > > news:3fccf04e.406d.846930886@sybase.com... Here is
> > > > the Logfile >
> > > > >
> > > > > > I was wrong about the two engines running there
> > > > > > were two Services running...I deleted one of the
> > > > > > services and still having the same problem...I
> > > > > > will try your logging at startup..and send post in
> > > > > a minute >
> > > > > > > Show your command lines for both of those
> > > > > > > servers. You will also want to capture the -z -o
> > > > > > > output while those are starting up.
> > > > > > >
> > > > > > >
> > > > > > > <Richard> wrote in message
> > > > > > > > news:3fccd70c.3ddb.846930886@sybase.com... It
> > > > > > > > is running locally on the server...There are
> > > > > > > two engines running sybase8 and sybase7. Do I
> > > > > > > > need to specify and How? > Thanks
> > > > > > > > Richard
> > > > > > > >
> > > > > > > > > The "Specified database not found" error
> > > > > > > > > usually occurs because you are connecting to
> > > > > > > > > the wrong engine. Any other engines or
> > > > > > > > > servers running on that machine? Is
> > > > > > > > dbbackup being ran on a different machine than
> > > > > > > > the database server? > >
> > > > > > > > > <Richard> wrote in message
> > > > > > > > > > news:3fcb6d6e.764f.846930886@sybase.com...
> > > > > > > > > > I know this is probably an easy one but I
> > > > > > > > > > can't seem to find the right combination
> > > > > > > > > for this to work. I am trying to backup a
> > > > > > > > > > database that is running as a Service.
> > > > > > > > > > The Service is running when I am trying to
> > > > > > > > > > backup the database (that is the desired
> > > > > > > > > ability). Here is the command that I am
> > > > > > > > > > executing > dbbackup.exe -c "eng=sybase7
> > > > > > > > > > ;dbn=Mydb5;uid=dba ;pwd=sql" c:\temp
> > > > > > > > > >
> > > > > > > > > > This is the messages that follows:
> > > > > > > > > > Adaptive Server Anywhere Backup Utility
> > > > > > > > > > Version 8.0.2.4239 Specified database not
> > > > > > > > > found >
> > > > > > > > > > In the Configuration for the service on
> > > > > > > > > > Sybase Central it looks like this:
> > > > > > > > > >
> > > > > > > > > > -x "tcpip,shmem" -u -gb high -gp 4096 -p
> > > > > > > > > > 4096 -c 64M -n sybase7
> > > > > > > > > > c:\ldsdata7\mydb1.db
> > > > > > > > > > c:\ldsdata7\mydb2.db
> > > > > > > > > > C:\ldsdata7\mydb3.db
> > > > > > > > > > c:\ldsdata7\mydb4.db
> > > > > > > > > > C:\ldsdata7\mydb5.db
> > > > > > > > > > c:\ldsdata7\vramydb1.db
> > > > > > > > > > c:\ldsdata7\vramydb2.db
> > > > > > > > > > C:\ldsdata7\vramydb3.db
> > > > > > > > > > c:\ldsdata7\vramydb4.db
> > > > > > > > > > C:\ldsdata7\vramydb5.db
> > > > > > > > > >
> > > > > > > > > > Does anyone have any ideas what I am
> > > > > > > > > missing? >
> > > > > > > > > > Thanks!
> > > > > > > > > > Richard
> > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > >
> > > >
> >
> >
>