SQL Server 2008 R2, Transactional replication
I am new in replication and I am installing and configuring a transactional replication to learn and test how it works.
I have just finished the Distributor installation: on the Properties page I find:
1) Transaction retention
2) History retention
Please could you give some suggestions on how how to configure them, keeping in mind problems/constraints and ensuring the replica is well performed without problems.
Stick with the defaults.
Transaction retention controls how long the commands will be stored in the distribution database after they have been applied on the subscriber.
History retention controls the lenght the history of your replication sessions (the view details dialog in replication monitor) hangs around for.
I normally keep long histories in case I have to go back in time and figure out what happened when.
Some people keep the transaction retention higher as it is easy to recover from failed subscribers by having replication catch up after a database backup restore.
Keeping transaction retention may mean a large distribution database.
looking for a book on SQL Server 2008 Administration?
http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search?
マイクロソフトでは、Msdn Web サイトについてのお客様のご意見をお聞きするためにオンライン アンケートを実施しています。参加を選択されると、Msdn Web サイトから他のページに移動する際にオンライン アンケートが画面に表示されます。