I am trying to script the SQL database recovery .
I try to create a Selection first:
I have a clustered environment and a virtual client configured.
VIRTUALSQL01 - is the name of the virtual client and the SQL server cluster name.
Team Sites_Content - is a database name
NVBUCLUSTERCL - the real client name
When I run the following command like
C:\Program Files\BakBone Software\NetVault Backup\util>nvsetcreate -setname RM_22308209 -type RS -client VIRTUALSQL01 -plugin "SQL Server APM" -saveset 1642 -in
clude "VIRTUALSQL01/Team Sites_Content" -rename "VIRTUALSQL01/Team Sites_Content=Y:\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\DATA/RM_TEMP_CONTENT_B71BB5DA_22308209" -restoretarget NVBUCLUSTERCL -restoreoption 133=True -restoreoption 404=VIRTUALSQL01
I get the "Failed to add selection 'VIRTUALSQL01/Team Sites_Content'" error.
To recover your database present in damaged or corrupted MDF file, I recommend you to use SQL Database Recovery.
This tool is primarily developed for technical as well non-technical users. Users can simply recover corrupt database from suspect mode & any kind of corruption situations. Users can simply recover corrupt database from suspect mode & any kind of corruption situations. It is capable to recover each & every database from damaged MDF file including XML data type, tables, triggers, deleted data etc.
Read more at : softmagnat(DOT)com/sql-database-recovery