Solved

SQL 2008 Report Server Best Practice

Posted on 2010-11-10
2
341 Views
Last Modified: 2012-05-10
What is Microsoft Recommodations for : keeping sql server report services and database engine installed on the same box. - For SQL 2008.
For SQL 2005 it was recommended that these two components should be installed on separate servers, Does the same recommodation still apply for SQL 2008?
0
Comment
Question by:Wizilling
[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
2 Comments
 
LVL 29

Accepted Solution

by:
sammySeltzer earned 250 total points
ID: 34107764
Always good idea to keep both separate.

For your satisfaction, please read:

http://stackoverflow.com/questions/190512/sql-server-separate-database-for-reports
0
 
LVL 4

Assisted Solution

by:MSSystems
MSSystems earned 250 total points
ID: 34114737
Yes, I think it is always a good idea to separate the two. However I am assuming that you are not going to report on millions of records. Otherwise you would not have asked this question.
If I am right you can host them on the same server. However I would have created a separate database just for reports. This gives you some flexibility. For example: you can put the database in a read only state. This helps a lot with performance and deadlocks.
If you want to chat more, let me know. Otherwise I apologise for the assumption.
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

632 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