OK, thank you very much for the link! I think for our purposes, I will continue with a nightly full, exclude the logs for master/msdb, and leave the recovery mode in simple for the db environments where they do not specify a direction. Again, thanks for your help!
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: Friday, February 24, 2006 9:37 AM To: [email protected] Subject: Re: [ADSM-L] SQL Transaction log backup failures for msdb and master Chip, The FULL backups of Simple Recovery Model databases will be all that you need to recover those databases. But... it all boils down to how you want to protect your data and the level of granularity you want for your restore. I recommend that you read up on the SQL Server Recovery Models for details on how they work. Here is a good Microsoft doc to read up on: "Choosing the Recovery Model for a Database" http://msdn2.microsoft.com/en-us/library/ms175987.aspx Thanks, Del ---------------------------------------------------- Del Hoobler Tivoli Storage Manager Development IBM Corporation "ADSM: Dist Stor Manager" <[email protected]> wrote on 02/24/2006 10:26:34 AM: > I had that done at one time, and commented them out for all of our SQL > clients. Those excludes are already in the sample dsm.opt, so does that > mean that they are recommended excludes? If so, I need to go back and > un-comment them all. :) Pardon my ignorance on SQL, but why would you > exclude the logs for master and msdb. Does that affect the full backup? > > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of > Del Hoobler > Sent: Friday, February 24, 2006 8:05 AM > To: [email protected] > Subject: Re: [ADSM-L] SQL Transaction log backup failures for msdb and > master > > Chip, > > How about just excluding those databases from log backups? > You do that by adding this to the DSM.OPT file for > Data Protection for SQL: > > EXCLUDE "\...\master\...\log*" > EXCLUDE "\...\msdb\...\log*" > > Thanks, > > Del > > ---------------------------------------------------- > > Del Hoobler > Tivoli Storage Manager Development > IBM Corporation ----------------------------------------- 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.
