How to: find when the database last got restored?

 

   1:  SELECT destination_database_name,max(restore_date) as restore_date

   2:  FROM msdb.dbo.restorehistory 

   3:  WHERE destination_database_name = 'testDB’  ---- Place your database name here

   4:  GROUP BY destination_database_name

The result will look like;

destination_database_name     restore_date

testDB                        2013-04-29 11:49:19.940

How to get .rdl file of the Reports on Report Server

 

Question:

Do you want to have copy of a report on the ReportServer?
What would be the case when, tt was not saved in SourceSafe. Is there a way to get the .rdl file for that report copied to local computer from the ReportServer?

Answer:

For SQL Server 2005 Reporting Services

1. Go to Report on Report Manager
2. Click properties of Report
3. Under the report definition you will see Edit and Update link.
4. if you click on Edit you can open or Save the RDL files

For SQL Server 2008 Reporting Services

1. Go to Report on Report Manager
2. Click properties of Report
3. Select Download on the top right corner
4. Now you can open or Save the RDL files

Can we backup reportservertempdb?

I have been asked by a DBA, if we can backup reportservertempdb, why not!

Here is the answer:

We should backup the database reportservertempdb as we backup the reportserver.

The reason to backup the reportservertempdb is to avoid having to recreate it if there is a hardware failure. In the event of hardware failure, it is not necessary to recover the data in reportservertempdb, but you do need the table structure.

If you lose reportservertempdb, the only way to get it back is to recreate the report server database. If you recreate the reportservertempdb, it is important that it have the same name as the primary report server database.

Error while setting reporting service and share point exclusion path

Encountered the error while installing SQL 2005 Reporting Service "Error while setting reporting service and share point exclusion path"

Product : SQL Server 2005 Reporting Services

Error : The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation.

Resolution:
KB ID # 920803