SQL Anywhere database

Author

Live Backup

David

2005-12-28, 11:23 am

Hi,
We are using the ASA 9.0.1.1899. We are using the Live
backup option for the backing up the database. We are taking
the backup in the removable backup disk with the memory size
512MB. Some time the backup files reaches more than this
size. we are using the synchrnization process also. on sync
we are renaming the log files on checking the size.
Please provide the solution for this. What can be done on
this case when it reaches more than the available space.
Regards,
David

Rob Waywell

2005-12-28, 11:23 am

What would you like to do when you need more space to do a full backup than
you have available?

You have 2 basic options:

1) Don't do a full backup, choose to backup either the db or log file.
2) Provide more space for the backup.

What is your exact BACKUP statement or dbbackup command line?
Do you do a full backup (db & log) each time, or do you do periodic full
backups and incremental log backups?
Do you truncate the log file each time you do a backup?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

<David> wrote in message news:43b2b441.186d.1681692777@sybase.com...
> Hi,
> We are using the ASA 9.0.1.1899. We are using the Live
> backup option for the backing up the database. We are taking
> the backup in the removable backup disk with the memory size
> 512MB. Some time the backup files reaches more than this
> size. we are using the synchrnization process also. on sync
> we are renaming the log files on checking the size.
> Please provide the solution for this. What can be done on
> this case when it reaches more than the available space.
> Regards,
> David

David

2005-12-29, 3:23 am

Hi,
Thanks for your response.
Q : What would you like to do when you need more space to do
a
full backup than you have available?
Ans : I need to truncate the log file. Or you could suggest
ny more possibilities on this case.

You have 2 basic options:

1) Don't do a full backup, choose to backup either the db
or log file.
2) Provide more space for the backup.

If we go for the Log file backup alone, how it can be
retrived and updated to the database. which one is the best
DB backup or Log file backup.
We can't increase our backup device memory size furthur.

What is your exact BACKUP statement or dbbackup command
line? Do you do a full backup (db & log) each time, or do
you do periodic full backups and incremental log backups?
Do you truncate the log file each time you do a backup?
First on launch of our application we will start the full
backup once like the below statement
dbbackup -c "connstring" -y Destination Folder

after the above process completion we will initiate the live
backup as below
dbbackup -c "connstrig" -y -l source log file path
Destination folder

We are truncating our log files on synchronization process
using -x option and we enabled DELETE_OLD_LOG option also.

Please provide some better way to implement this logic.
Our main constraint is we need to do the backup with out
increasing the drive size ( 512MB ) along with
synchronization process.
Shall we stop the backup process during synchronization if
yes how to stop the Live backup process.
Thanks in Advance.
Regards,
Baskar.S

Rob Waywell

2005-12-29, 11:23 am

How many backups are going on the single 512mb device?
For example, after you do the full backup, do you then point the live
backup to the same device or do you switch devices (USB keys or something
else?) before starting the live backup?

Are you saying that the sum of all log files (current log + old log files)
required for synchronization is sometimes exceeding 512MB?
If so, then you have a business requirement to either:
1) Synchronize/Replicate more frequently.
2) Increase the available storage space.

Or are you getting multiple copies of the full db file plus all the log
files and the combination of db files plus log files is exceeding 512MB?

Perhaps a good approach would be to show the directory structure and
file list from a full 512MB device to give us a better idea of all the files
on the device.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

<David> wrote in message news:43b3792b.1bcc.1681692777@sybase.com...
> Hi,
> Thanks for your response.
> Q : What would you like to do when you need more space to do
> a
> full backup than you have available?
> Ans : I need to truncate the log file. Or you could suggest
> ny more possibilities on this case.
>
> You have 2 basic options:
>
> 1) Don't do a full backup, choose to backup either the db
> or log file.
> 2) Provide more space for the backup.
>
> If we go for the Log file backup alone, how it can be
> retrived and updated to the database. which one is the best
> DB backup or Log file backup.
> We can't increase our backup device memory size furthur.
>
> What is your exact BACKUP statement or dbbackup command
> line? Do you do a full backup (db & log) each time, or do
> you do periodic full backups and incremental log backups?
> Do you truncate the log file each time you do a backup?
> First on launch of our application we will start the full
> backup once like the below statement
> dbbackup -c "connstring" -y Destination Folder
>
> after the above process completion we will initiate the live
> backup as below
> dbbackup -c "connstrig" -y -l source log file path
> Destination folder
>
> We are truncating our log files on synchronization process
> using -x option and we enabled DELETE_OLD_LOG option also.
>
> Please provide some better way to implement this logic.
> Our main constraint is we need to do the backup with out
> increasing the drive size ( 512MB ) along with
> synchronization process.
> Shall we stop the backup process during synchronization if
> yes how to stop the Live backup process.
> Thanks in Advance.
> Regards,
> Baskar.S

David

2005-12-30, 9:23 am

Hi,
Thanks for the response.

How many backups are going on the single 512mb device?
Only one backup is running ( There will be one db file and
log file )

For example, after you do the full backup, do you then
point the live backup to the same device or do you switch
devices (USB keys or something else?) before starting the
live backup?

Yes. I am pointing to the same device for the live also. we
will use the same device for the backup ( Flash card).

Are you saying that the sum of all log files (current log
+ old log files) required for synchronization is
sometimes exceeding 512MB?
No. That current database folder will reside in the Hard
drive, so no need to worry about the memory size. we have
40gb hdd.
We are worrying about the Flash card device with 512 MB.
In that only DB file and live backup log file will be
stored.

is there any possiblities of restricting the log file in the
Backup folder?

If so, then you have a business requirement to
either:
1) Synchronize/Replicate more frequently.
2) Increase the available storage space.

Or are you getting multiple copies of the full db file
plus all the log files and the combination of db files
plus log files is exceeding 512MB?

We are not getting the multiple copies of the full db file
and log file.

Regards,
David

> Perhaps a good approach would be to show the
> directory structure and file list from a full 512MB
> device to give us a better idea of all the files on the
> device.

Our current database folder :
C:\Program Files\AppName\Databa
se
Hdd 40 GB

Backup Folder :
D:\Backup
( Flash card with 512MB)
> option also. >
>
>

Sponsored Links