ADSM-L

Backup second SQL instance

2002-05-22 04:28:11
Subject: Backup second SQL instance
From: Tomáš Hrouda <throuda AT HTD DOT CZ>
Date: Wed, 22 May 2002 10:25:49 +0200
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
<Prev in Thread] Current Thread [Next in Thread>