TSM 6.3: Install Data Protection for SQL Server

发牌SO

　　REVOKE PROXYNODE (删除代理节点)
　　1) Double click SetupFCM.exe in the installation package folder, then just follow the wizard.

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb46.png?w=388&h=157

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb47.png?w=508&h=383

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb48.png?w=507&h=471

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb49.png?w=507&h=471

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb50.png?w=507&h=471

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb51.png?w=507&h=471

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb52.png?w=507&h=471

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb53.png?w=507&h=471

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb54.png?w=508&h=383

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb55.png?w=508&h=385

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb56.png?w=508&h=383

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb57.png?w=508&h=383

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb58.png?w=508&h=383

　　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

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb59.png?w=601&h=174

　　Register TSM_Client01. In my example, I have already registered it the previous tests.
　　register node TSM_Client01
　　update node TSM_Client01 backdelete=yes forcep=yes
　　Register TSM_Client01_SQL as SQL backup proxy node.
　　register node TSM_Client01_SQL  domain=SQL
　　update node TSM_Client01_SQL backdelete=yes forcep=yes
　　grant proxynode target=TSM_Client01_SQL agent=TSM_Client01

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb60.png?w=644&h=216

　　3) Configure Data Protection for SQL Server on TSM_Client01

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb61.png?w=254&h=96

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb62.png?w=804&h=603

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb63.png?w=804&h=603

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb64.png?w=804&h=603

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb65.png?w=804&h=603

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb66.png?w=804&h=603

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb67.png?w=804&h=603

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb68.png?w=804&h=603

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb69.png?w=804&h=603

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb70.png?w=804&h=603

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb71.png?w=804&h=603

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

http://jackiechendotorg.files.wordpress.com/2012/06/image_thumb72.png?w=1088&h=751

　　4) Restart TSM_Client01 to finish the installation.