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 SQL
define policy SQL NORMAL desc=”Normal SQL backup policy”
define mgmt SQL NORMAL DAILY
assign defmgmtclass SQL NORMAL DAILY
define copygroup SQL NORMAL DAILY type=backup dest=DEDUPPOOL verexists=7 retextra=30 verd=7 reto=30
define copygroup SQL NORMAL DAILY type=archive dest=DEDUPPOOL retver=30
validate policy SQL NORMAL
activate policy SQL NORMAL
Register TSM_Client01. In my example, I have already registered it the previous tests.
register node TSM_Client01 <password>
update node TSM_Client01 backdelete=yes forcep=yes
Register TSM_Client01_SQL as SQL backup proxy node.
register node TSM_Client01_SQL <password> domain=SQL
update node TSM_Client01_SQL backdelete=yes forcep=yes
grant proxynode target=TSM_Client01_SQL agent=TSM_Client01
3) Configure Data Protection for SQL Server on TSM_Client01
Query the tdp, tsm and sql to confirm everything works fine. Ensure you login account with the admin permission of the server and SQL.
4) Restart TSM_Client01 to finish the installation.
Jackie Chen's IT Workshop 
Hey Jackie,
I just started playing with 6.4 and I keep receiving these errors:
ACO5098E Error obtaining VSS information from Local DSMAgent Node: ‘MY_WINDOWS_NODE’.
ACO0520E Failed to connect to Local DSMAGENT Node ‘MY_SQL_NODE’ at addressort ‘SERVER.TEST.TESTWORLD.com:56230’. Verify that the TSM Client Acceptor Daemon (CAD) is installed, configured, and running properly.
Completed
My CAD service is installed and started and my proxy’s are setup properly… Not sure what I’m doing wrong at this point. Did you run into this?
Brian
I should also mention that I receive this when running QUERY SQL in the automate tab.
Is it possilbe a firewall issue? if there is no firewall, I suggest you double check your configuration again. As this is a simple steps, no tricks at all.
Hi Jackie! How are you ?
It is possible to re register tdp on another TSM server ? I’ve changed connection for TSM client, also have changed on TSM server password for sql node client, and have changed password on TDP.
When execute tdpslc q tsm I’m viewing old server connection. Its needed to reboot server or something ?
Hi Federico, I don’t see why you can not. Just remember to change the TCPServeraddress to the new TSM server in the tdp option file. And follow the same steps to register the node to the new TSM server.
Jackie! Thanks for your reply.
I’ve updated TSM client and TDP to ver 6.3.
Weird issue with licensedpsql_enu. Fixed. Now, when I try to access DB on gui, mmc crash and report the following on applog:
Application: mmc.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.AccessViolationException
Stack:
at .nlprintf(Int32, …)
at .TdpSqlApi.Initialize(TdpSqlApi*, Int32, SByte**)
at DpSqlEngine.CapabilityManagerSql.Initialize(System.String[], Capability.Contracts.Common.TSMLoginInfoCheck)
at DpSqlEngine.CapabilityManagerSql.GetSqlBackupItemInfo(Capability.Contracts.Sql.ISqlContext)
at Fm.Ux.Workloads.SQL.Forms.UserSqlBackup.GetDbInfoByDbNames(Capability.Contracts.Sql.ISqlContext)
at Fm.Ux.Workloads.SQL.Forms.UserSqlBackup.PopulateDisplayBackgroundWork(Fm.Tasks.WorkloadTask)
at Fm.Tasks.TaskSample+c__DisplayClass3.b__1(System.Object)
at System.Threading.Tasks.Task.Execute()
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(System.Threading.Tasks.Task ByRef)
at System.Threading.Tasks.Task.ExecuteEntry(Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
at System.Threading.ThreadHelper.ThreadStart()
Application: .net
Faulting application name: mmc.exe, version: 6.1.7600.16385, time stamp: 0x4a5bc808
Faulting module name: MSVCR100.dll, version: 10.0.40219.1, time stamp: 0x4d5f034a
Exception code: 0xc0000005
Fault offset: 0x00000000000b2650
Faulting process id: 0x1380
Faulting application start time: 0x01ce4cc45e088b25
Faulting application path: C:\Windows\system32\mmc.exe
Faulting module path: C:\Windows\system32\MSVCR100.dll
Report Id: a15cbf95-b8b7-11e2-893d-0050568b5e2d
Checking on forums, but no luck. Did you see something like that ?
Thanks in advance.
Clear your event log if it is full.
If clearing event log does not fix your problem. Check the trace file – C:\program files\tivoli\flashcopymanager\TraceFm.trc, TraceFmPrev1.trc for more details.
FYI:
Examples of Tivoli Storage FlashCopy Manager default log and trace files:
Installation directory: c:\program files\tivoli\flashcopymanager
dsierror.log
fcm.log
TraceFm.trc
TraceUx.trc
TraceManagedCapacityHistory.trc
TraceSchedLaunch.trc
VssProvisioning.log
TraceFileFS.trc
TraceFileExc.trc
TraceFileSql.trc
Examples of Tivoli Storage FlashCopy Manager for SQL default log and trace files:
Installation directory: C:\Program Files\Tivoli\TSM\TDPSql
dsierror.log
tdpsql.log
Examples of Tivoli Storage FlashCopy Manager for Exchange default log and trace files:
Installation directory: C:\Program Files\Tivoli\TSM\TDPExchange
dsierror.log
tdpexc.log
Examples of VSS Requestor default log and trace files:
Installation directory: C:\Program Files\Tivoli\TSM\baclient
dsmerror.log
Examples of trace logs and scripts to quiesce custom applications:
Default directory: %ALLUSERSPROFILE%\Application Data\Tivoli\FlashCopyManager\
You can try SQLgzip to do direct backup from SQL Server to TSM. You don’t need TDP license at all and installation is simple unzipping a folder. And the most important 32-bit version of this product is free !
I am having the same issue (?) when trying to do a full database restore to an alternate location. I am assuming the attempt to do the restore has failed due to the file not being on the server or in a location that this sql instance does not have access to. The Client acceptor agent (flash copy manager ?) did not copy or accept the file I assume. any thoughts?
1st error message:
Failed – An exception occurred while executing a Transact-SQL statement or batch. Cannot open backup device ‘TDPSQL-000003D0-0000’. Operating system error 0x80070002(The system cannot find the file specified.).
RESTORE DATABASE is terminating abnormally.
Changed database context to ‘master’. (HRESULT:0x80131501)
2nd error
tdpsqlc Query TSM * /FROMSQLSERVer=* /QUERYNode=DP /COMPATibilityinfo /ACtive
Failed – ACO0520E Failed to connect to Local DSMAGENT Node ‘24799595-10’ at address:port ‘192.168.69.44:49326’. Verify that the TSM Client Acceptor Daemon (CAD) is installed, configured, and running properly.
How do you start this application on Server 2012. the icon , “DP for SQL Management Console” doesn’t existing. how do you I start the mmc from a command line?
If you have installed it correctly, it should be there – “C:\Program Files\Tivoli\FlashCopyManager\FlashCopyManager.exe”, double click it to run. Or type ‘mmc’ in the command line then open ”C:\Program Files\Tivoli\FlashCopyManager\FlashCopyManager.msc”
hello, I received this errors after configurind my DP, do you know how can I solve them?
ACO5098E Error obtaining VSS information from Local DSMAgent Node: ‘WIN-KOH7H9IVKML’.
ACO0515E Invalid DSMAGENT Node configuration found for node ‘WIN-KOH7H9IVKML’.
Double check your option file.
the dsm.opt file? or which? what does that file should contain?
Hi Jackie C.
There is a away to point out other dsm.opt in DP MMC console.
In old fashion away you can do that by adding in shortcut target option the following:
/tsmoptfile
HI SIR\MAM I M ROHIT SAHU
i download tdpsql in ibm fix pack site i install tdpsql software but i did not get sqlclient.lic file if u dont mind if u have sqlclient.lic file can u send me my
mail id :- rohitsh950@gmail.com
or suggest me where can i download tdpsql and tdpsql.lic file
Thanks and Regards
ROHIT KUMAR SAHU