What are the ways a real time reporting on MS Sql server possible without hitting production Sql server with report queries and slow down the box?

What are the ways a real time reporting on MS Sql 2005 server possible without hitting production Sql server with report queries and slow down the box?
ivan_belalAsked:
Who is Participating?
 
Walter PadrónConnect With a Mentor Commented:
There is all you need "SQL Server 2005  Replication" http://technet.microsoft.com/en-us/sqlserver/bb331775.aspx

Regards
0
 
MidnightOneCommented:
Not to sound ignorant, but how would you propose to pull data from a SQL database without interacting with it?
0
 
ivan_belalAuthor Commented:
thru a replica of the primary... need to know best practice around that
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.