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@vm.marist.edu> wrote on 04/08/2014 11:56:22 AM: > From: Dhammika Rathnayake1 <dhrat...@lk.ibm.com> > To: ADSM-L@vm.marist.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@vm.marist.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 >