Reporting Server - Replication Topology

Currentlly, we have 2 SQL 2000 Servers in a Win2003 Cluster. Everything
works great. Our application runs on two IIS web servers and connects to the
SQL back end.
When people are running reports the SQL server can get taxed. What is the
best replication method where uses can connected to a different SQL server
and run reports on that server? The data has to be as current as possible.
Thanks!
Transactional replication.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Scopus69" <Scopus69@.nospam.postalias> wrote in message
news:32E4ED5A-7928-431B-9FC6-DA83610E7553@.microsoft.com...
> Currentlly, we have 2 SQL 2000 Servers in a Win2003 Cluster. Everything
> works great. Our application runs on two IIS web servers and connects to
> the
> SQL back end.
> When people are running reports the SQL server can get taxed. What is the
> best replication method where uses can connected to a different SQL server
> and run reports on that server? The data has to be as current as possible.
> Thanks!
>
|||Hilary,
Where can I find a good "How To" to set this up properly? Is this fairly
easy? What do you have to watch for? I have setup log shipping before and
that is pretty simple. Thanks!
"Hilary Cotter" wrote:

> Transactional replication.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Scopus69" <Scopus69@.nospam.postalias> wrote in message
> news:32E4ED5A-7928-431B-9FC6-DA83610E7553@.microsoft.com...
>
>
|||On SQL Server 2000 I have used transactional replication and log shipping
for this - please see this article for the pros and cons of each approach:
http://www.replicationanswers.com/Standby.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Google around for transactional replication tutorials - or check out my
book. The best approach is to get your hands dirty right away and post back
here if you encounter problems.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Scopus69" <Scopus69@.nospam.postalias> wrote in message
news:DB1C8113-C62C-41E4-8D85-390B8424EE3D@.microsoft.com...[vbcol=seagreen]
> Hilary,
> Where can I find a good "How To" to set this up properly? Is this fairly
> easy? What do you have to watch for? I have setup log shipping before and
> that is pretty simple. Thanks!
> "Hilary Cotter" wrote: