How to use "Restore Database to Specified SQL Server" option,
to restore a database to another SQL server, using Tivoli Storage Manager for Microsoft Sharepoint?
1, On the DocAve GUI, go to data protection -> restore controller -> settings.
2, Create a staging SQL server profile.
3, Go to data protection -> restore controller -> platform restore.
4, Select the agent -> click "load timeline" -> select the backup data
-> browse the farm tree -> select the database which you want to restore
-> click "advanced options" -> select "Restore Database Only" option and
"Restore Database To Specified SQL Server" option -> select the staging
SQL server which was created at #2 -> click "Go" button to start restore
job. The database will be restored to the staging SQL server