Single table restoration from database in netbackup

[V4]

Is it possible to restore only indiviual table instead of complete SQL database using netbackup scripts anyway.

Cheers

Vaibhav

NBU 7.0.1 - Win2k3

SQL 2k5ENT

DB size 1.3TB

table to be restored 100 gb

[Marianne]

The smallest unit that can be restored is a database since that is how it is backed up.

Please see this TN for procedure to use bplist to obtain a single image number and include it in a restore script:

http://www.symantec.com/docs/TECH23166

The TN is quite old but still valid.

[V4]

Thanx marianne

But could you let me know does this images are the tables itself or could it be logs.

This was queried to me for the possibility of individual table restoration amongst database. Actually i was not sure with SQL granularity with netbackup.

Please highlight if table restore is possible

[Eric_Zhang]

Netbackup can not just only restore a certain table ,  what you can do is to restore the single database which the table belongs to .

[kumar_n]

I have similar query but mine is backup exec 2010 with sql agent.