Solved

Commvault MYSQL / MSSQL restoration


Badge +1

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!

icon

Best answer by Scott Reynolds 1 July 2022, 16:12

View original

2 replies

Userlevel 6
Badge +14

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

 

Badge +1

Hi Scott,

 

Thanks for the response!

Reply