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.