Re: SQL Transaction log backup failures for msdb and master

2006-02-24 Thread Bell, Charles (Chip)
: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: Friday, February 24, 2006 9:37 AM To: ADSM-L@VM.MARIST.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

Re: SQL Transaction log backup failures for msdb and master

2006-02-24 Thread Del Hoobler
obler > Sent: Friday, February 24, 2006 8:05 AM > To: ADSM-L@VM.MARIST.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

Re: SQL Transaction log backup failures for msdb and master

2006-02-24 Thread Bell, Charles (Chip)
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: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] SQL Transaction log backup failures for msdb

Re: SQL Transaction log backup failures for msdb and master

2006-02-24 Thread Del Hoobler
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 Tivol

SQL Transaction log backup failures for msdb and master

2006-02-23 Thread Bell, Charles (Chip)
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 [Microsoft][ODBC SQL Server Driver][SQL Server]The statement BACKUP LOG is not allowed while the re