Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a SQL 2005 server that needs to be decommissioned. For regular databases, I have a couple scripts that look at sys.dm_db_index_usage_stats to determine last access. My normal process is to make sure the last access date is back quite a while, then take offline and wait to be sure there are no problems before taking a final backup and then deleting the database.

However, since ReportServer and ReportServerTempDB are associated with SSRS, should they be treated differently? Is there an easier way to tell if SSRS is in use?

share|improve this question
1  
Well, you can select the ExecutionLog views that are on the ReportServer database and see if there reports are being executed or not –  Lamak Dec 6 '13 at 19:25
    
If that logs every report execution, I might be good to go. This table in both ReportServer and ReportServerTempDB are both empty. Perhaps they were never used. You should post your coment as an answer! –  SomeGuy Dec 6 '13 at 19:34
    
If I remember correctly it only logs only the 3 last months of the reports execution, not the whole history, though. Here's the link to the documentation of these views: technet.microsoft.com/en-us/library/ms159110.aspx –  Lamak Dec 6 '13 at 19:38
    
Are there reports configured? Do you have any SQL Agent jobs (names are GUIDs)? –  Shawn Melton Dec 6 '13 at 21:05

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.