Solved

SQL 2008 Report Server Best Practice

Posted on 2010-11-10
2
337 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 28

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

830 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