Solved

SQL 2008 Report Server Best Practice

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Suggested Solutions

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
In this article I will describe the Backup & Restore 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.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

744 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

10 Experts available now in Live!

Get 1:1 Help Now