SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Report Server help


Report Server help

Author
Message
DBA12345
DBA12345
Valued Member
Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)

Group: General Forum Members
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
DBA12345
DBA12345
Valued Member
Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)

Group: General Forum Members
Points: 56 Visits: 240
Can any one answer me please.....
muth_51
muth_51
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1207 Visits: 2915
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.
MMartin1
MMartin1
Hall of Fame
Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)

Group: General Forum Members
Points: 3795 Visits: 2031
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.

----------------------------------------------------
How to post forum questions to get the best help
peterdru401
peterdru401
SSC Rookie
SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)

Group: General Forum Members
Points: 47 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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search