More research and testing on the issue below seems to indicate that I have to 
change the backup type from VSS to Legacy to fully enable the Restore Alternate 
Location option on the target server.


Thanks & Regards
Paul

> We have TSM v6.3. On two Windows 2012 64bit servers we have the TDP Storage 
> Flashcopy manager v3.2.1.0 client.
> Both of these servers run MS SQL Server 2012.
>
> I would like to restore databases backed up on one server to the other. The 
> databases are backed up using the "tdpsqlc backup * full" command, which runs 
> via Windows Task Scheduler.
> To restore databases backed up on one server to the other I first change the 
> dsm.opt file in the TDPSql folder - making the nodename the node from which I 
> am restoring the databases from.
> I then start the "DP for SQL Management Console" which in turn opens the TDP 
> Storage Flashcopy manager window.
>
> My problem occurs when I select a database and then select "Restore Alternate 
> Location". In the settings window I click on "Restore to a new database", 
> however the option to relocate files individually is greyed out.
> When restoring from other servers when I click on Restore to a new database I 
> see the green progress bar appear at the bottom of this settings window and 
> then TSM displays the location of the database file and log file on the 
> source server.
> This does not happen on this occasion.
>
> Is there a setting when trying to restore (or when backing up the original 
> files) that has to be changed? There is an option to relocate all the files 
> to one location however this is not suitable as the database file and log 
> file need to be restored to different > drives.








ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named add
ressees. Any unauthorised dissemination or use is strictly prohibited. If you 
received
this e-mail in error, please immediately notify the sender by return e-mail 
from your s
ystem. Please do not copy, use or make reference to it for any purpose, or 
disclose its
 contents to any person.