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.

DBTools -> DBBackup question

3 posts in General Discussion Last posting was on 2005-11-14 15:31:53.0Z
Douglas Troy Posted on 2005-11-11 21:09:38.0Z
Sender: 593c.4374ff4d.1804289383@sybase.com
From: Douglas Troy
Newsgroups: ianywhere.public.general
Subject: DBTools -> DBBackup question
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <437504c0.595e.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 11 Nov 2005 12:53:20 -0800, 10.22.241.42
Lines: 24
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 11 Nov 2005 12:59:29 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 11 Nov 2005 13:09:38 -0800
X-Trace: forums-1-dub 1131743378 10.22.108.75 (11 Nov 2005 13:09:38 -0800)
X-Original-Trace: 11 Nov 2005 13:09:38 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4941
Article PK: 8610

Using ASA 9.0.2.2542

We're implementing a small C++ wrapper around DBTools to run
a DB back-up prior to a system update. From this, I have two
questions:

1. In the a_backup_db struct, what exactly does the
server_backup field do in the context of the back-up itself.
Just execute it server side and then copy down the database
file backed up?

2. Assuming that a client machine executes our little
routine, is there a means by which we could cause the
database to back-up on the server and stay there, to prevent
network overhead in the DB from being copied down to the
client machine? (was hoping the server_backup switch would
come into play here).

Obviously my goal is to allow the back-up to execute
client-side, but attempt to keep the back-up copy of the DB
on the server, while keeping the network traffic to a minmum
.. I'm not asking much ... right? ;)

TIA.


Greg Fenton Posted on 2005-11-12 13:29:49.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: DBTools -> DBBackup question
References: <437504c0.595e.1681692777@sybase.com>
In-Reply-To: <437504c0.595e.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: dialup-80-254-64-186.dclient.monzoon.net
Message-ID: <4375ebae@forums-2-dub>
X-Original-Trace: 12 Nov 2005 05:18:38 -0800, dialup-80-254-64-186.dclient.monzoon.net
Lines: 38
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 12 Nov 2005 05:23:37 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 12 Nov 2005 05:29:49 -0800
X-Trace: forums-1-dub 1131802189 10.22.108.75 (12 Nov 2005 05:29:49 -0800)
X-Original-Trace: 12 Nov 2005 05:29:49 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4943
Article PK: 8609


Douglas Troy wrote:
>
> Obviously my goal is to allow the back-up to execute
> client-side, but attempt to keep the back-up copy of the DB
> on the server, while keeping the network traffic to a minmum
> .. I'm not asking much ... right? ;)

What you are looking for is doable, but not via the dbbackup utility
(which is what the DBBackup() function essentially is).

In the SQLAnywhere 9.x online docs:

ASA Database Administration Guide
Backup and Data Recovery
Designing backup procedures
- Types of backup

"Server-side backup and client-side backup
You can execute an online backup from a client machine using the
Backup utility. To execute a server side backup, you execute the
BACKUP statement; the database server then carries out the backup."

So I think you might look to having your C++ client connect to the
server and issue the BACKUP DATABASE statement (a SQL command).

I'm going to post a doc enhancement request for the dbbackup utility,
DBBackup() function and BACKUP DATABASE statement pages to link to the
Types Of Backup page above.

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/


Reg Domaratzki (iAnywhere Solutions) Posted on 2005-11-14 15:31:53.0Z
From: "Reg Domaratzki \(iAnywhere Solutions\)" <FirstName.LastName@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <437504c0.595e.1681692777@sybase.com>
Subject: Re: DBTools -> DBBackup question
Lines: 44
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
NNTP-Posting-Host: rdomarat-xp.sybase.com
X-Original-NNTP-Posting-Host: rdomarat-xp.sybase.com
Message-ID: <4378ade9$1@forums-1-dub>
Date: 14 Nov 2005 07:31:53 -0800
X-Trace: forums-1-dub 1131982313 10.25.99.188 (14 Nov 2005 07:31:53 -0800)
X-Original-Trace: 14 Nov 2005 07:31:53 -0800, rdomarat-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4946
Article PK: 8611

As Greg mentioned, you should be doing your backups using the BACKUP
DATABASE command, and not the client-side tools ( dbbackup, dbtools API ).
The BACKUP DATABASE is executed by the server, so I think it's exactly what
you're looking for.

--
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
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

<Douglas Troy> wrote in message news:437504c0.595e.1681692777@sybase.com...
> Using ASA 9.0.2.2542
>
> We're implementing a small C++ wrapper around DBTools to run
> a DB back-up prior to a system update. From this, I have two
> questions:
>
> 1. In the a_backup_db struct, what exactly does the
> server_backup field do in the context of the back-up itself.
> Just execute it server side and then copy down the database
> file backed up?
>
> 2. Assuming that a client machine executes our little
> routine, is there a means by which we could cause the
> database to back-up on the server and stay there, to prevent
> network overhead in the DB from being copied down to the
> client machine? (was hoping the server_backup switch would
> come into play here).
>
> Obviously my goal is to allow the back-up to execute
> client-side, but attempt to keep the back-up copy of the DB
> on the server, while keeping the network traffic to a minmum
> .. I'm not asking much ... right? ;)
>
> TIA.