Solved

SQL "Starting up database 'ReportServerTempDB'. message

Posted on 2011-09-14
7
1,736 Views
Last Modified: 2012-05-12
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
Comment
Question by:cja-tech-guy
  • 3
  • 3
7 Comments
 
LVL 8

Accepted Solution

by:
venk_r earned 250 total points
ID: 36540034
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
 
LVL 5

Assisted Solution

by:VENKAT KOKULLA
VENKAT KOKULLA earned 250 total points
ID: 36542631
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
 

Author Comment

by:cja-tech-guy
ID: 36542925
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
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 8

Expert Comment

by:venk_r
ID: 36542977
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
 

Author Comment

by:cja-tech-guy
ID: 36543080
OK. Thanks
0
 

Author Comment

by:cja-tech-guy
ID: 36543098
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
 
LVL 8

Expert Comment

by:venk_r
ID: 36543129
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now