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.

redirect dbbackup output

2 posts in General Discussion Last posting was on 2011-03-10 17:38:23.0Z
RDMS Nederland (Harm Reuling) Posted on 2011-03-09 15:39:05.0Z
From: "RDMS Nederland (Harm Reuling)" <h.reuling@rdms.nl>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.14) Gecko/20110221 Lightning/1.0b2 Thunderbird/3.1.8
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: redirect dbbackup output
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d779f19$1@forums-1-dub>
Date: 9 Mar 2011 07:39:05 -0800
X-Trace: forums-1-dub 1299685145 10.22.241.152 (9 Mar 2011 07:39:05 -0800)
X-Original-Trace: 9 Mar 2011 07:39:05 -0800, vip152.sybase.com
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8126
Article PK: 7149

Hi,

I have a space issue while backing up large databases. Is it possible to
redirect/pipe the dbbackup output to compress data (like gzip / zip)?

Thanks in advance,
Harm Reuling
RDMS Nederland


Jeff Albion [Sybase iAnywhere] Posted on 2011-03-10 17:38:23.0Z
From: "Jeff Albion [Sybase iAnywhere]" <firstname.lastname@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.15) Gecko/20110303 Lightning/1.0b2 Thunderbird/3.1.9
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: redirect dbbackup output
References: <4d779f19$1@forums-1-dub>
In-Reply-To: <4d779f19$1@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: <4d790c8f$1@forums-1-dub>
Date: 10 Mar 2011 09:38:23 -0800
X-Trace: forums-1-dub 1299778703 10.22.241.152 (10 Mar 2011 09:38:23 -0800)
X-Original-Trace: 10 Mar 2011 09:38:23 -0800, vip152.sybase.com
Lines: 22
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8127
Article PK: 7146

Hello Harm,

On 09/03/2011 10:39 AM, RDMS Nederland (Harm Reuling) wrote:
> I have a space issue while backing up large databases. Is it possible to
> redirect/pipe the dbbackup output to compress data (like gzip / zip)?

No, this isn't possible while the backup operation is taking place.
However, you could potentially zip the files for archiving after the
backup operation has completed. There may also be an OS-level feature
for file system compression, but this would vary by OS.

Regards,

--
Jeff Albion, Sybase iAnywhere, an SAP Company

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/