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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Company upgrade change...
Microsoft Dynamics GP (Archived)

Company upgrade changes recovery mode of database

(0) ShareShare
ReportReport
Posted on by Emily Ann 620

 

Has anyone encountered the problem when upgrading from GP9 to GP2010 the issue that when the upgrade runs it changes the recovery mode of the database from "FULL" to "SIMPLE" ?

There is a table created at the onset of the company database upgrade named duRecoveryModel.  The value in the table is "FULL" , looking in the SQL Server log you can see the set database recovery to 'SIMPLE' statement.  This causes a problem since transaction logs can no longer be backed up throughout the upgrade process.

Why and how is this happening.  I have not seen this problem in previous upgrades.

Thank you for any insight.

*This post is locked for comments

I have the same question (0)
  • Victoria Yudin Profile Picture
    Victoria Yudin 22,768 on at
    RE: Company upgrade changes recovery mode of database

    I have done quite a few upgrades from GP 9 to GP 2010 and do not recall seeing this particular issue before.

  • Emily Ann Profile Picture
    Emily Ann 620 on at
    RE: Company upgrade changes recovery mode of database

    Victoria, I was holding out hope that you had seen this problem.  It is strange. Even if when the upgrade fails due to the log filling up and I alter the database to set it back to Recovery mode Full, [and take a full backup] I can watch the SQL Log file and see that right after I restart the upgrade the company database is set back to Recovery mode SIMPLE.  

    Our company database is so large that creating a transaction log large enough to do an entire upgrade without backing up the logs is just not practical.  This behavior is baffling.   --  I hope there is someone out there that has successfully dealt with this problem.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans