WOW :-)) Many thanks. I didn't know about this option.
Tom
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Del
Hoobler
Sent: Wednesday, May 22, 2002 6:44 PM
To: [EMAIL PROTECTED]
Subject: Re: Backup second SQL instance
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.
Tom,
Use the /SQLSERVER=instance-name option
to specify the instance to back up.
...where instance-name is the name of the
SQL Server instance to back up.
For example, for the GUI:
tdpsql /SQLSERVER=instance-name
or for the command-line interface:
tdpsqlc backup * full /SQLSERVER=instance-name
If you don't specify the option, it will
back up the default instance.
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
- Leave everything a little better than you found it.
- Smile a lot: it costs nothing and is beyond price.