Running database backup is one of the most critical part of DBA’s job. If you don’t have RTO and RPO defined and backup job configured to meet those objectives then the job could be at stake. When its daily job, we need to ensure that the backup(dump) process could finish as fast as possible. When …
How to Expedite SAP Sybase ASE Backup(Dump) Process Read More »
Lets cover the loading mechanism to Sybase ASE database. Before loading the dump into the database, we need to ensure that there is no active connection to this database as loading requires to have exclusive access. If exclusive access is not granted, loading process will fail with below error message: Msg 3101, Level 16, State …
As mentioned in the previous post on saving storage by using compression Backup compression – save storage 85%(up to) without compromising duration, we shall go into depth of compression levels and their impact on duration as well as size at disk. As you know, Sybase ASE supports compression level from 1 to 9, 1 is …
We have covered dump database to a single file and multiple files in the post Improve performance of DB Backup timing by more than 50% and also witnessed how we can save storage by more than 85% in the post Backup compression – save storage 85%(up to) without compromising duration. As we had discussed in …