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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center