Optimize for table level restore

Question

Hi All,

short question regardind the backup feature Optimize for table level restore for the sql idata agent.

Unless otherwise noted for a particular feature, block-level browse is not supported from backups to tape libraries or virtual tape libraries. If you want to perform a block-level restore by using a secondary copy on tape libraries or virtual tape libraries, move the copy to disk storage before performing the restore.

Performing a Block-Level Backup Operation on SQL Databases

so what happend if we have this feature aktive and have tape as sync copy. Is it like guest files and folder restore for vmware that this is not possible but hole vm / db is possible ?

Or did we have to bring the backup jobs back to disc library from tape to run an normal db restore or is only table browse not possible ?

Paul G · Accepted Answer

Hi ​@SSchmidt,Block level browse will not be available from tape but full DB restores will still work from tape.If you want to perform a table level browse, you would first need to copy the job data back to a disk library copy.This is the same as how VM live browse used to work as VMware browse nowadays has support for live browse from tape by copying over the entire job to a staging area on the MA (the job results directory). Not sure if and when this will also be possible for databases.Kind regards,Paul

Orazan · Answer

You would need to move the data back to disk to run the restore.

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded