Abstract:
According to certain aspects, a system may include a data agent configured to: process a database file residing on a primary storage device(s) to identify a subset of data in the database file for archiving, the database file generated by a database application; and extract the subset of the data from the database file and store the subset of the data in an archive file on the primary storage device(s) as a plurality of blocks having a common size; and at least one secondary storage controller computer configured to, as part of a secondary copy operation in which the archive file is copied to a secondary storage device(s): copy the plurality of blocks to the secondary storage devices to create a secondary copy of the archive file; and create a table that provides a mapping between the copied plurality of blocks and corresponding locations in the secondary storage device(s).
Abstract:
A data storage system according to certain aspects can archive database data associated with different database applications. The data storage system according to certain aspects may provide database archiving modules that include logic incorporating and/or based on the native schema and/or native commands specific to particular database applications. The database archiving modules according to certain aspects may determine the relationship between tables associated with corresponding database applications and archive selected database data based on the native schema and native commands.
Abstract:
A data storage system according to certain aspects can archive database data associated with different database applications. The data storage system according to certain aspects may provide database archiving modules that include logic incorporating and/or based on the native schema and/or native commands specific to particular database applications. The database archiving modules according to certain aspects may determine the relationship between tables associated with corresponding database applications and archive selected database data based on the native schema and native commands.
Abstract:
Rather than relying on pre-defined scheduling of secondary copy operations such as backup jobs, the illustrative opportunistic approach initiates secondary copy operations based on changing operational conditions in a storage management system. An adaptive backup readiness score is based on a number of backup-readiness operational factors. An illustrative enhanced data agent which is associated with the target database application (or other executable component) may monitor the operational factors and determine the backup readiness score based on weights assigned to the respective operational factors. The enhanced data agent may evaluate recent backup jobs to determine which of the operational factors that contributed to the backup readiness score may have been most relevant. Based on the most-relevant analysis, the enhanced data agent may adapt the weights assigned to the monitored operational factors, so that the backup readiness score may be more suitable and responsive to ongoing operational conditions in the system.
Abstract:
A data storage system, according to certain aspects, automatically backs up source data when the replication data is faulty. For instance, the system performs data backup using replication data rather than source data to reduce the processing load on the source system. The backup data is then associated with the source data as if the backup had been performed on the source data. If the replication system fails, then backing up replication data results in backup data that does not accurately reflect the source data. When permitted by the user system configuration, the system automatically backs up source data when replication has failed.
Abstract:
A method and system for utilizing snapshots to provide copies of a database or other application or large data structure to computing devices receives a request for access to a copy of a database, and performs a snapshot of a storage volume containing the requested database. The system then clones the snapshot and mounts the snapshot to a computing device, thus enabling the computing device to access a copy of the database. In some examples, the system automatically updates copies of a database on a scheduled basis (e.g., daily or weekly basis) to refresh a database regularly.
Abstract:
The data storage system according to certain aspects can implement table level database restore. Table level database restore may refer to restoring a database table and its related data without restoring the entire database. The data storage system may use table metadata index to implement table level restore. A table metadata index may be created for each table, e.g., during a backup of the database. The table metadata index for a table can include any type of information for restoring the table and its related data. Some examples of the type of information included in the table metadata index include the following: container for the table, table backup location, system data, table index, table relationships, etc. Table metadata index can make the restoring of tables fast and efficient by packaging information that can be used to restore a table and its related data in an easily accessible manner.
Abstract:
A system according to certain aspects improves the process of restoring database objects and converting those objects into another database file format. According to certain aspects, a database file is backed up in a block-level fashion. Instead of restoring the entire backup file, which can consume a large amount of time and computing resources, the information management system may restore a particular database object from a backup database file that is stored as multiple blocks or other granular units. Then, the information management system can extract the desired data from the restored block(s). By using block-level mapping and storage techniques described herein, the system can restore a database object in a backup database file without restoring the entire backup database file, thereby speeding up restore operations and reducing consumption of storage and processing resources. In addition, the information management system can convert the blocks, using a staging memory, to another database file format as desired.
Abstract:
The systems and methods provide for migrating such applications to cloud storage by automating a continuous replication of changes made to the DBMS from the DBMS to an associated cloud instance. For example, the systems and methods facilitate the migration of the DBMS via multiple processes performing in parallel—a process to create and provision a new machine instance (e.g., an EC2 instance), a process to clone and transfer parameters of the operating system/software of the DBMS, and a process that backs up and/or captures the application data of the DBMS.
Abstract:
The systems and methods provide for migrating such applications to cloud storage by automating a continuous replication of changes made to the DBMS from the DBMS to an associated cloud instance. For example, the systems and methods facilitate the migration of the DBMS via multiple processes performing in parallel - a process to create and provision a new machine instance (e.g., an EC2 instance), a process to clone and transfer parameters of the operating system/software of the DBMS, and a process that backs up and/or captures the application data of the DBMS.