Search String: Display: Description: Sort:

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*SQL\s+Transaction\s+log\s+backup\s+failures\s+for\s+msdb\s+and\s+master\s*$/: 5 ]

Total 5 documents matching your query.

1. SQL Transaction log backup failures for msdb and master (score: 1)
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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-02/msg00442.html (12,962 bytes)

2. Re: SQL Transaction log backup failures for msdb and master (score: 1)
Author: Del Hoobler <hoobler AT US.IBM DOT COM>
Date: Fri, 24 Feb 2006 09:04:58 -0500
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*
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-02/msg00450.html (14,383 bytes)

3. Re: SQL Transaction log backup failures for msdb and master (score: 1)
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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-02/msg00455.html (15,037 bytes)

4. Re: SQL Transaction log backup failures for msdb and master (score: 1)
Author: Del Hoobler <hoobler AT US.IBM DOT COM>
Date: Fri, 24 Feb 2006 10:36:41 -0500
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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-02/msg00456.html (13,274 bytes)

5. Re: SQL Transaction log backup failures for msdb and master (score: 1)
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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-02/msg00465.html (14,234 bytes)


This search system is powered by Namazu