tsm备份sqlserver.doc

北京市太极华青信息系统有限公司 SQLSEVER+TSM系统备份管理实施过程1：安装环境:说明:1. 客户要求系统需要每天使用增量备份方式来备份其Sql server 2000的数据库2. 安装过程需要举办齐全的软件(包括Tivoli Storage Manager Data Protection for SQL server; Tivoli Storage Manager V5.4 client for windows; Tivoli Storage Manager V5.4 server for windows)主机名IP地址系统版本数据库版本SQL服务器4Windows server 2003Microsoft SQL Server 2000TSM服务器67Redhat linux2.实施过程:Tsm配置部分:1. 下面是安装tsm server v5.4 for windows安装如下: 点击setup.exe点击确定点击安装产品安装次序为1.安装TSM服务器,2.TSM服务器许可证.3.TSM语言包(可选.一般不选也可以).TSM设备驱动程序是有带库的时候需要额外安装安装过程略!Step2.安装Tivoli Storage Manager client V5.4 for windows(注:使用Tivoli Storage Manager client管理server必须选择管理客户机命令行组件)Step3.安装Tivoli Storage Manager Data Protection for SQL server+安装语言包laguage,默认环境语言是chinese的!按照之前安装server的方式安装Tivoli Storage Manager Data Protection for SQL server安装后在开始-程序中会看到Tivoli Storage Manager选项-选项里面有Data Protection for SQL serverStep4.配置Tivoli Storage Manager client V5.4 for windows客户端使用管理控制台管理TSM SERVER!配置tsm client使用GUI步骤如下:进入程序-Tivoli Storage Manager-备份归档 GUI-选择Setup Wizard注意:该名称一定要在tsm server存在才可以连接选择TCP/IP协议方式连接tsm server端填入tsm server端的IP和端口配置成功会有login界面进入2.配置Tivoli Storage Manager Data Protection for SQL server环境tsm server的环境已经配置好了,现在开始配置Tivoli Storage Manager Data Protection for SQL server环境:进入C:Program FilesTivoliTSMTDPSql目录下并找到tdpsql.exe文件,双击该文件出现如下画面(或者在程序里面找到sql client GUI)上面的画面是tdpsql.exe的GUI备份管理器for sqlserver的我们可以看到该画面显示的左边框中有一个TDP备份分支下面有一个SQL Server的图标不难看出这个是可以手动备份SQL Server的工具!在我们需要备份该数据库之前需要配置Tdpsql.exe与tsm server之间的联系,配置如下图:鼠标点击编辑-然后配置;出现一个下面的对话框常规配置我们在SQL Server:填写SQL Server服务器对应的IP(注意:如果用dns可以不填写)而从SQL Server:填写SQL server的对应的IP(注意:如果用dns可以不填写)我们点击性能这里可以为tdpsql.exe和tsm server之间的调优选项这里的日志文件名称目录默认在C:Program FilesTivoliTSMTDPSql下的,我们可以在此目录看到tdpsql.exe所操作过的历史纪录以及报错信息至于区域,我们语言这一项默认在中文的windows server系统是中文的就是中文语言,所以如果不安装语言包就会报错,如果报错最好还是选回english(EN)自动化任务配置.先设置好C:Program FilesTivoliTSMTDPSqldsm.opt或者其实我们在图形界面配置tdpsql.exe的时候已经设置好了,*=* * IBM Tivoli Storage Manager for Databases * * Data Protection for Microsoft SQL Server * * Sample Options File * *=*NODename sqltest /改成你安装client的时候写的客户端的名称CLUSTERnode NOPASSWORDAccess Generate*=* TCP/IP Communication Options *=*COMMMethod TCPipTCPServeraddress 64 /tsm 服务器不用更改TCPPort 1500TCPWindowsize 63TCPBuffSize 32*=* Named Pipes Communication Options *=*COMMMethod NAMEdpipe*NAMedpipename .pipetsmpipe*=* - Compression Options * * Use the COMPRESSION option to compress the data before sending * it to the IBM Tivoli Storage Manager server. Use the * COMPRESSALWAYS option to specify whether to continue compressing * the data if it grows during compression. * *=*COMPRESSIon NO*COMPRESSAlways NO*=* * - Scheduling Options * * The default scheduling mode is the client polling method. * To use server prompted scheduling, you must be sure to use a tcp * client port different than the one used by the regular backup * client. * *=*SCHEDMODE Polling*SCHEDLOGRetention 14*SCHEDMODE Prompted*TCPCLIENTADDRESS yy.yy.yy.yy*TCPCLIENTPORT 1502*=* Include/Exclude Processing * * For a more complete description of include/exclude processing refer * to the Data Protection for Microsoft SQL Server Installation and * Users Guide. *=*=* The following include statements assign all meta objects to * management class SqlDbMetaMgmtClass and all data objects to * SqlDbDataMgmtClass * *=*INCLUDE .meta.* SqlDbMetaMgmtClass*INCLUDE .data.* SqlDbDataMgmtClass*=* The following include statements assign all log meta objects to * management class SqlLogMetaMgmtClass and all log data objects to * SqlLogDataMgmtClass * *=*INCLUDE .meta.log* SqlLogMetaMgmtClass*INCLUDE .data.log* SqlLogDataMgmtClass*=* The following exclude statements exclude all log backups for * databases master and msdb *=*EXCLUDE .master.log*EXCLUDE .msdb.log* *=* The following exclude statement excludes the db1 database * from being compressed (if compression is enabled for backups.) *=*EXCLUDE.COMPRESSION .db1.*自动化备份设置首先在C:Program FilesTivoliTSMTDPSqlsalary_tzh001.smp创建这个文件用来备份SALARY_TZH001这个库，文件的内容如下： ECHO OFFrem =rem sqlfull.smp sample command fileremrem Sample command file containing commands to do a scheduled fullrem backup of all SQL databases to an IBM Tivoli Storage Managerrem server.remrem This file is meant to be executed by the IBM Tivoli Storage rem Manager central scheduler in response to a defined schedule on rem the IBM Tivoli Storage Manager server.remrem =rem =rem Replace C: with the drive where Data Protection for SQLrem is installed. Update the directory to match the installationrem directory that you chose when you installed the product.rem =set sql_dir=C:Progra1TivoliTSMTDPSqlC:cd %sql_dir%rem =rem The two lines below put a date/time stamp in a log file for you.rem Note: You can change sqlsched.log to whatever you prefer in rem lines below.rem =date %sql_dir%sqlsched.logtime %sql_dir%sqlsched.logrem =rem Now call the command-line interface to do the backup:remrem Replace srvrname with the name of the options file name yourem plan to use.remrem If SQL authentication is being used and the SQL login settings haverem not been stored via the GUI, you must also specify the /sqluser and rem /sqlpassword options on the command below.remrem In this example, we use the * to back up all of the databasesrem on the SQL server. Note that database tempdb will notrem be backed up. rem rem Note: You can change sqlsched.log and sqlfull.log torem whatever you prefer.rem =%sql_dir%tdpsqlc backup SALARY_TZH001 full /tsmoptfile=%sql_d