Skip to main content

Hello everyone!

 

I would like to confirm if MySQL and MSSQL database cannot be restored per table like Oracle databases?

If not possible can you share with me the alternatives if client wants to restore per table in MySQL and MSSQL.

 

Thank you!

Hello MJDC

In the traditional sense you are correct they cannot. Functions of backup/restore support are limited to the vendors support. In most cases we see customer restore the database as an alternate name/alternate server and extract tables needed. This simple and straightforward.

However there is another solution which involves block level backups for both agents. When the backup is performed with block level there are options for table restores.

MySQL

https://documentation.commvault.com/11.24/expert/19409_restore_mysql_database_tables_and_instances_from_block_level_backup.html

MSSQL

https://documentation.commvault.com/11.24/expert/92237_creating_sql_server_recovery_points.html

 

Hi Scott,

 

Thanks for the response!

Reply


Terms & ConditionsCookie settings