Author: "Bell, Charles (Chip)" <Chip.Bell AT BHSALA DOT COM>
Date: Thu, 23 Feb 2006 18:23:24 -0600
I'm getting the following on a particular client... 02/15/2006 15:00:07 Backup of msdb failed. 02/15/2006 15:00:07 ACO5422E Received the following from the MS SQL server: 02/15/2006 15:00:07 [Microso
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*
Author: "Bell, Charles (Chip)" <Chip.Bell AT BHSALA DOT COM>
Date: Fri, 24 Feb 2006 09:26:34 -0600
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 t
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 granular
Author: "Bell, Charles (Chip)" <Chip.Bell AT BHSALA DOT COM>
Date: Fri, 24 Feb 2006 11:14:26 -0600
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 wh