Microsoft does not support restoring VSS backups
into a SQL Server that has a different name.

This is a Microsoft restriction and is
documented in the Data Protection for SQL User's Guide.

Thank you,

Del

----------------------------------------------------


"ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu> wrote on 04/08/2014
11:56:22 AM:

> From: Dhammika Rathnayake1 <dhrathna AT LK.IBM DOT COM>
> To: ADSM-L AT vm.marist DOT edu,
> Date: 04/08/2014 11:59 AM
> Subject: TDP for SQL Server - restoring Database to another server
> (VSS Backup)
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
>
> Hi,
>
> I have restored the sql database to another server. Production server
> backup type is VSS (Windows Volume Shadow Copy).
> Restoration has completed successfully. But I didn't see restored
database
> on the new server.
>
> After investigate the incident I realized that with the restoration
> production database has been overwrite.
> I used Tivoli Flash Copy Manager to do this restoration.
>
> Could you please explain me the method to restore VSS backup.
>
> Thanks
> Dhammika
>