Your biggest problem with respect to speed will be if your Distributor is
on the same box as the Publisher. I would recommend that you have the
Distributor be a separate machine or failing that, have the Distributor be
on the same box as the Subscriber.
________________________________
Monte Kottman
Database Administrator
Asurion Corporation
8800 Ward Parkway
Kansas City, MO 64114
Phone: (816) 237-3252
Cell: (816) 309-6306
________________________________
-----Original Message-----
From: Harsh Kumar
[mailto:mssqldba-ezmlmshield-x20212080.[Email address protected]
Sent: Tuesday, June 27, 2006 2:09 AM
To: LazyDBA Discussion
Subject: Transaction Replication
Hi All,
I want to setup of transaction replication of database size 94 GB with at
least 400 users always connected. Database grows with rate of 700 mb/day.
This is my production server.
I have tested with copy of this database on test server, its working fine.
I have confusion about the performance issue after implement with
transaction replication.
Any one can comment what the best way to implement transaction replication
on production database.
And the same way I want to implement log shipping for the reporting server
on same database for the BO purpose.
Thanks in Advance for nice suggestion.
Regards,
Harsh Kumar
Database Administrator - IT Dept.
9213469176
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
-----------------------------------------
This e-mail and any attachments are intended only for the
individual or company to which it is addressed and may contain
information which is privileged, confidential and prohibited from
disclosure or unauthorized use under applicable law. If you are
not the intended recipient of this e-mail, you are hereby notified
that any use, dissemination, or copying of this e-mail or the
information contained in this e-mail is strictly prohibited by the
sender. If you have received this transmission in error, please
return the material received to the sender and delete all copies
from your system.
MS Sql Server LazyDBA home page