Thanks for posting this. This came really handy to address an issue with a vendor DB.

Keep you the good work.

Thanks,

Ram

Hi,

As a clean up we deleted around 50 milliion records from a table and the changes are showing up in the two subscriptions. However I am getting query timeout expired...

Thanks for you response Noel. Yeah I figured it out after some trials.

Thanks,

RV

Hi Sejal,

One quick question. Did you detach the distribution DB from the current location and attached it at the new location? or Did you use the new Distribution Database in...

Hi Mike,

See below:

1) Move the historical data from

Production..TABLE_A -> Move Historical Data to -> Historical..TABLE_A_HISTORY

2) Then establish Replication

Production..TABLE_A -> Replicate -> Historical..TABLE_A_PROD

You can create a View...

Thanks Mike for the detailed explanation. Definitely this appears to be an option for us. While to talking some of my colleagues we came up with another option as well.

For...

Thanks Roy I will go through the paper.

Mike, Though I bumped into the idea few times but your implementation offers scope. How do you manage disaster recovery for your reporting...

Thanks Roy. Good Point. We have SQL Server 2005 64 Bit Standard so Partitioning is not an option right now.

One thought was to keep the replicated database same as production...

SQL Experts Help Please ......

We have a requirement to keep only 6 months of production data and move any data prior to that to the reporting database and maintain it...

This article is a life saver, helped us when our App server went down. Hats off to the author.

Thanks!