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?
It's a bug (in the report)
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=148116
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.googlegro ups.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?
>

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?
>

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/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=148116
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?
>

Backup & Restore encryption key

Hello!

I started Configure Report Server (2005) and have executed backup of the encryption key.

Problem occurred on restore of the encryption key as following error (I have provided correct backup snk):

ReportServicesConfigUI.WMIProvider.WMIProviderException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.8.39'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)

at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.RestoreEncryptionKey(Byte[] encryptedBytes, String password)

ReportingServer sites stop working with similar error (browsing by IE):

The found version is 'C.0.8.39'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

ReportingServer services are all locked by this.

Can you please tell how to resolve this problem?

Thank you very much!

vbrada

It seems your RS installation is a pre-RTM build, but you are using RTM version of the tools. I am not sure about the build number 'C.0.8.39'. It isn't one of the IDW builds. Therefore you may not be able to upgrade it to RTM.

Which build did you install?

|||

Hi!

It is Team Foundation's Reporting Service database (SQL2005 std).

I have not upgraded Reporting Service database.

I have not created or customized any reports.

Team Foundation version is Beta 3 refresh.

I have started a backup of the encryption key by "Configure Report Server" and then detached Reporting Service databases.

Then I attached it back and tried to restore encryption key with error. After database attach back, Reporting site stopped working correctly.

Whole procedure was for testing migration/backup of TFS data to another ATDT server (single server TF).

Thanks!

V.

|||

Using Configuration Manager, try to upgrade the RS Database by clicking the "Database Setup" tab and hitting "Upgrade".

|||We are investigating potential upgrade issues with your installation. I'll post the results when I have them. Sorry for the delay.|||

If this can help...all tasks I have done (and I can remember):

1. Backup of the Reporting encryption key.

2. All SQL servers DB detaching / attaching.

3. Installation of the last two sec. updates (between: 1. feb - 11. feb.)

4. Updating installation of the SQL server...( SQL Manager Studio was missing/not installed in first place)

Also...in prior...backup of the STS_[srvname]_1 database has been failed on:

System.Data.SqlClient.SqlError: The backup of the file or filegroup "sysft_ix_STS_[servername]_1" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

thanks

|||There were a few issues with this as the database versions. But you can manually hack stored procedure GetDBVersion in

ReportSever database to reflect the database version mentioned by the

key

ALTER PROCEDURE [dbo].[GetDBVersion]

@.DBVersion nvarchar(32) OUTPUT

AS

set @.DBVersion = 'C.0.8.39'

Change it back once key is installed

Backup & Restore encryption key

Hello!

I started Configure Report Server (2005) and have executed backup of the encryption key.

Problem occurred on restore of the encryption key as following error (I have provided correct backup snk):

ReportServicesConfigUI.WMIProvider.WMIProviderException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.8.39'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)

at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.RestoreEncryptionKey(Byte[] encryptedBytes, String password)

ReportingServer sites stop working with similar error (browsing by IE):

The found version is 'C.0.8.39'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

ReportingServer services are all locked by this.

Can you please tell how to resolve this problem?

Thank you very much!

vbrada

It seems your RS installation is a pre-RTM build, but you are using RTM version of the tools. I am not sure about the build number 'C.0.8.39'. It isn't one of the IDW builds. Therefore you may not be able to upgrade it to RTM.

Which build did you install?

|||

Hi!

It is Team Foundation's Reporting Service database (SQL2005 std).

I have not upgraded Reporting Service database.

I have not created or customized any reports.

Team Foundation version is Beta 3 refresh.

I have started a backup of the encryption key by "Configure Report Server" and then detached Reporting Service databases.

Then I attached it back and tried to restore encryption key with error. After database attach back, Reporting site stopped working correctly.

Whole procedure was for testing migration/backup of TFS data to another ATDT server (single server TF).

Thanks!

V.

|||

Using Configuration Manager, try to upgrade the RS Database by clicking the "Database Setup" tab and hitting "Upgrade".

|||We are investigating potential upgrade issues with your installation. I'll post the results when I have them. Sorry for the delay.|||

If this can help...all tasks I have done (and I can remember):

1. Backup of the Reporting encryption key.

2. All SQL servers DB detaching / attaching.

3. Installation of the last two sec. updates (between: 1. feb - 11. feb.)

4. Updating installation of the SQL server...( SQL Manager Studio was missing/not installed in first place)

Also...in prior...backup of the STS_[srvname]_1 database has been failed on:

System.Data.SqlClient.SqlError: The backup of the file or filegroup "sysft_ix_STS_[servername]_1" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

thanks

|||There were a few issues with this as the database versions. But you can manually hack stored procedure GetDBVersion in

ReportSever database to reflect the database version mentioned by the

key

ALTER PROCEDURE [dbo].[GetDBVersion]

@.DBVersion nvarchar(32) OUTPUT

AS

set @.DBVersion = 'C.0.8.39'

Change it back once key is installed