ISSUE Some events are missed from the results of command ‘q event * * begind=today-1’. CAUSE This is due to the schedule has been updated. SOLUTION This is stupid I think. The workaround I use is to check the activity log by running ‘q actlog begind=today-1 begint=xx:xx:xx endd=today-1 endt=yy:yy:yy’

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 →