I have been trying a few experiments with VSS mainly related to backup and restore of SQL database across different scenarios.
The experiments that have succeeded so far are:
Continuing on the same route, I have been trying to perform the experiment in which I backup the database from default instance of one host and restore it to named instance of another host and it fails with this error.
2020/07/21 13:59:07 ERROR 32 (0x00000020) Copying File C:\user\VSS\VSSBackups\VSSTestDB1.mdf
The process cannot access the file because it is being used by another process.
Waiting 1 seconds... Retrying...
Older 8.0 m VSSTestDB1.mdf
2020/07/21 13:59:08 ERROR 32 (0x00000020) Copying File C:\user\VSS\VSSBackups\VSSTestDB1.mdf
The process cannot access the file because it is being used by another process.
Waiting 1 seconds... Retrying...
The error is also the same if I backup database from default instance of one host and restore it to named instance of same host.
I want to ask now that is this a known issue with VSS or SQL server that we can't restore DB's from default instance to a named instance?
In case you want to enquire the steps that I have followed, please have a look below:
.\vshadow.exe -p -bc=C:\user\VSS\backupComp22.xml C:\
.\vshadow.exe -exec=vss-robocopy2.cmd -r=C:\user\VSS\backupComp22.xml
User contributions licensed under CC BY-SA 3.0