SQL Server Replication
I want to know what is Impact of replication on Sql server which mite be running a database of the size of approx 100 GB?
Out of the three types of replication available which one is the best for this kind of database ?
What is the time approx required & how much resources would it take to replicate a databse of this size & what will be the impact of replication on the master database server ?
Firstly, the type of replication would depend on your requirements (do the tables need updating on both sides, do you want changes to be fast, do you need to send the data far [across the internet/to a small regional office etc])?
Secondly, are you trying to replicate the whole database or just certain parts of it?
Thirdly, if this is only going to be used for read-only, is there a better method for you (Mirroring/Log Shipping etc)?
Finally, As there is no hard and fast rule on whether to use replication or not, perhaps a read up on the pros/cons and of basic replication techniques would be the best start for you. There are plently of resources on the internet for this.
