Guide for TSM TDP client
Contents
1. S S MAINSERY H E master H model H E mortenk H msdb d Production Full i Oli NITE Ia Guin OSE Backup Type __State__ Date__ Time __ Backup Size Stipes Cluster Objectid _ Data Space Allocated Data Space Used _Log Space A win Active 03 26 2007 22 34 24 5 022 425 6 bs a BSA AA S 2 Relocate You need to repeat this procedure for all the items it has selected else the restore will come out with an error The restore into and relocate names have to be the same on all the items Data Protection for Microsoft SOL Server2. K B 46 7 00KB Truncate log on checkpoint For Help press Fl Schedule Install the schedule by running the following command C program files tivoli TSM baclient dsmcutil inst name Netgroup TSM MSSQL Scheduler autostart yes eventlogging no node lt Nodename gt clientdir C Program Files Tivoli TSM baclient optfile C Program Files Tivoli TSM TDPSql dsm opt password lt password gt startnow yes Restore Run the client C Program Files Tivoli TSM TDPSql tdpsql exe Click on the restore databases tab Data Protection for Microsoft SQL Server H SQL Servers Fomtin lime Notin use If you want to see the inactive versions click in show active and inactive Data Protection for Microsoft SQL Server H E SQL Servers Pomntin lime otin use Browse through the tree on the left side til you find the database you want restored Click on the newest log file backup it will by it self choose what is needed to make the full restore Data Protection for Microsoft SQL Server E E MAINSERY H E master H model aay i monerk T StowAciveandincie Ta G msdb a a Point in lime Wotin use By default it will restore into the location it came from This can be changed by right clicking on the log file and choose Relocate enter a new location you also need to do this for the option Restore into Data Protection for Microsoft SQL Server H E 5QL Servers
3. Quick user guide for MSSQL agent on TSM Installation You need the regular TSM agent installed first Get and install the client from http mirror netgroup dk tsm Go to TSM Clients Navigate to TDP directory gt Mssql and chose the newest version that matches your operating system Run the exe file Location to Save Files Where would you like to save your files ciitsmn_imnagesiIBM Tivoli Storage Manager for Databases MS SOL Clients oe Imstalsnield InstallShield Wizard Complete The InstallShield Wizard has finished installing JEM Tivoli Storage Manager for Databases MS SOL Clients on your computer To est the wizard click Finish Run C tsm_images IBM Tivoli Storage Manager for Databases MS SQL Clients TDPSQL win32 client setup exe And click through the installation Choose Setup Language Gg X Select the language for this installation from the choices below mea Welcome to the InstallShield Wizard for IBM Tivoli Storage Manager for Databases MS SOL The InstallShield Ri Wizard will allow you bo repair or remove IBM Tivoli Storage Manager for Databases MS SOL To continue click Mes License Agreement Please read the Following license agreement carefully NOTICE By clicking onthe Accept button you are accepting two separate license agreements as a matter of convenience one for evaluating the program and one that applies only if you acquire the program after your e
4. dsm opt Open dsm opt SNODENAMES change it to the backup username provided by Netgroup STCPPORTS change it to the tcp port provided by Netgroup Save the file sqlfull cmd mssql template txt as C Program Files Tivoli TSM TDPSql sqlfull cmd Save the file sqllog cmd sample mssaql txt as C Program Files Tivoli TSM TDPSql sqllog cmd First backup Run the client C Program Files Tivoli TSM TDPSql tdpsql exe If there is an error about the language click ok click edit gt configuration gt Regional gt under Language click English Select all the databases and click backup It will prompt you for a password type in the password you were given for this node Data Protection for Microsoft SQL Server q 10 x File Edit View Utilities Help e HEg TDP Backup l ee i SOL Ser Backup Databases Backup Groups Files Restore Databases Restore Groupe Files E Backup Type Hi i f Full Differential C Log s y moa eB o A Backup Options S edb Stripes Diff Est Chg Log Est Chg 3 Northwind fi a 20 T Truncate Log 0 E Eaj E z nybase a Mame Space used Log space used Compatibilit Attributes Ea pubs master 15 94MB 7EB 00KB System Database Truncate log on ck model 640 0066 250 00K 6 System Database morten 1 024 00KB 368 00K B mdb 11 25M B 794 00KB System Database Truncate log on ck Northwind 2 600 00KB F149 00K 6 Truncate log on checkpoint Select in nybase 1 024 00KB 360 006 pubs 1 280 00
5. valuation is completed The complete text of each of these two license agreements follow International License Agreement for Evaluation of Programs Part 1 General T erms BY DOWNLOADING INSTALLING COPYING ACCESSING OR USING THE DOGO ART WATT ADCC TO TUG TROIS AG TOUTS ACODERACHIT IG OTT ADT Ido not accept the terms in the license agreement Installshield Print lt Back Cancel L El Destination Folder Click Mest ko install to this Folder or click Change to install to a different Folder Install IBM Tivoli Storage Manager For Databases MS SOL to ca C Program Files Tivoli TSM Change Installshield Ready to Install the Program The wizard is ready to begin installation Click Install to begin the installation IF you wank to review or change any of your installation settings click Back Click Cancel to exit the wizard Installshield Cancel a IBM Tivoli Storage Manager for Databases MS SOL InstallShield Wizard xj InstallShield Wizard Completed The InstallShield Wizard has successfully installed IBM Tivoli Storage Manager For Databases MS SOL Click Finish to exit the wizard Configuration Get the template files from http mirror netgroup dk tsm Go to TSM Templates Navigate to TDP directory gt Mssql and download the templates you need Save the file dsm opt mssql template txt as C Program Files Tivoli TSM TDPSql
Download Pdf Manuals
Related Search