1

SQL one way append replication

view story
linux-howto

http://serverfault.com – Let me describe the setup. There is one production database that is being filled with data on the daily basis. We want to create replica (trans log shipping?) of the database on the other SQL server. So far we were able to setup fully operational one way trans log shipping. Now the data on the production database is being deleted every 30 days and we do not want to delete that data on the replicated database, we want only append new data from production database to the replicated database. Is this setup possible at all with any Microsoft SQL server? (HowTos)