Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Transactional Replication for Reporting DB Server and Archival of Data Expand / Collapse
Author
Message
Posted Thursday, September 27, 2012 8:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 12:10 PM
Points: 176, Visits: 292

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



Post #1365321
Posted Tuesday, October 23, 2012 3:31 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 22, 2014 1:02 AM
Points: 227, Visits: 666
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.
Post #1375932
Posted Thursday, December 6, 2012 5:39 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, September 11, 2014 7:22 PM
Points: 222, Visits: 246

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



Post #1393809
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse