Skip to main content
Solved

Commvault MYSQL / MSSQL restoration


Forum|alt.badge.img+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!

Best answer by Scott Reynolds

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

 

View original
Did this answer your question?

2 replies

Forum|alt.badge.img+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

 


Forum|alt.badge.img+1
  • Author
  • 3 replies
  • July 4, 2022

Hi Scott,

 

Thanks for the response!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings