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.

backing up database

4 posts in General Discussion Last posting was on 2009-11-02 18:12:46.0Z
Nader Posted on 2009-10-29 23:15:36.0Z
Sender: 6e6a.4aea215b.1804289383@sybase.com
From: Nader
Newsgroups: ianywhere.public.general
Subject: backing up database
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4aea2218.6e86.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 29 Oct 2009 15:15:36 -0800
X-Trace: forums-1-dub 1256858136 10.22.241.41 (29 Oct 2009 15:15:36 -0800)
X-Original-Trace: 29 Oct 2009 15:15:36 -0800, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7784
Article PK: 6825

I'm trying to back up database using ....
dbbackup -c "eng=dbtrans10;dbn=dbtrans10;uid=DBA;pwd=SQL"
-o c:\backup

what am i doing wrong?
(I'm using sybase sqlanyware11)


Breck Carter [TeamSybase] Posted on 2009-10-30 12:23:08.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Re: backing up database
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <4jmle5puoene58gn3pf4olmjjpfqcu3auv@4ax.com>
References: <4aea2218.6e86.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 30 Oct 2009 04:23:08 -0800
X-Trace: forums-1-dub 1256905388 10.22.241.152 (30 Oct 2009 04:23:08 -0800)
X-Original-Trace: 30 Oct 2009 04:23:08 -0800, vip152.sybase.com
Lines: 22
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7786
Article PK: 6820

As Chris said, specify a text file after the -o.

... or leave out the -o:

dbbackup -c "eng=dbtrans10;dbn=dbtrans10;uid=DBA;pwd=SQL" c:\backup

Breck

On 29 Oct 2009 15:15:36 -0800, Nader wrote:

>I'm trying to back up database using ....
> dbbackup -c "eng=dbtrans10;dbn=dbtrans10;uid=DBA;pwd=SQL"
>-o c:\backup
>
>what am i doing wrong?
>(I'm using sybase sqlanyware11)

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com


Chris Keating (Sybase iAnywhere) Posted on 2009-10-30 00:02:48.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_nospam@sybase.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: backing up database
References: <4aea2218.6e86.1681692777@sybase.com>
In-Reply-To: <4aea2218.6e86.1681692777@sybase.com>
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: <4aea2d28$1@forums-1-dub>
Date: 29 Oct 2009 16:02:48 -0800
X-Trace: forums-1-dub 1256860968 10.22.241.152 (29 Oct 2009 16:02:48 -0800)
X-Original-Trace: 29 Oct 2009 16:02:48 -0800, vip152.sybase.com
Lines: 16
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7785
Article PK: 6821

You are missing a file name for the -o option

> dbbackup -c "eng=dbtrans10;dbn=dbtrans10;uid=DBA;pwd=SQL"

> -o <file_spec> c:\backup

If this is not the problem, please outline the error or message that you
get with the backup statement that you are using.


Nader wrote:
> I'm trying to back up database using ....
> dbbackup -c "eng=dbtrans10;dbn=dbtrans10;uid=DBA;pwd=SQL"
> -o c:\backup
>
> what am i doing wrong?
> (I'm using sybase sqlanyware11)


David Fishburn [Sybase iAnywhere] Posted on 2009-11-02 18:12:46.0Z
Newsgroups: ianywhere.public.general
Subject: Re: backing up database
From: "David Fishburn [Sybase iAnywhere]" <fishburn_spam_off@ianywhere.com>
References: <4aea2218.6e86.1681692777@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns9CB7866898189fishburnsybasecom@10.22.241.106>
User-Agent: Xnews/2005.10.18
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 2 Nov 2009 10:12:46 -0800
X-Trace: forums-1-dub 1257185566 10.22.241.152 (2 Nov 2009 10:12:46 -0800)
X-Original-Trace: 2 Nov 2009 10:12:46 -0800, vip152.sybase.com
Lines: 33
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7791
Article PK: 6829

Nader wrote in news:4aea2218.6e86.1681692777@sybase.com
of ianywhere.public.general:

N> I'm trying to back up database using ....
N> dbbackup -c "eng=dbtrans10;dbn=dbtrans10;uid=DBA;pwd=SQL"
N> -o c:\backup

You have your answer, but please provide the error messages you are
seeing, it helps identify your issues much faster.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng11 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList

Documentation
http://dcx.sybase.com/