Metadata cleanup - Merge publication
in [Replication]
|
From: "Charles Wang [MSFT]" on 16 Dec 2008 02:54 Hi Prafull, Please see my answers below: a. So as per pub7 retention period , will the metadata be cleanedup after 7 days? though we have another publication with retention period more than 7 days? Answer: No. For more than one publication, the longest retention period is always used to determine when metadata can be removed. b. As per pub14 retention period, metadata cleanup SP will be called after 14 days. Will that clean up data, though we have another publication with different retention period. Answer: Yes. If the retention period for your another publicatin is less than 14 days. c. When the retention period is set to infinite (for all the publication), can I call the metadata cleanup SP to clean the data for a perticular period lets say every month? Answer: No. If there are multiple publications on a database, and any one of those publications uses an infinite publication retention period, running sp_mergemetadataretentioncleanup does not clean up the merge replication change tracking metadata for the database. d. If answer to c is "no", then what is the use of calling metadata cleanup SP manually. Answer: The problem here is "infinite". If you set infinite retention period, mannual running sp_mergemetadataretentioncleanup is not helpful in this case. Considering the specific environment, I recommend that you first perform a test at your side to check what everything is going on before you put it into your production environment. Best regards, Charles Wang Microsoft Online Community Support =========================================================== Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: msdnmg(a)microsoft.com. =========================================================== This posting is provided "AS IS" with no warranties, and confers no rights. =========================================================
From: PrafullSurana on 16 Dec 2008 10:18 Hi Charles, Thanks a lot for providing feedback. I hope this will be last set of queries, in this regard: Based on clarification what i am getting is , "sp_mergemetadataretentioncleanup" can not be used the meta data before the retention period is reached. ( Let it be days, months, years or even infinity). What is other way to clean the meta data apart from "sp_mergemetadataretentioncleanup"? As I want to avoid application of snapshot at each susbscriber even though their database in sync with the server. If above constraint was not there then i was good with retention period use. -- Thanks and Regards, Prafull ""Charles Wang [MSFT]"" wrote: > Hi Prafull, > Please see my answers below: > a. So as per pub7 retention period , will the metadata be cleanedup after 7 > days? though we have another publication with retention period more than 7 > days? > > Answer: No. For more than one publication, the longest retention period is > always used to determine when metadata can be removed. > > > b. As per pub14 retention period, metadata cleanup SP will be called after > 14 days. Will that clean up data, though we have another publication with > different retention period. > > Answer: Yes. If the retention period for your another publicatin is less > than 14 days. > > c. When the retention period is set to infinite (for all the publication), > can I call the metadata cleanup SP to clean the data for a perticular > period lets say every month? > > Answer: No. If there are multiple publications on a database, and any one > of those publications uses an infinite publication retention period, > running sp_mergemetadataretentioncleanup does not clean up the merge > replication change tracking metadata for the database. > > d. If answer to c is "no", then what is the use of calling metadata cleanup > SP manually. > > Answer: The problem here is "infinite". If you set infinite retention > period, mannual running sp_mergemetadataretentioncleanup is not helpful in > this case. > > Considering the specific environment, I recommend that you first perform a > test at your side to check what everything is going on before you put it > into your production environment. > > > Best regards, > Charles Wang > Microsoft Online Community Support > =========================================================== > Delighting our customers is our #1 priority. We welcome your > comments and suggestions about how we can improve the > support we provide to you. Please feel free to let my manager > know what you think of the level of service provided. You can > send feedback directly to my manager at: msdnmg(a)microsoft.com. > =========================================================== > This posting is provided "AS IS" with no warranties, and confers no rights. > ========================================================= > > > > > >
From: "Charles Wang [MSFT]" on 18 Dec 2008 04:14 Hi Prafull, Please see my answers as following: Q: What is other way to clean the meta data apart from "sp_mergemetadataretentioncleanup"? A: No. Using sp_mergemetadataretentioncleanup is the only way that we recommended to cleanup the meta data since it is complete. I think that you need to consider designing an acceptable maximum retention period for all of your subscribers. Thank you! Best regards, Charles Wang Microsoft Online Community Support =========================================================== Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: msdnmg(a)microsoft.com. =========================================================== This posting is provided "AS IS" with no warranties, and confers no rights. =========================================================
From: PrafullSurana on 18 Dec 2008 09:18 Thanks Charles. -- Thanks and Regards, Prafull ""Charles Wang [MSFT]"" wrote: > Hi Prafull, > Please see my answers as following: > Q: What is other way to clean the meta data apart from > "sp_mergemetadataretentioncleanup"? > A: No. Using sp_mergemetadataretentioncleanup is the only way that we > recommended to cleanup the meta data since it is complete. I think that you > need to consider designing an acceptable maximum retention period for all > of your subscribers. > > Thank you! > > Best regards, > Charles Wang > Microsoft Online Community Support > =========================================================== > Delighting our customers is our #1 priority. We welcome your > comments and suggestions about how we can improve the > support we provide to you. Please feel free to let my manager > know what you think of the level of service provided. You can > send feedback directly to my manager at: msdnmg(a)microsoft.com. > =========================================================== > This posting is provided "AS IS" with no warranties, and confers no rights. > ========================================================= > > >
First
|
Prev
|
Pages: 1 2 Prev: Transactional Replication Next: Permission denied on sp_MS_replication_installed |