Users execute sp_dumpoptimize to establish options for database backups. For example: sp_dumpoptimize ‘allocation_threshold = 0’ sp_dumpoptimize ‘parallel_scan = 1’ These options take effect immediately without problem; When Backup Server is.
Dropped all user tables in a database in ASE Database log has been truncated prior to dumping database Issuing the following commands to dump the database: exec sp_dumpoptimize ‘archive_space = maximum’ go DUMP DATABASE db_firmprod TO ‘/sybase/sybdump/SYBA, sp_dumpoptimize. Specifies the amount of data dumped by Backup Server during the dump database operation. sp_encryption. Reports encryption information. sp_engine. Enables you to bring an engine online or offline. sp_estspace. Estimates the amount of space required for a table and its indexes, and the time needed to create the index. sp_export_qpgroup, sp_dumpoptimize. Specifies the amount of data dumped by Backup Server during the dump database operation. sp_estspace. Estimates the amount of space required for a table and its indexes, and the time needed to create the index. sp_export_qpgroup. Exports all plans for a specified user and abstract plan group to a user table. sp_extendsegment, If the ASE sp_dumpoptimize feature is set to maximum as follows, more disk space will be consumed on Delphix storage because ASE writes both allocated and unallocated pages into the dump files: sp_dumpoptimize ‘archivespace = maximum’ R elated Links. Managing SAP ASE Data Sources;, 5/18/2015 · SAP KBA: 2064844 – Execution of sp_dumpoptimize sets options for database backups. These options are lost when Backup Server is restarted. These options are lost when Backup Server is restarted. – SAP ASE
