Backup Central

Hi Everyone!


Is there any free open source/less cost software available to make sybase backups like symantec netbackup. which can make online backups as scheduled. Sybase is installed on Solaris 10.

If you know any also please mention if it has incremental backup support.

Thanks a lot for reading.

Regards
usman

None that I'm aware of. You can dump the database to disk, of course, then get it from there. But I don't know of any opensource systems that will do it automatically other than through scripting.

Hi cpreston,

I really appreciate your quick responce and valuable reply.
Can you mention names of commercial solutions or link to any scripts like i heared that some sybase backup script is available on this site.

Thanks and Regards
usman

Pretty much any commercial product in this directory can handle Sybase:
http://www.backupcentral.com/components/com_mambowiki/index.php/General_Back
up_Software

I don't have a Sybase backup script.

-----Original Message-----
From: backups-bounces < at > backupcentral.com
[mailto:backups-bounces < at > backupcentral.com] On Behalf Of usmanbsd
Sent: Sunday, May 10, 2009 10:50 PM
To: backups < at > backupcentral.com
Subject: [Backups] Sybase Backup Solution


Hi cpreston,

I really appreciate your quick responce and valuable reply.
Can you mention names of commercial solutions or link to any scripts like i
heared that some sybase backup script is available on this site.

Thanks and Regards
usman

+----------------------------------------------------------------------
|This was sent by usmanbsd < at > yahoo.com via Backup Central.
|Forward SPAM to abuse < at > backupcentral.com.
+----------------------------------------------------------------------



_______________________________________________
If you'd like to join the discussion, go to http://www.backupcentral.com and
get
a user id. Then subscribe to one or more of our mailing lists or follow the
discussions in one of our forums (http://www.backupcentral.com/phpBB2).


_______________________________________________
If you'd like to join the discussion, go to http://www.backupcentral.com and get
a user id. Then subscribe to one or more of our mailing lists or follow the
discussions in one of our forums (http://www.backupcentral.com/phpBB2).

Hi cpreston,

I really appreciate your quick responce and valuable reply.
Can you mention names of commercial solutions or link to any scripts like i heared that some sybase backup script is available on this site.

Thanks and Regards
usman

The general form of Sybase's dump statement (to disk, using compression) is:

dump database FOO
to "compress::5::/export/file"
stripe on "compress::5::/export/file2"
[additional 'stripe on' lines here]
go

Loading a database is the same (load database FOO from . . .), except its just "compress::/export/file" when dealing with a compressed file.

We use compress level 5 as its the best compression for the speed - about 5:1, which is actually nice since uncompressed dump files to tape drives were no better than 2.5:1 (using LTO-2).

--TSK

Tim Kimball
http://sungak.net