Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL 2008 Report Server Best Practice

Posted on 2010-11-10
2
Medium Priority
?
349 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
2 Comments
 
LVL 29

Accepted Solution

by:
sammySeltzer earned 1000 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 1000 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

885 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