TSM 6.3: Install Data Protection for SQL Server


1) Double click SetupFCM.exe in the installation package folder, then just follow the wizard.

image

image

image

image

image

image

image

image

image

image

image

image

image

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

image

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

image

3) Configure Data Protection for SQL Server on TSM_Client01

image

image

image

image

image

image

image

image

image

image

image

Query the tdp, tsm and sql to confirm everything works fine. Ensure you login account with the admin permission of the server and SQL.

image

4) Restart TSM_Client01 to finish the installation.

Advertisements

18 thoughts on “TSM 6.3: Install Data Protection for SQL Server

  1. 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

      1. 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.

  2. 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 ?

    1. 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.

  3. 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.

    1. 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\

  4. 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 !

  5. 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.

  6. 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?

    1. 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”

  7. 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’.

  8. 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

  9. 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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s