November 11, 2012 at 1:49 pm
I am confusing with below questions from my manager. Could you please answe asap.
1.what is the difference between DB server and Report Server?
2.To generate reports do we need connect from report server to database server?
3.Can we configure Logshipping for report server to already existing DB stand by server or we need to have new server?
Please let me know if you are not clear with the questions.
Thank you
November 11, 2012 at 4:01 pm
Can any one answer me please.....
November 11, 2012 at 6:02 pm
Usually DR servers are used for reporting purposes. In stand by recovery mode we can access the database. On prod servers we usually don't give access to other ppl in the company to run any queries against the prod databases. So you can implement transactional replication or use the existing logshipping server for your reporting purposes. If you use log shipping server, in stand by restore mode users will be disconnected while restoring the log backup.
November 16, 2012 at 2:10 pm
Log shipping is mainly used to have a backup server in case of hardware failure on the production server. This should already be in place on production system. If your main server goes down this becomes renamed to that server that went down- so as to keep things up and running. You need to understand your report users and how latent data can be. Do they need up to the minute granular records? Can information be one day behind? If the former I would use transactional replication. if the latter- you can restore from a backup if you do these nightly or create and schedule an SSIS solution to copy just those tables for the time frame needed.
I hope this addresses your concern.
----------------------------------------------------
November 20, 2012 at 5:58 am
1.what is the difference between DB server and Report Server?
Answer:
The report server is the central component of a Reporting Services installation. It consists of a pair of core processors plus a collection of special-purpose extensions that handle authentication, data processing, rendering, and delivery operations. Processors are the hub of the report server.
Report Manager is an ASP.NET web application that provides report management/viewing capabilities for a Reporting Services instance configured in native mode.
The configuration settings of Report Manager and the Report Server Web service are stored in a single configuration file (rsreportserver.config).
You can also use "Reporting Services Configuration Manager" to configure settings for Report Server and Report Manager.
for more detail u can follow bellow link
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply