Date - Mar 2009
Affected Product Version - 8.2.x
Affected Module & Version - MS SQL APM
OS Version - Microsoft
Application Information - MS SQL server 2000 or 2005
Description:
Customer would like to be able to select individual table items for restore from MS SQL backup.
The restore selection browses to this level of granularity but does not allow table level choices.
We cannot restore at the table level, as MSSQL does not support this since version 7.0. SQL Server 6.5 allowed this, but MS removed this functionality.
We show the non-selectable tables in the restore tree for purely informational use only, to show the user what was in the database they want to restore.
Recommendation is to restore the entire database using the Rename option or restoring to an alternate instance if the backup was done using the VDI option. Then extract out the table in question using Microsoft's Data Transformation Service (DTS/BCP).
See the NetVault_Backup_APM_for_SQL_Server_Users_Guide.pdf for detailed instructions on these alternate restore procedures.
