<TABLE BORDER=0 ALIGN=CENTER WIDTH=85%><TR><TD><font class="pn-sub">Quote:</font><HR></TD></TR><TR><TD><FONT class="pn-sub"><BLOCKQUOTE>Hi,
I've installed a MSSQL database server with Tivoli and the TDP for MSSQL on it. I've scheduled a daily differential backup and everything is working fine. :grin:
Now I would like to also schedule a weekly full backup. How can I do that? A node can only have one client option set, I presume?
(the SQL backup starts in the preschedulecmd of the client option set)
I know it's possible, but i can't find how :sad:
Thanx in advance!!!</BLOCKQUOTE></FONT></TD></TR><TR><TD><HR></TD></TR></TABLE>
Hi ... I am backing up a cpl of sql servers via tivoli and i took a differnt approach. created 2 command files and placed um in the root of the C: drive. one does a log backup and the other does a full backup. I call them by creating schedules on the server using the "command" call. I didn't use the client options file with pre and post commands.
Here is an example cmd file for a log backup script and u can just substitue full for log where needed. Hope this helps.
@ECHO OFF
rem ==================================================================
rem sqllog.smp sample command file
rem
rem Sample command file containing commands to do a scheduled log
rem backup of all SQL databases to an IBM Tivoli Storage Manager
rem server.
rem
rem 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.
rem
rem ==================================================================
rem ==================================================================
rem Replace "C:" with the drive where Data Protection for SQL
rem is installed. Update the directory to match the installation
rem directory that you chose when you installed the product.
rem ==================================================================
set sql_dir=C:\Progra~1\Tivoli\TSM\TDPSql
C:
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 < NUL >> %sql_dir%\sqlsched.log
time < NUL >> %sql_dir%\sqlsched.log
rem ==================================================================
rem Now call the command-line interface to do the backup:
rem
rem Replace "srvrname" with the name of the options file name you
rem plan to use.
rem
rem If SQL authentication is being used and the SQL login settings have
rem not been stored via the GUI, you must also specify the /sqluser and
rem /sqlpassword options on the command below.
rem
rem In this example, we use the '*' to back up all of the databases
rem on the SQL server. Note that database 'tempdb' will not
rem be backed up.
rem
rem Note: You can change "sqlsched.log" and "sqlfull.log" to
rem whatever you prefer.
rem ==================================================================
%sql_dir%\tdpsqlc backup * log /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqlfull.log >> %sql_dir%\sqlsched.log