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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Del Hoobler
Sent: Friday, February 24, 2006 9:37 AM
To: ADSM-L AT VM.MARIST DOT EDU
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" <ADSM-L AT VM.MARIST DOT EDU> 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:ADSM-L AT VM.MARIST DOT EDU] On Behalf
Of
> Del Hoobler
> Sent: Friday, February 24, 2006 8:05 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> 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.