Transactional Replication for Reporting DB Server and Archival of Data

• reddyk

  Mr or Mrs. 500

  Points: 516

  More actions

  September 27, 2012 at 8:50 am

  #267389

  We are planning to have a reporting server where data is replicated using transactional replication from production server. If I plan to disable deletes to the subsciber.

  Can weuse the subscriber databse for archival purposes also? Would creating a snapshot be an issue? Can the subscriber database have more data than publisher?

  Any input is greatly apprecited.

  Thanks

• irobertson

  Hall of Fame

  Points: 3695

  More actions

  October 23, 2012 at 3:31 am

  #1551803

  This doesn't look like a situation where I would use replication. You may be better off setting up SSIS packages to transfer the data that you need.

• Chris Becker

  SSCrazy

  Points: 2645

  More actions

  December 6, 2012 at 5:39 pm

  #1566400

  There is a feature called 'deferred update' in that an update to a column in a clustered index will replicate as a delete/insert pair.

  Build an archive routine that moves rows out of 1 db to another arc db.

  regards,

  chris

  mssqlconsulting.com

  Chris Becker bcsdata.net