Video Screencast Help

Restore tables with BE

Created: 08 Jul 2013 • Updated: 10 Jul 2013 | 6 comments
n3m3sls's picture
This issue has been solved. See solution.

Hi i have a question:

Backup Exec 2012 can restore tables? or just restore entire databases?


Operating Systems:

Comments 6 CommentsJump to latest comment

lmosla's picture

Just entire databases.  The ability to restore table would add inconsistency and instability to SQL databases.

n3m3sls's picture

I have understood that earlier versions of BE if they could do that right?

teiva-boy's picture

Symantec NetBackup can do table level restores, and can a number of other backup products.  

When an Enterprise product can do it, why would you say "The ability to restore table would add inconsistency and instability to SQL databases?"

Typically when one does a table restore, it's to a temp database, and it's to restore very specific information that is needed.  It's then typically merged as needed into Prod.  You're not typically restoring a table over an existing production database.

There is an online portal, save yourself the long hold times. Create ticket online, then call in with ticket # in hand :-) "We backup data to restore, we don't backup data just to back it up."

n3m3sls's picture

Hello, my question is about the Backup Exec 2012, still i do not know the NetBackup product, thanks for the comment ...

pd. sorry for my english is bad!! jeje thanks

lmosla's picture

I did some research on this and found this discussion which talks about Microsoft removeing the ability to do this level of a restore in v7.

and on a side note since I was is a document talking about using Netbackup to Restore SQL from Backup Exec images and some of the limitations    (such as 'sqlTable backups cannot be restored, though they are included in the backup image and can be selected for restore. If you try to restore a table, the job fails with the error "unsupported object was selected for restore')  

Hope this helps

n3m3sls's picture

Thanks for the information...