Comprehensive data protection for all workloads
Post Reply
marieelieg
Expert
Posts: 147
Liked: 8 times
Joined: Oct 20, 2016 7:15 am
Contact:

Restore a table from a database backup

Post by marieelieg »

Hello,

Not sure if this question is already answered. But, can we restore a specific table from a database backup (for example, SQL/Oracle, etc.)?
In other words, can we select a specific table to restore, without restoring the database? (like restoring a single user for Active Directory)
If yes, what is the procedure?

Thanks in advance :)
Mildur
Product Manager
Posts: 8735
Liked: 2296 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: Restore a table from a database backup

Post by Mildur » 1 person likes this post

Hi Marieelieg

For MSSQL, you can use our Veeam Explorer for Microsoft SQL Server:
This option requires a VUL, Ent or Ent+ license.

For Oracle, we don't have this integration in our explorer. If you have done an image backup of the vm, you have to restore the entire database. But you can publish the database, export the data you need and import them to the original database.
This option requires a VUL, Ent or Ent+ license.

If you use our Oracle RMAN plugin, then you can use RMAN commands to restore the table from the backup.
The RMAN Plugins requires VUL or Ent+.

Thanks
Fabian
Product Management Analyst @ Veeam Software
Post Reply

Who is online

Users browsing this forum: Google [Bot], Semrush [Bot] and 100 guests