Re: Backing up more that one instances on the same SQL 2 000 server
2005-06-13 15:14:23
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread> |
- Re: Backing up more that one instances on the same SQL 2 000 server,
Steve Schaub <=
|
|
|