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.





Thanks & Regards

Paul










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.