Solved

SQL "Starting up database 'ReportServerTempDB'. message

Posted on 2011-09-14
7
1,841 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

739 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