« 7.1. IBM Tivoli FlashCopy Manager Backup

7.2. IBM Tivoli FlashCopy Manager Restore

Tivoli FlashCopy Manager offers as great amount of options when it comes to restore as it has for backup. This section will cover the most used ones. The type of features & destination types available will be limited if you don’t have TSM integration. The features & destinations which is only available with TSM integration will be pointed as they are covered.

1- To start the IBM Tivoli FlashCopy Manager in a stand alone server all you have to do is to click on the IBM Tivoli FlashCopy Manager on the desktop or your program files menu. If you are running in a clustered environment, then you would want to to ensure you start your FCM with the /sqlserver parameters. An example of the command to run the FCM GUI in a clustered environment with an SQL Cluster name sqlsrvpoc is:

C:\Program Files\Tivoli\FlashCopyManager\flashcopymanager.msc /sqlserver=sqlsrvpoc

2- Lunch the Backup & Restore GUI as shown in the image below:

ibm-tfcm-restore-tdp-gui

3- From Restore Database tab you can choose the backup you want to restore & hit restore. The restore operation should finish in a manner of seconds, and your database should be operational after that. A background copy will proceed for a longer time, but that will not affect your database operations.

tivoli-data-protection-for-microsoft-sql-server-choose-database-to-restore

4- If you have integrated your IBM Tivoli FlashCopy manager with TSM & took a VSS backup followed by log backups, you will have the option to restore to a point of time backup.

ibm-tfcm-integrated-tdp-point-in-time-recovery-for-ms-sql-server-database

5- If you have TSM integration you will have a restore into & relocate functionality to restore a database with a different name or to a different location as showing in the images below:

integrated-tivoli-data-protection-for-microsoft-sql-relocate-into-restore

integrated-tivoli-data-protection-for-ms-sql-restore-into-directory1

integrated-tdp-for-sql-relocate-files-into-directory

6- The restore sets/Group/Files tab that is normally available with TDP as well is available in IBM Tivoli FlashCopy manager if integrated with TSM.

ibm-fcm-tdp-restore-groups-file-sets

7- Just as all the backup options can be called from command lines, the same is true for restore. To find out more about IBM Tivoli FlashCopy restore command syntax run the following command:

“C:\Program Files\Tivoli\tsm\TDPSql\tdpsqlc.exe” restore help

Back to: IBM Tivoli Storage FlashCopy Manager Tutorial Index

Comments (0) Posted in FlashCopy Manager