January 15, 2009 at 7:48 am
Hello,
today I had a big problem with the restore of my test replication. My system looks like this:
- Publisher (P) is an OLTP
- Distributer (D)
- Subscriber (S) as Reporting Server with historical data
Inserts and Updates are transfered from P to S. Deletes aren't. So I get a subscriber with historical data.
My problem: I thought it would be a good idea to backup all three databases with fullbackup once a day and logbackup every 30 minutes. I tried to restore the subscriber, because i'd like to see if this works. Now the problem: If the last backup was a transactionlog backup of the subscriber, the replication will fail. Only the last action (1 command) was transfered from P to S. All the other commands between the transactionlog backup and the restore point were missing.
If I use a fullbackup instead of transactionlog backups it works perfect.
Anyone an idea? Is this a bug in the replication?
Best regards
January 15, 2009 at 9:30 am
You you read about the "retention period" on the distributor.
It holds the key to your problem. You should increase the minimum time the transactions are "kept" in the distribution database before they are deleted by the distribution cleanup. The tricky part is usually not the subscriber but the Publisher and Distributor. The @synch_with_backup option controls how you plan the recovery of the Publisher and/or Distributor.
Hope it helps.
* Noel
January 16, 2009 at 4:43 am
Hello Noel,
yes your were right. It was the 'min_distretention' Parameter. It seems, this parameter has an MS-Default of 0. So after I restarted the agents, the data was already deleted out of the distributer (because it was already successfull transfered to the subscriber earlier).
Thanks
January 16, 2009 at 10:18 am
Collateral (1/16/2009)
Hello Noel,yes your were right. It was the 'min_distretention' Parameter. It seems, this parameter has an MS-Default of 0. So after I restarted the agents, the data was already deleted out of the distributer (because it was already successfull transfered to the subscriber earlier).
Thanks
Glad it helped!
* Noel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply