• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2064
  • Last Modified:

SQL "Starting up database 'ReportServerTempDB'. message

Let me start out by saying I know nothing about SQL Server. I am running SQL 2008 Express for our acounting software and I'm seeing a LOT of messages ( sometimes every few seconds)  in the application log for reporting services, this being one of them:
"Starting up database 'ReportServerTempDB'.

 Is there something I can do to get rid of these, or, more importantly, would this have any affect on performace, because of some configuration setting that is causing the Reporting server to do things more regularly than needed?

Thanks,
CJA
0
cja-tech-guy
Asked:
cja-tech-guy
  • 3
  • 3
2 Solutions
 
venk_rCommented:
Reporting Services automatically "wakes up" every ten minutes or so to check various things. To do this check, it has to query it's databases. When it queries the database, it has to open the database, which results in the log entry you are seeing.

The "wake up" behavior of RS is normal behavior. The need to open the database is a result of the default settings of SQL Express that all databases have Autoclose turned on, so when there is no activity in a database, it is closed.

As I said, this is normal behavior, if the log entries really bug you, you have to Set the Autoclose property on the RS databases to False, this way they won't close, and thus not need to be opened, which causes the Log Entry.

0
 
VENKAT KOKULLASQL Server DBACommented:
Please keep the Auto close option "false" if you dont want to see that message again and again.

To make it False, Go to Database properties--> Options-->then you can see 'Auto Close' option in middle of the window, select it as False.

Might it will help you.

--Venkat
0
 
cja-tech-guyAuthor Commented:
I checked the settings in Options and "Auto Close" was already set to "false".  Any other things I should check?  I also noticed the message in the log after hours when no one is using the database.  Only the back up runs over night.

Thanks,

CJA
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
venk_rCommented:
If I were you I wouldnt worry.Its just a regular check by the reporting service engine.It shouldn't impact your performance at all.
0
 
cja-tech-guyAuthor Commented:
OK. Thanks
0
 
cja-tech-guyAuthor Commented:
I was looking at the wrong database.  When I checked the reportservertempdb, it was set to "true".  Since you are telling me it is a normal process and that it won't affect performance, I will leave it alone.

CJA
0
 
venk_rCommented:
Well, Since you said go ahead and set it to false. It isnt going to benefit anything with setting it to true truely speaking.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now