[ADSM-L] TDP SQL Scheduling with multiple instances

2007-04-10 16:58:29
Subject: [ADSM-L] TDP SQL Scheduling with multiple instances
From: "Bell, Charles (Chip)" <Chip.Bell AT BHSALA DOT COM>
Date: Tue, 10 Apr 2007 15:57:38 -0500
Our Helpdesk guru has a machine called TESTHELPDESKWEB, and on it he has 2
instances of SQL (looks like MSDE).


Anyway, I had already set up backups (with a TDP scheduler) for an instance
called TESTHELPDESKWEB\USERIDS,3948. I had that for the SQLSERVER parameter
in the tdpsql.cfg. Now there is also an instance called TESTHELPDESKWEB,1433.
I'm looking through the TDP docs and Redbooks, but I'm not seeing any
specific documentation on how to back up separate instances. Do I need 2
separate nodes with a scheduler for each? If so, how do I account for the
instance names, now that there are 2 to account for (as I was doing in
tdpsql.cfg)? Thanks, all!


God bless you!!! 

Chip Bell 
Network Engineer I
IBM Tivoli Certified Deployment Professional 

Baptist Health System 
Birmingham, AL 


Confidentiality Notice:
The information contained in this email message is privileged and
confidential information and intended only for the use of the
individual or entity named in the address. If you are not the
intended recipient, you are hereby notified that any dissemination,
distribution, or copying of this information is strictly
prohibited. If you received this information in error, please
notify the sender and delete this information from your computer
and retain no copies of any of this information.