Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Report Server help Expand / Collapse
Author
Message
Posted Sunday, November 11, 2012 1:49 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, April 24, 2014 8:19 PM
Points: 56, Visits: 240
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
Post #1383464
Posted Sunday, November 11, 2012 4:01 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, April 24, 2014 8:19 PM
Points: 56, Visits: 240
Can any one answer me please.....
Post #1383477
Posted Sunday, November 11, 2012 6:02 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 8:51 AM
Points: 394, Visits: 1,977
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.
Post #1383486
Posted Friday, November 16, 2012 2:10 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 3:05 PM
Points: 355, Visits: 870
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.
Post #1385861
Posted Tuesday, November 20, 2012 5:58 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 8:34 AM
Points: 23, Visits: 128
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

msdn microsoft


Post #1386873
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse