Backup and Restore Events Report

In SQL 2005 Management Studio (SP1) at the DB level their is a SSRS
Backup and Restore Events Report which does not show any infromation
for the database even though the database has been backed up and is
showing on the DB properties page. Is their any settings that need to
be changed to show this information in the SSRS report?Is the default trace enabled? (sp_configure)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<robin9876@.hotmail.com> wrote in message
news:1173197849.398089.27250@.c51g2000cwc.googlegroups.com...
> In SQL 2005 Management Studio (SP1) at the DB level their is a SSRS
> Backup and Restore Events Report which does not show any infromation
> for the database even though the database has been backed up and is
> showing on the DB properties page. Is their any settings that need to
> be changed to show this information in the SSRS report?
>|||It's a bug (in the report)
http://connect.microsoft.com/SQLSer...=14811
6
that is fixed in SP2 - and of course in SP2 you can write your own report
:-)
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
<robin9876@.hotmail.com> wrote in message
news:1173197849.398089.27250@.c51g2000cwc.googlegroups.com...
> In SQL 2005 Management Studio (SP1) at the DB level their is a SSRS
> Backup and Restore Events Report which does not show any infromation
> for the database even though the database has been backed up and is
> showing on the DB properties page. Is their any settings that need to
> be changed to show this information in the SSRS report?
>