Does anyone have a documented plan or a script on what articles to skip in creating a snapshot for replication?
Mine died over the weekend and I followed MSs replication tutorial, but it is not working.
1 Like
What is the replication for? We had to do a replication for our e-commerce store. I had access to documentation at one time that laid out which articles were required for that. But I am sure that was specific to the PartTrap store.
It is for our corporate reporting. I had a DBA consultant go thru the setup when we moved to 10 and I used his scripts when we went to 11 in 2022 and it was good until failed a few weeks ago and has been steadily getting worse. Someone from corporate is going to look tomorrow who is a SQL person which I am not, so hopefully it will be running again.
Yeah I understand just enough to troubleshoot based on the menus and options I can get to. I am not a DBA by trade either.
1 Like
What errors are you getting Greg?
1 Like
I tore it all out today, so no errors currently. duplicated or missing on the PartAlloc table and I could remove the dup or add the missing and keep it going. Then it moved to no null values on bit fields that were and had been false for a long time.
It had been done as a backup that got restored on all of the previous rounds that had failed, so I tried all articles with a snapshot and it just never finished the process.
Ping me if you are stil having issues I setup repliatino for us. Every time we upgrade we have to rip it out and do it again.
We do transaction replication. Its not too bad to setup , but the snapshot does lock you out during the initial creation for like 40-50 minutes. (Depdndig on Db size)
4 Likes
Do you replicate the whole DB or just part? I tried both and the snapshot never got to the other server. We are trying now with a backup and not a snapshot which is what we did in 2022.
We replicate most articles (not everything we leave change log and other tables off)
1 Like