Notifications
Announcements
No record found.
My question is, say we needed to restore a specific company to a certain date, is that possible or do you need to restore all the GP databases to that date?
*This post is locked for comments
Jeff,
Using SQL Server you can restore a single company. Depending on how you are backing up, you may even be able to do a point-in-time recovery.
SQL is excellent when it comes to recovery (imho).
Kind regards,
Leslie
Jeff, are you doing this just to bring a company to a certain day, like the last day of the previous month for a company that has very few transactions so instead of entering reversing entries you simply want to start over from a certain date? You can certainly do this with the only caveat being the next note index value which is kept in the DYNAMICS.SY01500 table. There is one record per company in that table and the value is the value of the next note index value. So if you use notes and restore to a prior day, the next note value will have a gap as compared to the existing transactions. This issue will go away with GP 2012 next fall.
Hi, I need to ask basically the same question. If I need to restore 1 company there should be no need to restore the other companies or the system database, correct? We always back up before making any changes to any databases. So, if I made a change to one company DB and it was unsuccessful, I should be able to restore that one company DB from the pre-work backup and not restore anything else?
Thank you!
Tracy
Yes....99.9999% of the time. What kinds of changes are we talking about?
Ian.
I have various scenarios, but one would be running an update script on the back end against a company table.
On a reverse note: If I had to restore the system database would I have to restore all company databases on that instance too?
What is driving me asking this question is that we currently have a custom application that writes to the Company AND system Database. So if we ever had to restore that company we would have to restore the system database too. If that was the case would I have to also restore the other 22 companies?
Thank you so much for your prompt replies!
The only minor issue here is the NOTEINDX field inside DYNAMICS.SY01500. This keeps track of the next note index number. This field gets incremented per company as users add notes or transactions to the database. The other is Business Portal. This write to many tables inside the DYNAMICS database. If you are simply restoring just one company you will be alright, but if you restore the DYNAMICS database you will need to run the NOTEFIX program to correct the next note index values.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 2
mtabor 1
Victoria Yudin 1
