Date: 01/2010
NV Version: all
OS Version: all
Application version: MS SQL
Plugin version: All
Description:
If you try to restore a SQL Database that was backed up with the Backup Options set to Use Volume Shadow Copy Services (VSS), and set to use the Rename option on the Restore Selection Window, then the Restore job will fail.
This is a known issue, documented by Microsoft.
This restore fails because the "The SQL Writer currently does not support "Rename across Instances" to move the database to a new instance.
Currently located at:
http://technet.microsoft.com/en-us/library/cc966520.aspx
http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/SQLWriter.doc
SQL Writer in SQL Server 2005: A Guide for SQL Server Backup Application Vendors
"The backup application is only allowed to specify new targets for the physical path, but not the file specification. For example, for a database file located at c:\data\test.mdf, the actual file name, test.mdf, cannot be changed. Only the path c:\data can be changed."
Symptoms:
The SQL VSS writer cannot restore a database in place
( in the same directory as the original database)
In the binary log;
Failed to Prepare VSS Components for Restore
Fatal Error: Restore Failed
The workaround is to relocate to a temp directory, close the SQL server DB and copy it back to the original location.
