How to recover MSSQL V3.903 missing index from nvdb backup (4045418)

Title:How to recover MSSQL V3.903 missing index from nvdb backup
Date: 07/2005
NV Version: 7.1 or later
OS Version: ALL
Application version: MSSQLSERVER 2000
Plugin version: MSSQLSERVER V3.903


Description:
There is a problem with the suggested recovery workaround for the MSQLSERVER V 3.903 index issue not being written to tape.
Whereby to perform a restore once the index has retired from the netvault database and cannot be scanned in from the backup tape

The current suggestion is to recover an expired index from a netvault database backup - however there are problems with this operation when the index has been expired on a retirement date - generation based retirements are not affected.

Currently when the netvault media manager process is initiallized as part of the database restore a cycle of media retirement is executed.
This 'rotation' results in any indice that have breached expiry criteria to be retired and removed from within the netvault database.

Symptoms:

Upon recovering the netvault database the required MSSQLserver saveset still does not appear within the restore gui and the restore is not possible.