Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

sql restore from tape

Created: 14 Mar 2013 • Updated: 14 Mar 2013 | 2 comments
This issue has been solved. See solution.

Hi;

I am trying to restore sql backup from tape. I set all the tape copies primary from catalog. If i try to restore a  backup image just one stripe, everything is ok. Hovewer, if i try to restore a database including two images(backed up with two stripes), operation is failing. What am i doing wrong? Please help!

 

Operating Systems:

Comments 2 CommentsJump to latest comment

Will Restore's picture

from the Admin Guide:

When you use the NetBackup SQL Client, backups using multiple stripes are restored automatically.

 and

In most cases, Symantec does not recommend multiplexing multiple SQL Server

streams from the same backup to a single tape. However, you may want to do this

if you vault or export backup images. During the restore of this type of multiplexed

backup, NetBackup may time out while trying to synchronize access to data blocks

from the backup tape. To prevent this time out, change the stripes parameter in

the recovery batch file from STRIPES N to STRIPES 1.

Will Restore -- where there is a Will there is a way

SOLUTION
yilkilicaslan's picture

Thx for your answer. It worked like a charm.