web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP and SQL Database St...
Microsoft Dynamics GP (Archived)

GP and SQL Database Stability

(0) ShareShare
ReportReport
Posted on by AdamFrank 435
Hello everyone!  Wondering if anyone might be able to help me get an answer to this. 
We have a client who is interested in switching over from Business Visions to GP 2010 and they one thing they need clarification on.
Their current issue with Business Visions is that if there is:

a)      Power outage

b)      Server runs out of disk space

Their database is then corrupted and unreliable when either of these things happens during the middle of transactions, postings, etc.
 
This client is a very technical person and wants to know how GP and a SQL server solution is more resilient when it comes to network outages and disk errors (eg. can it result in unbalanced transactions if not all of the SQL transactions are committed?, etc... will SQL server and GP be smart enough to roll back all related transactions if there was a crash after transaction 3 of 5 was posted)
Thank you!

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Mike Smith Profile Picture
    Mike Smith 6,840 on at

    Hi Adam,

    While I cannot comment on SQL Server 20XX resiliency to these issues, GP generally does a very good job with a loss of power or connection during the posting process.  GP has a feature called "Batch Recovery" that will generally kick on during these times.  While this is not always the case, I have seen this "save the day" more often than not during these instances.  Like I mention though, this isn't 100% the case as sometimes data table clean-up is necessary.

    As far as running out of disk space, I cannot comment as I have not encountered this directly during the posting process.

  • Jonathan Fear Profile Picture
    Jonathan Fear on at

    Hi Adam,

    GP relies solely on SQL for all of the issues you mentioned. There is no one answer for your question as it depends on the SQL setup. Here are some links you will want to review:

    mbs.microsoft.com/.../gp2010_systemutilsguides.htm

    mbs.microsoft.com/.../mdgp2010_whitepaper_performance.htm

    mbs.microsoft.com/.../gp2010_accessibilitywp.htm

    mbs.microsoft.com/.../gp2010_architecturewhitepaper.htm

  • AdamFrank Profile Picture
    AdamFrank 435 on at

    Thank you Mike and Jonathan.  Both of these help me out alot.  I appreciate your help

  • iruser Profile Picture
    iruser 527 on at

    i used to sell GP.  I Was a user before and am now a user again after selling GP.

    Part of the sales demo when i was first a user was an a/p batch of 200 transactions.  The sales person hit post then turned off the computer, simulating a power outage.  GP recovered the batch.  When I sold GP i did the same thing.  GP recovered the batch every time.

    Show that as part  of your demo.

    Since your lead is techy savy talk about the sql log, that if set right you can roll back to moments before issues.

    I think the large batch demo however is the key. It wowed my employers when we first saw it and it wowed my leads when i sold GP.

    Ian

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans