Hi all,
Env: Win 2000, SQL 2000, TDP SQL 2.1
I have two SQL server instances on one machine and want to backup both of
them. In TDP GUI I see first instance only (OK, this is known feature).
There is in TDP doc noted that it is possible backup databases of all
instances, but I cannot get this. I have two management classes, META_DATA
for meta data backups, DATA_LOGY for backup databases and transaction logs.
INCLUDE "\...\meta\...\*" META_DATA
INCLUDE "\...\data\...\*" DATA_LOGY
INCLUDE "\...\meta\...\log*" META_DATA
INCLUDE "\...\data\...\log*" DATA_LOGY
I perform full backups every day:
%sql_dir%\tdpsqlc backup * full /tsmoptfile=%sql_dir%\dsm.opt
/logfile=%sql_dir%\sqlfull.log >> %sql_dir%\sqlsched.log
but only dabases of first instance is backed up.
What is wrong?
Any help will be appreciated.
Tom
|