RE: Maintenance Plan for Transaction Logs is failing

From: Sean (sean.faust_at_gmail.com)
Date: 09/21/04 

Date: Tue, 21 Sep 2004 10:05:58 -0700

>-----Original Message-----
>Hi
>
>Is the database is full recovery mode (not simple or bulk
logged)?
>
>Regards
>Mike
>
>"Sean" wrote:
>
>> Good Morning All,
>>
>> I cannot figure out why the maintenance plan for
>> transaction log backups is failing. The plan for the
DB
>> works fine. Below is the error message from the event
log
>> and below that is Step 1.
>>
>> TIA
>> Sean
>>
>> SQL Server Scheduled Job 'Transaction Log Backup Job
for
>> DB Maintenance Plan 'DB Maintenance Plan1''
>> (0xCF8E57D6205B3A4C898152532CCBB6DA) - Status: Failed -
>> Invoked on: 2004-09-20 22:00:00 - Message: The job
>> failed. The Job was invoked by Schedule 12 (Schedule
1).
>> The last step to run was step 1 (Step 1).
>>
>> EXECUTE master.dbo.xp_sqlmaint N'-PlanID E2703225-E616-
>> 4636-B9B3-1EE3A4767763 -Rpt "d:\Program Files\Microsoft
>> SQL Server\MSSQL\LOG\DB Maintenance Plan16.txt" -
DelTxtRpt
>> 4WEEKS -WriteHistory -VrfyBackup -BkUpMedia DISK -
>> BkUpLog "d:\Program Files\Microsoft SQL
>> Server\MSSQL\BACKUP" -DelBkUps 1DAYS -BkExt "TRN"'
>>
>>
>.
>Its a mix. The plan is set to run on all databases.
While the actual production database is set to Full, the
Master database is set to simple. Can I set the Master
database to the Full Recovery Model? Sounds like a dumb
question but anyway....

Thanks, Sean

Relevant Pages

  • Re: Maintenance Plan Caused System To Hang
    ... ran DBCC CHECKDB) I was connected to the server through Terminal Services. ... Even though the server has 2 GB of RAM and is used exclusively for SQL 2005, ... maintenance plan in SQL 2005 and ran it. ... Back up the database and transaction log ...
    (comp.databases.ms-sqlserver)
  • Re: Logging
    ... First thing to consider is your backup strategies. ... If you don't perform transaction log backups, ... the database to simple recovery mode. ... Read more about this in Books Online, simple recovery mode. ...
    (microsoft.public.sqlserver.server)
  • Strategy for a databse
    ... I have some experience with building a database of people, ... regular trips but often also charters of various lenghts. ... I need to plan ... For all these things, and many others I have reports, in Excel format, ...
    (microsoft.public.access.gettingstarted)
  • Re: DBCC Checkdb,
    ... Fehler beim Maintenance Plan mit dem ich leider nichts anfangen kann. ... ich habe zur leichteren Fehlerfindung alle weiteren Step disabled - es ... bleibt nur der erste Step Check Databases über. ... The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances in SQL Server 2005 builds 3042 through 3053 ...
    (microsoft.public.de.sqlserver)
  • Re: Wiki software for genealogy (long)
    ... "When we've ironed out the bugs, this will be the one everyone wants" hands-down over any given 5-year plan of business. ... You can kludge most of 'em into doing the other, and you can even browbeat 'em into doing a migration database, but they won't do 'em as well as a dedicated program will. ... Which is why a first requirement should be for a package, not a single program, to be built around a database for which a decent toolset is available - at the very least for reporting. ... If the data is accessible in that way and the data model is well designed in the first place a whole set of programs can be built round it, either by the vendor or by sufficiently skilled users. ...
    (soc.genealogy.britain)