Announcements
Our store databases (containing the info for the 5 stores (name, address, etc), are corrupt. One of the five stores is listed in the database twice, and one is missing entirely. The information in the headquarters database is correct. Reindexing and synchronizing does not work, the information remains wrong in the store databases. Anyone know the best way to make the dbo.store tables match up properly between headquarters and store?
Thanks for any help!
*This post is locked for comments
Thank you Todd! I am going to try this today. I'll be sure to do it first in a test environment!
Hello Roger,
Thank you for posting your question about missing stores.
In my testing I made backups of my store and HQ databases.
I then deleted all of the stores from the store table in one of my store database via SQL; and then ran the below query at HQ to reset the DBTimeStamp on the records:
update store set name = name
Running a 401 at the store added back the stores at the store.
You may want to try this first in a test environment; and make backups.
Todd
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,807 Super User 2024 Season 2
Martin Dráb 229,135 Most Valuable Professional
nmaenpaa 101,156