Hello,

We have a maintenance plan with several tasks. The logging have Log extended
information checked. The maintenance seems to be performing right, but the
log file has not detail information
Log:
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.1399
Report was generated on "COU00169V".
Maintenance Plan: Gesfor Diario
Duration: 00:00:00
Status: Succeeded.
Details:

Could anyone tell me how can I get the extra information: what tasks have
been carried out, how long for, ...

Thanks in advance,

Carmen.

Version: Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005
00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition
on Windows NT 5.2 (Build 3790: Service Pack 2)

Tasks in Maintenance Plan:
- Check database integrity
- Shrink database
- Reorganize index
- Rebuild index
- Update statistics
- Clean up history
- Back up database (full)
- Maintenance cleanup task

Open the maintenance plan folder, right-click on the maintenance plan and
View History.

BTW - you need to remove the Shrink Database task as that is just going to
cause problems. Furthermore, you should either reorganize your indexes or
rebuild them, not both as that is just a waste of time and resources.
Additionally, if you rebuild indexes - statistics will be updated during the
rebuild and you wouldn't need the update statistics task.

And finally, if any of your databases are setup in full recovery model - you
will need another maintenance plan or another sub-plan in this maintenance
plan that backs up the transaction log on a regular basis (e.g. every hour).

Jeff

"Carmen" <Carmen (AT) discussions (DOT) microsoft.com> wrote