Luc,

Modify your backup script to use a named instance.
Here is what our sqlfull.cmd looks like (first backup catches default
instance, 2nd one is specific):

@ECHO OFF
rem  ====================================================================*
rem  * Command file containing commands to do a scheduled                *
rem  * full backup of Microsoft SQL Server databases to                  *
rem  * TSM storage.                                                      *
rem  ====================================================================*

set exc_dir="C:\Program Files\Tivoli\TSM\TDPSQL"

cd /d %exc_dir%

echo Current date is %date% >> sqlfull.log
echo Current time is %time% >> sqlfull.log

start /B tdpsqlc backup * full /logfile=sqlsched.log >> sqlfull.log
start /B tdpsqlc backup * full /SQLSERVer=croaker\broker
/logfile=sqlsched2.log >> sqlfull2.log

rem  ====================================================================*
rem  * if multiple SQL Server instances are installed, use the following *
rem  * example to perform specific backups on each one                   *
rem  ====================================================================*
rem start /B tdpsqlc backup * full /SQLSERVer=rubicon\crestone
/logfile=sqlsched.log >> sqlfull.log 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Luc
Beaudoin
Sent: Monday, June 13, 2005 2:55 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Backing up more that one instances on the same SQL 2000
server

Hi all
I asked that question last week, but I looked in the documentation and it's
not that clear...

Is there anyone that are doing that ....
Can someone tell me what to do


Thanks

Luc Beaudoin
Administrateur Réseau / Network Administrator Hopital General Juif S.M.B.D.
Tel: (514) 340-8222 ext:8254 
Please see the following link for the BlueCross BlueShield of Tennessee E-mail
disclaimer:  http://www.bcbst.com/email_disclaimer.shtm