Backup Error

I saw the following logged in the event log:
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 9/14/2005
Time: 12:20:00 AM
User: N/A
Computer: BRADFORDDC01
Description:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'Master Maintenance Plan'' (0x6FF812A8ED86514CBDF51CE01D6147ED) - Status:
Failed - Invoked on: 2005-09-14 00:20:00 - Message: The job failed. The Job
was invoked by Schedule 9 (Schedule 1). The last step to run was step 1
(Step 1).
The error appears to occur when backing up the transaction log of the
"master" database. I have verified that all of the databases are set to a
recovery mode of "Full," and also added the "-SupportComputedColumn" flag to
the job (as per MS KB). I created a new maintenance plan for the master DB
to isolate the
failing job, and I am still receiving this error, can anyone offer any
insight?
Thanks,
RobRobert,
The transaction log of the Master database cannot be backed up. Use a full
database backup for the Master system database.
HTH
Jerry
"Robert Zahm" <robzahm@.hotmail.com> wrote in message
news:eBgoxEVuFHA.1032@.TK2MSFTNGP12.phx.gbl...
>I saw the following logged in the event log:
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 208
> Date: 9/14/2005
> Time: 12:20:00 AM
> User: N/A
> Computer: BRADFORDDC01
> Description:
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance
> Plan 'Master Maintenance Plan'' (0x6FF812A8ED86514CBDF51CE01D6147ED) -
> Status: Failed - Invoked on: 2005-09-14 00:20:00 - Message: The job
> failed. The Job was invoked by Schedule 9 (Schedule 1). The last step to
> run was step 1 (Step 1).
>
> The error appears to occur when backing up the transaction log of the
> "master" database. I have verified that all of the databases are set to a
> recovery mode of "Full," and also added the "-SupportComputedColumn" flag
> to
> the job (as per MS KB). I created a new maintenance plan for the master
> DB to isolate the
> failing job, and I am still receiving this error, can anyone offer any
> insight?
> Thanks,
> Rob
>
>|||Hi,
You can not backup the trsnaction log backup of Master database. Since you
are not doing any transaction inside Master it is not required
to do a log backup in Master database. It is always if you do a Full
database backup for MASTER database daily once.
It is not good practice to crete tables/ objects in Master database.
Thanks
Hari
SQL Server MVP
"Robert Zahm" <robzahm@.hotmail.com> wrote in message
news:eBgoxEVuFHA.1032@.TK2MSFTNGP12.phx.gbl...
>I saw the following logged in the event log:
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 208
> Date: 9/14/2005
> Time: 12:20:00 AM
> User: N/A
> Computer: BRADFORDDC01
> Description:
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance
> Plan 'Master Maintenance Plan'' (0x6FF812A8ED86514CBDF51CE01D6147ED) -
> Status: Failed - Invoked on: 2005-09-14 00:20:00 - Message: The job
> failed. The Job was invoked by Schedule 9 (Schedule 1). The last step to
> run was step 1 (Step 1).
>
> The error appears to occur when backing up the transaction log of the
> "master" database. I have verified that all of the databases are set to a
> recovery mode of "Full," and also added the "-SupportComputedColumn" flag
> to
> the job (as per MS KB). I created a new maintenance plan for the master
> DB to isolate the
> failing job, and I am still receiving this error, can anyone offer any
> insight?
> Thanks,
> Rob
>
>