|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Logging details in SQL Server 2005 Maintenance PlanIn 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? 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? Show quote "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? You might want to report a bug for this:
http://lab.msdn.microsoft.com/productfeedback/default.aspx -- Show quoteAndrew J. Kelly SQL MVP "Michelle" <Miche***@discussions.microsoft.com> wrote in message news:ADA33443-4813-45C6-A2DA-5697B038504B@microsoft.com... > 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? Went to report it as a problem. Someone reported as a problem in the Sept
2005 CTP edition. It remains as a problem in the commercially released version. Show quote "Andrew J. Kelly" wrote: > You might want to report a bug for this: > http://lab.msdn.microsoft.com/productfeedback/default.aspx > > -- > Andrew J. Kelly SQL MVP > > > "Michelle" <Miche***@discussions.microsoft.com> wrote in message > news:ADA33443-4813-45C6-A2DA-5697B038504B@microsoft.com... > > 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? > > > Doesn't supprise me<g>. I think there were quite a few features that didn't
make it in RTM in regards to the Maint Plans. -- Show quoteAndrew J. Kelly SQL MVP "Michelle" <Miche***@discussions.microsoft.com> wrote in message news:0E634A83-F895-4503-BBBB-CEEC022A496E@microsoft.com... > Went to report it as a problem. Someone reported as a problem in the Sept > 2005 CTP edition. It remains as a problem in the commercially released > version. > > "Andrew J. Kelly" wrote: > >> You might want to report a bug for this: >> http://lab.msdn.microsoft.com/productfeedback/default.aspx >> >> -- >> Andrew J. Kelly SQL MVP >> >> >> "Michelle" <Miche***@discussions.microsoft.com> wrote in message >> news:ADA33443-4813-45C6-A2DA-5697B038504B@microsoft.com... >> > 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? >> >> >> That's an understatement.
-- Show quoteMike http://www.solidqualitylearning.com Disclaimer: This communication is an original work and represents my sole views on the subject. It does not represent the views of any other person or entity either by inference or direct reference. "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message news:eG0p3TfHGHA.2392@TK2MSFTNGP15.phx.gbl... > Doesn't supprise me<g>. I think there were quite a few features that > didn't make it in RTM in regards to the Maint Plans. > > -- > Andrew J. Kelly SQL MVP > > > "Michelle" <Miche***@discussions.microsoft.com> wrote in message > news:0E634A83-F895-4503-BBBB-CEEC022A496E@microsoft.com... >> Went to report it as a problem. Someone reported as a problem in the >> Sept >> 2005 CTP edition. It remains as a problem in the commercially released >> version. >> >> "Andrew J. Kelly" wrote: >> >>> You might want to report a bug for this: >>> http://lab.msdn.microsoft.com/productfeedback/default.aspx >>> >>> -- >>> Andrew J. Kelly SQL MVP >>> >>> >>> "Michelle" <Miche***@discussions.microsoft.com> wrote in message >>> news:ADA33443-4813-45C6-A2DA-5697B038504B@microsoft.com... >>> > 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? >>> >>> >>> > >  |
|||||||||||||||||||||||
Other interesting topics