Usually, you only have to make changes to FROMSQLServer or SQLServer if it is a MS Cluster or someone named the instance something different than the hostname. Also, some may want to knock LOGPrune down from 60 days.
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Howard Coles Sent: Thursday, March 06, 2008 3:32 PM To: [email protected] Subject: Re: [ADSM-L] tdpsql.cfg Here's the contents (with node names changed to protect the guilty :-): BEGIN FILE: BUFFers 3 BUFFERSIze 1024 FROMSQLserver NODENAME\DBNAME SQLAUTHentication INTegrated SQLBUFFers 0 SQLBUFFERSIze 1024 SQLSERVer NODENAME\DBNAME STRIPes 1 LOGFile tdpsql.log LOGPrune 60 MOUNTWaitfordata Yes DIFFESTimate 20 LASTPRUNEDate 09/11/2007 08:11:31 LANGuage ENU END FILE Someone may see something that could be tweaked, (I haven't looked at these files in a very long time) but this is basically what's working on our SQL Servers (including one 3 node Cluster). See Ya' Howard -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gill, Geoffrey L. Sent: Thursday, March 06, 2008 3:13 PM To: [email protected] Subject: [ADSM-L] tdpsql.cfg I have been looking for a sample tdpsql.cfg to show how things are laid out in this file but have found nothing so far. Sure I could just throw things in it to see if they take but was hoping someone had a link or one they wouldn't mind sending instead. Any help is appreciated. Thanks, Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: [EMAIL PROTECTED] ----------------------------------------- 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.
