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.