--- title: Catching Up A Track On Replication description: Clubspeed Customer Knowledge Center --- [Skip to content](https://help.clubspeed.com/clubspeed-knowledge-center/catching-up-a-track-on-replication#main-content) English Show submenu for translations [More support](https://help.clubspeed.com/clubspeed-knowledge-center/kb-tickets/new?hsLang=en) [![Clubspeed Logo](https://help.clubspeed.com/hs-fs/hubfs/Logo_Grey.png?width=500&height=86&name=Logo_Grey.png)](https://help.clubspeed.com/clubspeed-knowledge-center?hsLang=en) Open main navigation Close main navigation - English Show submenu for translations - [More support](https://help.clubspeed.com/clubspeed-knowledge-center/kb-tickets/new) - [Contact us](https://share.hsforms.com/1B5QyPF-YRQutaoGEnmQD5w1etz6) [Contact us](https://share.hsforms.com/1B5QyPF-YRQutaoGEnmQD5w1etz6) How can we help you? - There are no suggestions because the search field is empty. 1. [Clubspeed Customer Knowledge Center](https://help.clubspeed.com/clubspeed-knowledge-center?hsLang=en) December 6, 2024 # Catching Up A Track On Replication Search ### Catching Up A Track On Replication **Overview** Most commonly when a new location is added to an organization, they were started with a copy of a database from an existing location. When the new location comes online, there will be a gap of records they are missing to be considered up to date. To bring this track in sync with the other locations, follow these steps: 1. Ensure replication is enabled for the new track 2. Prompt each existing location to sync the missing records to the new location **1. Ensure replication is enabled for the new track** You can [follow our existing guide](https://clubspeed.zendesk.com/hc/en-us/articles/203925309-Setting-Up-Replication) to enable replication. This will begin syncing all new records across. **2. Prompt each existing location to sync the missing records to the new location** We now need to sync over the "missing" records since the new track's database was installed. Determine when the database was last up to date. This will typically be the date of the backup used to create the database. It's ok to go a little older than you need (it will just resync already sync'd records). **2a. Ensure CS\_Replication Stored Procedures are up to date** Older versions of Club Speed did not attempt to limit how many records were sync'd. This is ok when you are just syncing a few at a time, however we will be potentially sync'ing thousands. Execute the two attached SQL statements on ClubSpeedV8 to ensure we have some limiting on how many records are processed each time CS\_Replication.exe is run. Don't run for Team Sport locations. If you need to update the stored procedure, copy and past the stored procedure from 1 location that is working to the new location (for detailed steps, see a level 2 support personnel). The Stored Procedure will include "LIMIT(500)" in the table(0) and table(2) queries if it is the updated one. **2b. Put the records in the replication Queue** **At each existing location**, run the script below, setting your SyncStartDate variable to when you want the "catchup" to start and your IPtoReplicateTo to the track's IP or DNS name. Any records after SyncStartDate will be pushed into the "ReplicateFailed" and "ReplicateMembershipsFailed" tables which is the "retry queue". The records will have a "Deleted" column of 0 meaning that they have not replicated yet. When they DO replicate, "Deleted" will be set to 1 which means the record has replicated. Also, remember to change the DB to ClubspeedV8 before executing the query. sql (943 Bytes) sql (1.26 KB) sql (1.77 KB) - - - - ### Related Articles - [FAQs](https://help.clubspeed.com/clubspeed-knowledge-center/faqs?hsLang=en#main-content) - [Software Questions](https://help.clubspeed.com/clubspeed-knowledge-center/faqs?hsLang=en#software-questions) - [Payments Questions](https://help.clubspeed.com/clubspeed-knowledge-center/faqs?hsLang=en#payments-questions) - [Getting started](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#main-content) - [Clubspeed](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#clubspeed) - [Administration](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#administration) - [Product Setup](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#product-setup) - [Customer Experience](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#customer-experience) - [Race Control](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#race-control) - [Manager Controls](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#manager-controls) - [Point of Sale Operations](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#point-of-sale-operations) - [Venue Operations](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#venue-operations) - [Race Control Operations](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#race-control-operations) - [Event Calendar](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#event-calendar) - [Open & Closing Shifts](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#open-closing-shifts) - [Activity Setup (FEC Non Karting)](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#activity-setup-fec-non-karting) - [Kart Focused](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#kart-focused) - [Troubleshooting](https://help.clubspeed.com/clubspeed-knowledge-center/troubleshooting?hsLang=en#main-content) - [networking](https://help.clubspeed.com/clubspeed-knowledge-center/troubleshooting?hsLang=en#networking) - [General](https://help.clubspeed.com/clubspeed-knowledge-center/general?hsLang=en) - [Reports](https://help.clubspeed.com/clubspeed-knowledge-center/reports?hsLang=en#main-content) - [Gift Cards](https://help.clubspeed.com/clubspeed-knowledge-center/reports?hsLang=en#gift-cards) - [Integrations](https://help.clubspeed.com/clubspeed-knowledge-center/integrations?hsLang=en) - [Payments](https://help.clubspeed.com/clubspeed-knowledge-center/payments?hsLang=en) - [Email and Text Messaging](https://help.clubspeed.com/clubspeed-knowledge-center/email-and-text-messaging?hsLang=en) - [Item Management](https://help.clubspeed.com/clubspeed-knowledge-center/item-management?hsLang=en) - [Resources](https://help.clubspeed.com/clubspeed-knowledge-center/resources?hsLang=en) - [Calendar Management](https://help.clubspeed.com/clubspeed-knowledge-center/calendar-management?hsLang=en) - [Customer Management](https://help.clubspeed.com/clubspeed-knowledge-center/customer-management?hsLang=en) - [Promotions and Marketing](https://help.clubspeed.com/clubspeed-knowledge-center/promotions-and-marketing?hsLang=en) - [Updates](https://help.clubspeed.com/clubspeed-knowledge-center/updates?hsLang=en#main-content) - [Release Notes](https://help.clubspeed.com/clubspeed-knowledge-center/updates?hsLang=en#release-notes) - [Registration](https://help.clubspeed.com/clubspeed-knowledge-center/registration?hsLang=en#main-content) - [Setting up Your Registration](https://help.clubspeed.com/clubspeed-knowledge-center/registration?hsLang=en#setting-up-your-registration) - [iPads](https://help.clubspeed.com/clubspeed-knowledge-center/registration?hsLang=en#ipads) - [Products](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#main-content) - [Business Additions](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#business-additions) - [Extra Tips & Tricks](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#extra-tips-tricks) - [Setup](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#setup) - [Point of Sale](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#point-of-sale) - [Barcode](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#barcode) - [Activities](https://help.clubspeed.com/clubspeed-knowledge-center/activities?hsLang=en#main-content) - [Activity Operations](https://help.clubspeed.com/clubspeed-knowledge-center/activities?hsLang=en#activity-operations) - [Reporting](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#main-content) - [Sales Reports](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#sales-reports) - [Operational Reports](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#operational-reports) - [Labor Report](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#labor-report) - [Accounting](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#accounting) - [Race Operations](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#race-operations) - [Quickbooks Online](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#quickbooks-online) - [Club Booking](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#main-content) - [Setup - Club Booking](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#setup-club-booking) - [Operations](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#operations) - [Booking Manager](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#booking-manager) - [Bonus Material - Club Booking](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#bonus-material-club-booking) - [Operational Flows](https://help.clubspeed.com/clubspeed-knowledge-center/operational-flows?hsLang=en) - [Food & Beverage](https://help.clubspeed.com/clubspeed-knowledge-center/food-beverage?hsLang=en) - [Speed Screen Displays](https://help.clubspeed.com/clubspeed-knowledge-center/speed-screen-displays?hsLang=en) - [Garage](https://help.clubspeed.com/clubspeed-knowledge-center/garage?hsLang=en) - [Support Task](https://help.clubspeed.com/clubspeed-knowledge-center/support-task?hsLang=en) - [Webinar](https://help.clubspeed.com/clubspeed-knowledge-center/webinar?hsLang=en) - [Playbook](https://help.clubspeed.com/clubspeed-knowledge-center/playbook?hsLang=en) [![2022-clubspeed-newsletter-header-logo](https://help.clubspeed.com/hs-fs/hubfs/2022-clubspeed-newsletter-header-logo.png?width=240&height=42&name=2022-clubspeed-newsletter-header-logo.png "2022-clubspeed-newsletter-header-logo")](https://help.clubspeed.com/?hsLang=en) Copyright © 2024, Club Speed, LLC