Has anyone tried to do replication or log shipping on the same server? The
reason being I need a replica copy to server the reporting service so that
heavy loaded queries won't impact the online processing.
Thanks for any advice.
Joseph,
I regularly set up replication on the same server for testing purposes and
have not had any problems. If you haven't yet seen it, have a look at the
article here which describes the pros and cons of log shipping and
transactional replication for setting up a reporting server:
http://www.replicationanswers.com/Standby.asp
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment