Re: Logging details in SQL Server 2005 Maintenance Plan

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You might want to report a bug for this:
http://lab.msdn.microsoft.com/productfeedback/default.aspx

--
Andrew J. Kelly SQL MVP


"Michelle" <Michelle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ADA33443-4813-45C6-A2DA-5697B038504B@xxxxxxxxxxxxxxxx
> More info on problem...
> Noticed this occurred when using the Maint Plan wizard and then adding
> steps
> to it afterward. Does not occur when you run the Maint Plan vanilla
> without
> ever editing it. There needs to be a solution for this. Who uses
> Maintenance Plans vanilla?
>
> "Michelle" wrote:
>
>> In setting up maintenance plans in SQL 2005, I am unable to get the
>> maintenance plans to log the details. Under the "Reporting and Logging"
>> dialog, I do have "Log Extended Information" checked. All I get in the
>> log
>> file is:
>>
>> Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.1399
>> Report was generated on "A0040SDev".
>> Maintenance Plan: System DB MaintenancePlan
>> Duration: 00:00:00
>> Status: Succeeded.
>> Details:
>>
>> No Details......
>>
>> Where and how in SQL 2005 do I make sure that the details are logged in
>> the
>> log file?


.

Relevant Pages

  • Re: SQL 2000 - Databases getting backed up multiple times
    ... I called ARCServe and they agreed that we don't need both the native SQL ... Maintenance Plans backing up our logs and databases in addition to ARCServe. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 deleting old backups
    ... There were several issues with the maintenance plans and SP2. ... Loading SP2 was not enough, you need to load some hotfixes etc to fix all the crap that SP2 broke. ... A client of ours has SQL Server 2005 with the latest service pack. ... the subplans in the database maintenance plans is to delete old backup files ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL 2000 Maintenance Plan Email Notifications
    ... Andrew J. Kelly SQL MVP ... > client open, frequently locks up, won't work in a clustered environment, ... > notifications can break if you start editing your maintenance plans. ...
    (microsoft.public.sqlserver.setup)
  • Re: Maintenance PLan recommendation
    ... I use maintenance plans ONLY for transaction log backups. ... all other tasks I write SQL scripts and schedule them manually. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: PerfMon recording to SQL 2005
    ... I've been out of the SQL world for a couple years so dusting ... A System DSN, specifying windows authentication, and change to an ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
    (microsoft.public.sqlserver.server)