Return
-
Title
SQL Server restore with multiple stream on a single tape can't be restored -
Description
SQL Server restor with multiple stream on a single tape will deadlock when requesting the tape during restore because the restore will have acquired the tape once, and is attempting the acquire the tape again.
This usually happen the backup is performed to a multistream capable device (like RDA device or smartdisk), and then datacopied to a tape while allowing streams to share media.
-
Resolution
The only way to restore this back is to datacopy the backup back to the original multi-stream capable device. However it was noted that data copied backupset can't be datacopy again. The following steps will allow Netvault to perform a datacopy on the saveset again.--------Modify the Archive flag to FALSE in database.This can be done in two ways as follows:Using GUILaunch the pgAdmin3 (installed in <Netvault_Install_Dir>\pgsql\bin )Connect to the Netvault database and go to netvault_mediamanagement database.Go to schema->Public→medmgrbackuprecord table.Fire update command or edit in view records the barchive column to FALSE respective to jobid.Using Command PromptOpen command prompt and change directory to <Netvault_Install_Dir>\pgsql\binFire up the below command and replace XXX with phase 2 backup jobid in below command line.SQL Querypsql -U postgres -W -p 51486 -d netvault_mediamanagement -c "UPDATE \"medmgrbackuprecord\" SET \"barchive\"=FALSE WHERE \"jobid\"=XXX"--------After this, perform a datacopy from the tape saveset to a RDA device or smartdisk and perform the restore from there.