Graham, There are a number of different ways to do this. The main thing to remember is that you will need to use the "/SQLSERVER=<sql-server-inst-name>" option when communicating with the different instances of the SQL Server. The Data Protection for SQL licensing is based upon the number of CPUs in the machine, not the number of instances. You should use different TSM NODENAMEs to keep the data separate. You can share the same .CFG file and just specify the /SQLSERVER option on the command, or you can have different .CFG files. The same is true for the log files and scripts. It is very flexible and really depends on how "separate" you want to keep the instances.
Maybe some subscribers on this list with this SQL Server configuration will share what they have done in their environment? Thanks, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <[email protected]> wrote on 06/16/2005 09:52:36 PM: > Guys and gals, > > I have a Windows 2003 server running multiple instances of MSSQL (for some > reason - I am not the DBA). I have configured a single MSSQL server backup > through a TDP before, but never multiple instances. Has anyone done this > before and can offer a hand? I am assuming I need a new set of CFG files, > log files and scripts to kick off the backups, but will I need new > versions of dsm.opt, multiple licenses etc.
