Re: Is it possible to backup up multiple mssql server instances in one command?
2004-12-07 09:29:45
Kjell,
No. This is not possible.
You can have one TSM NODENAME and back it up with
two separate invocations of "tdpsqlc". For example:
tdpsqlc backup * full /sqlserver=.\D01 ...etc...
tdpsqlc backup * full /sqlserver=.\BD1 ...etc...
However, I don't recommend this. I recommend that you have a
separate TSM NODENAME for each SQL Server instance.
Thanks,
Del
----------------------------------------------------
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 12/07/2004
08:29:23 AM:
> Is it possible to backup up multiple mssql server instances in one
> command? Something like:
>
> tdpsqlc backup * full /tsmoptfile=%sql_dir%\dsm.opt
> /sqlserver=.\D01 .\BD1 /logfile=c:\var\log\tsm\sqlfull.log >>
> c:\var\log\tsm\sqlsched.log (I know this one doesn't work, but something
> similar?)
>
> Or is the only solution to have 2 client nodes, one for each instance??
>
> Best wishes
> Kjell Kaspersen
|
|
|