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.

Sybase ASA 8 and DBBACKUP.EXE

6 posts in General Discussion Last posting was on 2003-12-03 15:52:26.0Z
Craig M Posted on 2003-11-19 15:20:51.0Z
From: "Craig M" <craig.mccory@fiserv.com>
Newsgroups: ianywhere.public.general
Subject: Sybase ASA 8 and DBBACKUP.EXE
Lines: 11
Organization: Fiserv
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: 12.108.42.126
X-Original-NNTP-Posting-Host: 12.108.42.126
Message-ID: <3fbb8a53$1@forums-1-dub>
Date: 19 Nov 2003 07:20:51 -0800
X-Trace: forums-1-dub 1069255251 12.108.42.126 (19 Nov 2003 07:20:51 -0800)
X-Original-Trace: 19 Nov 2003 07:20:51 -0800, 12.108.42.126
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2103
Article PK: 4320

Hello, I need to backup my database using the Sybase ASA 8 (v 8.0.1.3041)
DOS dbbackup.exe command. I can successfully use Sybase Central to manually
backup the database with the Create Backup Images wizard but not with the
dbbackup.exe DOS command in a command prompt or batch file. Why does the
Windows base utilities work but not the DOS base commands? (Connect string
is dbbackup -c uid=xxxx;pwd=xxxx;eng=xxxx;dbn=xxxx -d -y and path to
backup folder).

Craig M


Greg Fenton Posted on 2003-11-19 16:55:56.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Sybase ASA 8 and DBBACKUP.EXE
References: <3fbb8a53$1@forums-1-dub>
In-Reply-To: <3fbb8a53$1@forums-1-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gfenton-xp.sybase.com
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <3fbba09c$1@forums-1-dub>
Date: 19 Nov 2003 08:55:56 -0800
X-Trace: forums-1-dub 1069260956 172.31.141.199 (19 Nov 2003 08:55:56 -0800)
X-Original-Trace: 19 Nov 2003 08:55:56 -0800, gfenton-xp.sybase.com
Lines: 22
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2106
Article PK: 4323


Craig M wrote:
> Why does the
> Windows base utilities work but not the DOS base commands? (Connect string
> is dbbackup -c uid=xxxx;pwd=xxxx;eng=xxxx;dbn=xxxx -d -y and path to
> backup folder).
>

What specifically do you mean by "does not work"?
Are you seeing error messages? If so, what are they?

For me, the command-line utilities work just fine. I rarely use the GUI
tools because I'm a command-line junky.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Craig M Posted on 2003-12-03 13:06:38.0Z
From: "Craig M" <craig.mccory@fiserv.com>
Newsgroups: ianywhere.public.general
References: <3fbb8a53$1@forums-1-dub> <3fbba09c$1@forums-1-dub>
Subject: Re: Sybase ASA 8 and DBBACKUP.EXE
Lines: 34
Organization: Fiserv
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: 12.108.42.126
X-Original-NNTP-Posting-Host: 12.108.42.126
Message-ID: <3fcddfde@forums-1-dub>
Date: 3 Dec 2003 05:06:38 -0800
X-Trace: forums-1-dub 1070456798 12.108.42.126 (3 Dec 2003 05:06:38 -0800)
X-Original-Trace: 3 Dec 2003 05:06:38 -0800, 12.108.42.126
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2170
Article PK: 4375

The error received "specified database
not found'

Craig M

"Greg Fenton" <greg.fenton_NOSPAM_@ianywhere.com> wrote in message
news:3fbba09c$1@forums-1-dub...
> Craig M wrote:
> > Why does the
> > Windows base utilities work but not the DOS base commands? (Connect
string
> > is dbbackup -c uid=xxxx;pwd=xxxx;eng=xxxx;dbn=xxxx -d -y and path to
> > backup folder).
> >
>
> What specifically do you mean by "does not work"?
> Are you seeing error messages? If so, what are they?
>
> For me, the command-line utilities work just fine. I rarely use the GUI
> tools because I'm a command-line junky.
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
>


