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!
Answer
Commvault MYSQL / MSSQL restoration
- Novice
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
MSSQL
https://documentation.commvault.com/11.24/expert/92237_creating_sql_server_recovery_points.html
- Vaulter
- Answer
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
MSSQL
https://documentation.commvault.com/11.24/expert/92237_creating_sql_server_recovery_points.html
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.