- Tsm 4 connecting to server install#
- Tsm 4 connecting to server update#
- Tsm 4 connecting to server full#
%sql_dir%\tdpsqlc backup * full /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqlfull.log > %sql_dir%\sqlsched.log Rem Note: You can change “sqlsched.log” and “sqlfull.log” to Rem In this example, we use the ‘*’ to back up all of the databases Rem /sqlpassword options on the command below. Rem not been stored via the GUI, you must also specify the /sqluser and Rem If SQL authentication is being used and the SQL login settings have Rem Replace “srvrname” with the name of the options file name you Rem Now call the command-line interface to do the backup: Rem Note: You can change “sqlsched.log” to whatever you prefer in Rem The two lines below put a date/time stamp in a log file for you. Set sql_dir=C:\Progra~1\Tivoli\TSM\TDPSql Rem directory that you chose when you installed the product.
Tsm 4 connecting to server update#
Update the directory to match the installation Rem Replace “C:” with the drive where Data Protection for SQL Rem the IBM Tivoli Storage Manager server.
Rem Manager central scheduler in response to a defined schedule on Rem This file is meant to be executed by the IBM Tivoli Storage Rem backup of all SQL databases to an IBM Tivoli Storage Manager Rem Sample command file containing commands to do a scheduled full I want a full backup of the database followed by a log backup every OFF The dsm.opt file under C:\Program Files\Tivoli\TSM\TDPSql should be like this:ģ) Create a batch file named sqlfull.cmd under C:\Program Files\Tivoli\TSM\TDPSql\ (there is a sample file sqlfull.smp in the same foder).
Tsm 4 connecting to server install#
The log backup only can be done after a Legacy full or differential backup.ġ1) After the full backup completed, right click the database and choose Legacy and Log backup.ġ) Login into TSM_Client01 and run C:\Program Files\Tivoli\TSM\TDPSql\tdpsqlc.exeĢ) Choose the database and run a Legacy Full backupģ) Choose the database and run a Legacy Log backup.ġ) Login into TSM_Client01 to install client scheduler (you still need to do so if there is an existing one for the normal BA client)Ģ) Follow the steps described before, and name it TSM SQL Client Scheduler Right click the DB and choose properties.ĩ) Click ‘Show Backup Options’ then change the value to ‘True’ in Truncate field.ġ0) Right click the database and choose Legacy Full backup. Open the SQL management studio, and run the following SQL query against the System Database to find it out.Ĩ) Change the recovery mode to Full of the database that I am going to backup the log. To truncate log, a log backup has to be done.ħ) Any DB with ‘Truncate log on checkpoint’ attribute means the log only can be truncated by SQL server itself. The Log size is almost same, this is because the VSS Full backup does truncate the logs. In my example, I make TSM as the only backup destination.Ĥ) Configure a SQL login account with sysadmin right in SQL server.ĥ) Right click the DB name and choose Full Backup.Ħ) After the full backup completed. Right click the SQL server and choose propertiesģ) Configure the VSS Policy Binding based on your needs. Legacy backup does not have much limits, and it is the default backup method in the tdpsqlc command.Įxample 1: Use DP For SQL Management Consoleġ) Login into TSM_Client01 and launch DP For SQL Management Console (it requires flash copy manager license).Ģ) I will start with flash copy manager. VSS backup supports instant restore (volume level), fast restore (file level), but it only can restore the data to the server with same name. VSS backup only supports Full, Legacy backup supports Full, Differential and Log.
There are two types of backup method in Tivoli Data Protection for SQL Sever: VSS and Legacy.
0 kommentar(er)