Stephen Rice Posted on 2003-12-03 14:54:13.0Z
Newsgroups: ianywhere.public.general
Subject: Re: Sybase ASA 8 and DBBACKUP.EXE
From: Stephen Rice <srice_nospam@ianywhere.com>
References: <3fbb8a53$1@forums-1-dub> <3fbba09c$1@forums-1-dub> <3fcddfde@forums-1-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns944662E0BACsricenospamianywhere@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: 3 Dec 2003 06:54:13 -0800
X-Trace: forums-1-dub 1070463253 172.31.141.106 (3 Dec 2003 06:54:13 -0800)
X-Original-Trace: 3 Dec 2003 06:54:13 -0800, srice-pc.sybase.com
Lines: 23
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2173
Article PK: 4378


"Craig M" <craig.mccory@fiserv.com> wrote in news:3fcddfde@forums-1-dub:

> The error received "specified database
> not found'
>
> Craig M
>
>

What is your server start line and exact dbbackup command line. This error
is almost always caused by a typo

/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


Greg Fenton Posted on 2003-12-03 15:52:26.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4; MultiZilla v1.4.0.4A) Gecko/20030624
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Sybase ASA 8 and DBBACKUP.EXE
References: <3fbb8a53$1@forums-1-dub> <3fbba09c$1@forums-1-dub> <3fcddfde@forums-1-dub>
In-Reply-To: <3fcddfde@forums-1-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gfenton-xp.sybase.com
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <3fce06ba$1@forums-1-dub>
Date: 3 Dec 2003 07:52:26 -0800
X-Trace: forums-1-dub 1070466746 172.31.141.199 (3 Dec 2003 07:52:26 -0800)
X-Original-Trace: 3 Dec 2003 07:52:26 -0800, gfenton-xp.sybase.com
Lines: 27
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2174
Article PK: 4379


Craig M wrote:
> The error received "specified database
> not found'
>

So the problem is one of connecting to the database. This is typically
caused by having an error in your connection string and/or your ODBC DSN
(if applicable).

You might try adding the LOG option to your connection string and
looking at the output after a failed attempt to connect:

dbbackup -c "LOG=c:\mylog.txt;_rest_of_your_connection_string" ...

If you'd like help interpreting the logged output in c:\mylog.txt, post
its contents.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Matthew Chestnut Posted on 2003-11-19 20:51:07.0Z
From: Matthew Chestnut <matthew_chestnut at hotmail dot com>
Newsgroups: ianywhere.public.general
Subject: Re: Sybase ASA 8 and DBBACKUP.EXE
Message-ID: <1alnrvo487dbc00fu0pucp3p2f1kmq6aog@4ax.com>
References: <3fbb8a53$1@forums-1-dub>
X-Newsreader: Forte Free Agent 1.93/32.576 English (American)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 65.212.74.40
X-Original-NNTP-Posting-Host: 65.212.74.40
Date: 19 Nov 2003 12:51:07 -0800
X-Trace: forums-1-dub 1069275067 65.212.74.40 (19 Nov 2003 12:51:07 -0800)
X-Original-Trace: 19 Nov 2003 12:51:07 -0800, 65.212.74.40
Lines: 19
X-Authenticated-User: pbtenbeta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2109
Article PK: 4324

Perhaps you need to surround the connection parameters with quotes.
For example:

dbbackup -y -c "uid=xxx;pwd=xxx;eng=xxx;dbn=xxx" DestinationDirectory

On 19 Nov 2003 07:20:51 -0800, "Craig M" <craig.mccory@fiserv.com>

wrote:

>Hello, I need to backup my database using the Sybase ASA 8 (v 8.0.1.3041)
>DOS dbbackup.exe command. I can successfully use Sybase Central to manually
>backup the database with the Create Backup Images wizard but not with the
>dbbackup.exe DOS command in a command prompt or batch file. Why does the
>Windows base utilities work but not the DOS base commands? (Connect string
>is dbbackup -c uid=xxxx;pwd=xxxx;eng=xxxx;dbn=xxxx -d -y and path to
>backup folder).
>
>Craig M
>