Hi Francisco

 Thanks a lot!!!!

 Best Regards,
 Dhammika



From:   Francisco Parrilla <francisco.parrilla AT GMAIL DOT COM>
To:     ADSM-L AT vm.marist DOT edu,
Date:   04/09/2014 08:25 PM
Subject:        Re: [ADSM-L] TDP for SQL Server - restoring Database to another
            server (VSS Backup)
Sent by:        "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>



You can do both backups by the TDP for databases, but only legacy backup
can be restored to another server, VSS backup just can be restored at the
same server. If you try to issue a restore you can recover the database
files but never put online in SQL instance.

Best Regards



2014-04-08 23:54 GMT-05:00 Dhammika Rathnayake1 <dhrathna AT lk.ibm DOT com>:

> Hi Francisco Parrilla,
>
>  Thank you for the information.
>
>  version is 6.4.
>  Is online Legacy backup is enough?
>
>  Best regards,
>  Dhammika
>
>
>
> From:   Francisco Parrilla <francisco.parrilla AT GMAIL DOT COM>
> To:     ADSM-L AT vm.marist DOT edu,
> Date:   04/08/2014 09:41 PM
> Subject:        Re: [ADSM-L] TDP for SQL Server - restoring Database to
> another
>             server (VSS Backup)
> Sent by:        "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
>
>
>
> Which version of TDP have you?
> To restore SQL backup to another node this must be type Legacy backup ,
> there are one restriction for VSS backup, this of kind of backup just can
> restoring at the same server on some versions of TDP for SQL
>
> Best regards
>
>
>
> 2014-04-08 10:56 GMT-05:00 Dhammika Rathnayake1 <dhrathna AT lk.ibm DOT com>:
>
> > 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
> >
>