Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sridevi boddu
Starting Member
4 Posts |
 Posted - 2011-04-19 : 05:22:01
|
| Hello All,I need to archive some tables of the database (Test) to another database with same name and extension as archive (Test_archive), so that the tables contain only 2 months old data . This database(Test) is being replicated. What would be the best strategy to archive this data.As that database is already being replicated(Transactional replication). If we keep the subscriber database on separate server and modify replication in order to not propagate deletes to subscriber from publisher.Can we use this subscriber database as archive database, so that even if we delete some data in production database tables it doesn't propagate to archive database tables.Is Transactional replication a viable solution for Archiving the data?Thanks in advancesridevi |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2011-04-19 : 08:26:26
|
| Transactional replication is more for realtime updates than for archiving. IF you want to use T-Rep for archiving, you need to setup filters on the tables which can hurt performance.. The question is, do you need the deletes on Test to be propagated to the subscriber?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Archiving