SQL Server Community Blogs

For SQL 2005 SP2 this report is displaying incorrect information under the Maintenance section. I have a SQL 2005 database that is in simple mode. This report is displaying the results for last full backup under last differential backup row. The results for last differential backup is showing under last full backup row. Also the column alignment when results are returned for any of the 4 last backup rows should be left justified instead of right justified. Under Space Allocated section, the text written inside the gray bar should be left justified. If you have a small amount of used use for tlog, the text is overrunning into the blue bar area.

Thanks jjones. The latest version fixes your bug.

I got a "Root Element is Missing" XML error when I tried to run this report. I am running SP2

Great, great stuff, Simon - thanks for sharing :) I added a link to this to my own SQL Server 2005 Custom Reports repository: http://forums.learnsqlserver.com/SqlServerTopic109.aspx. By the way, this darn textbox of yours does not allow the ENTER key or the ARROW keys to work!

err can i ask something a bit newbie please - how do you run this or add this in 2005 ? Thanks Mo

To use this report it. Download it to a location on your machine. Then in SSMS right click on a database, select reports and then custom reports. You can then select the report you have downloaded and heh presto

Do you have a version of this report that runs against 2000 databases?

This is awesome!! Thanks Simon!! =)

guys I have download it but idont know what next please help what do i have to do. Thanks