As a Market leader Netbackup provides a heterogeneous backup solution for large-scale data centers.
This includes Sybase database support, which provides a centralized backup and restore solution for all your Sybase database servers using the same storage used for all your other backups optimizing your backup storage usage.
Also, it provides a transparent "backup and restore" service for the Sybase database admin using their own tools: Isql or DBIsql.
There are many different ways to perform the backup of SAP Adaptive Server Enterprise on the market today.
If you want the freedom to see your backups using normal OS commands, such as "dir" or "ls" commands, and in the same way know that everything stored on this path is secured, and has retention policies, space-efficient, and fast than Spictera SPFS can be a good choice, where the DBA can use the preferred methods to backup their databases.
E.g.
# mount -t spfs /backup
SQL> DUMP DATABASE mydb TO '/backup/my.bkp'
SQL> GO
All file system operations that go via this mountpoint (/backup in the above example) will be translated to IBM Spectrum Protect Client API calls, so nothing is cached locally
Retention and versioning are managed via the IBM Spectrum Protect server, where one can control how many versions and/or retention of the backups, including how many copies, etc.
SPFS has also the ability to use encryptions using their own private encryption keys if needed.
SPFS has built-in data reductions using compression and de-duplication if needed.
SPFS has automatical failover and fallback for those who have that as a demand if replication services have been configured on the IBM Spectrum Protect server, and this data is configured to be replicated.
This solution is agentless and does not require any specific education to learn how an agent works (which literally sometimes hides the techniques inside the agent)
After all, it can't be more simple to use? as everyone probably already knows how to use a filesystem, right?
Commvault and Netbackup are at the top of the list: comprehensive and best features, full, inc, BMR, VM, end-user, any type of schedule even replication.
Commvault's protection provides complete protection for the Sybase server, which consists of system and user databases in different environments.
Regardless of what software I use for backups, I prefer to do database backups from within the database itself using a script as an extra measure of security.
Sybase ASE has built-in support with IBM Spectrum Protect.
Another way is to use SPFS (a file system for Spectrum Protect); where you can mount the IBM Spectrum Protect storage as a filesystem/mount point or drive letter on your server, and in this way have full control of both the methods used to take the backups and being able to browse your data using normal OS commands; such as ls / DIR.
As you have full control, you need fewer educations, no need to learn how a backup agent works.
Search for gsd + spfs +, and you will find the SPFS solution listed on the IBM site. Couldn't paste the linke here?
Eg # mount -t spfs /backup (or right click "My Computer" -> mount on Windows)
> DUMP DATABASE mydb TO DISK = '/backup/mydb.dmp' > GO
Another way to protect Sybase ASE is to use database consistent snapshot, where each snapshot is stored on the IBM Spectrum Protect server using progressive block level incremental forever (always incremental backup) techniques.
It quiece the database, take a local snapshot, release quiece, and send incremental changes of the local snapshot since last taken snapshot to the backup server.
This way, you have a backup time that is faster the more often you take it, as only incremental changes will be sent.
Restore is nearly instant, as the snapshot will be provisioned from the IBM Spectrum Protect backup server storage via the IBM Spectrum Protect Client API as a local snapshot disk, which can be assigned to a new empty or existing storage on the same or new server.
The operating system can then be reverted to the previous snapshot, which starts a "copy back" in the background.
The Sybase ASE database can be started immediately; while the operating system is reverting to the previous snapshot in the background.
The restore time will be only a few minutes regardless of the size of the database.
This is a wonderful database that is, in my opinion, underrated. Users are able to get the most out of my experience by taking advantage of its centralized environment.
We’re launching an annual User’s Choice Award to showcase the most popular B2B enterprise technology products and we want your vote!
If there’s a technology solution that’s really impressed you, here’s an opportunity to recognize that. It’s easy: go to the PeerSpot voting site, complete the brief voter registration form, review the list of nominees and vote. Get your colleagues to vote, too!
...
Dear professionals,
Welcome back to PeerSpot's Community Spotlight! Below you can find the latest hot topics posted by your fellow PeerSpot Community members. Read articles, answer questions, and contribute to discussions that are relevant to you and your expertise. Or ask your peers for insight on topics that interest you!
Trending
Here are some topics that your peers are discussi...
Director of Community at PeerSpot (formerly IT Central Station)
Aug 2, 2022
@Chris Childerhose, @PraveenKambhampati, @Deena Nouril, @Shibu Babuchandran and @reviewer1925439,
Thank you for contributing your articles and sharing your professional knowledge with 618K PeerSpot community members around the globe as well as with a much bigger readers audience!
Every Virtualization and System Administrator deals with having the ability to recover servers, files, etc. and having a Backup Solution to help with recovery will ease the burden. But how do you know which one is right for you? How would you go about choosing the right solution that will help you in your daily tasks?
Software Criteria
When choosing a backup solution there are many things t...
Dear PeerSpot community members,
Welcome to the latest PeerSpot Community Spotlight, where we sum up the most relevant recent postings by your peers in the community.
Check out the latest questions, articles and professional discussions contributed by PeerSpot community members!
Trending
Here are some topics that your peers are discussing at the moment:
What is your recomme...
Hi PeerSpot community members,
This is a fresh-from-the-oven Community Spotlight for you. Here, we've summarized and selected the latest posts (professional questions, articles and discussions) by PeerSpot community members. Check them out!
Also, please share with us your feedback and suggestions by commenting below!
Trending
See what is trending at the moment and chime in to discuss!
...
Download our free Backup and Recovery Software Report and find out what your peers are saying about SAP, NetApp, Veeam Software, and more! Updated: February 2023.
As a Market leader Netbackup provides a heterogeneous backup solution for large-scale data centers.
This includes Sybase database support, which provides a centralized backup and restore solution for all your Sybase database servers using the same storage used for all your other backups optimizing your backup storage usage.
Also, it provides a transparent "backup and restore" service for the Sybase database admin using their own tools: Isql or DBIsql.
http://docplayer.net/57605669-...
Hi
There are many different ways to perform the backup of SAP Adaptive Server Enterprise on the market today.
If you want the freedom to see your backups using normal OS commands, such as "dir" or "ls" commands, and in the same way know that everything stored on this path is secured, and has retention policies, space-efficient, and fast than Spictera SPFS can be a good choice, where the DBA can use the preferred methods to backup their databases.
E.g.
# mount -t spfs /backup
SQL> DUMP DATABASE mydb TO '/backup/my.bkp'
SQL> GO
All file system operations that go via this mountpoint (/backup in the above example) will be translated to IBM Spectrum Protect Client API calls, so nothing is cached locally
Retention and versioning are managed via the IBM Spectrum Protect server, where one can control how many versions and/or retention of the backups, including how many copies, etc.
SPFS has also the ability to use encryptions using their own private encryption keys if needed.
SPFS has built-in data reductions using compression and de-duplication if needed.
SPFS has automatical failover and fallback for those who have that as a demand if replication services have been configured on the IBM Spectrum Protect server, and this data is configured to be replicated.
This solution is agentless and does not require any specific education to learn how an agent works (which literally sometimes hides the techniques inside the agent)
After all, it can't be more simple to use? as everyone probably already knows how to use a filesystem, right?
https://www-50.ibm.com/partner...
https://www.spictera.com
Regards,
Tomas
Commvault and Netbackup are at the top of the list: comprehensive and best features, full, inc, BMR, VM, end-user, any type of schedule even replication.
Commvault's protection provides complete protection for the Sybase server, which consists of system and user databases in different environments.
Regardless of what software I use for backups, I prefer to do database backups from within the database itself using a script as an extra measure of security.
For Sybase, I found this useful link.:
SyBooks Online (Archive) (sybase.com)
Full link:
https://infocenter-archive.syb...
Sybase ASE has built-in support with IBM Spectrum Protect.
Another way is to use SPFS (a file system for Spectrum Protect); where you can mount the IBM Spectrum Protect storage as a filesystem/mount point or drive letter on your server, and in this way have full control of both the methods used to take the backups and being able to browse your data using normal OS commands; such as ls / DIR.
As you have full control, you need fewer educations, no need to learn how a backup agent works.
Search for gsd + spfs +, and you will find the SPFS solution listed on the IBM site. Couldn't paste the linke here?
https://www-356.ibm.com/partne...;solution=56435
Eg
# mount -t spfs /backup
(or right click "My Computer" -> mount on Windows)
> DUMP DATABASE mydb TO DISK = '/backup/mydb.dmp'
> GO
Another way to protect Sybase ASE is to use database consistent snapshot, where each snapshot is stored on the IBM Spectrum Protect server using progressive block level incremental forever (always incremental backup) techniques.
It quiece the database, take a local snapshot, release quiece, and send incremental changes of the local snapshot since last taken snapshot to the backup server.
This way, you have a backup time that is faster the more often you take it, as only incremental changes will be sent.
Restore is nearly instant, as the snapshot will be provisioned from the IBM Spectrum Protect backup server storage via the IBM Spectrum Protect Client API as a local snapshot disk, which can be assigned to a new empty or existing storage on the same or new server.
The operating system can then be reverted to the previous snapshot, which starts a "copy back" in the background.
The Sybase ASE database can be started immediately; while the operating system is reverting to the previous snapshot in the background.
The restore time will be only a few minutes regardless of the size of the database.