TSM SQL database restoration method is very flexible. My example is just a small taste of it. Example 1: Restore DB with same name to the same server 1) Delete the table dbo.ChunkData from the ReportServerTempDB to simulate the scenario of data loss. 2) Open flash copy manager on TSM_Client01 and set Replace=True in the … Continue reading TSM 6.3: Restore SQL Database →

There are two  types of backup method in Tivoli Data Protection for SQL Sever: VSS and Legacy. VSS backup only supports Full, Legacy backup supports Full, Differential and Log. VSS backup supports instant restore (volume level), fast restore (file level), but it only can restore the data to the server with same name. Legacy backup … Continue reading TSM 6.3: Backup SQL Database →

1) Double click SetupFCM.exe in the installation package folder, then just follow the wizard. 2) Login into TSM_Sandbox to create the SQL domain policy and register the SQL node. define domain SQLdefine policy SQL NORMAL desc=”Normal SQL backup policy”define mgmt SQL NORMAL DAILYassign defmgmtclass SQL NORMAL DAILYdefine copygroup SQL NORMAL DAILY type=backup dest=DEDUPPOOL verexists=7 retextra=30 … Continue reading TSM 6.3: Install Data Protection for SQL Server →

There are two types of schedule: Client schedule and Administrative schedule. The client schedule is to backup or restore the clients’ data. The administrative schedule is to do TSM server maintenance jobs. Example 1: Daily backup job - Incremental backup TSM_Client01 C:\Backup folder at 00:05 every day.  1) Login into TSM_Client01 and add the following … Continue reading TSM 6.3: Create Schedule →

Dedupcation only keeps a single instance of redundant data on the storage (must be sequential device). The advantage is to save space (= save money, TSM license is not cheap). But it also brings in some disadvantages, e.g it requires 16G memory as minimum, adds more system load, increase the database size significantly (4-5 times).  … Continue reading TSM 6.3: Setup the Deduplication →