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 / Finance | Project Operations, Human Resources, ... / Cannot restore AxDB Da...
Finance | Project Operations, Human Resources, ...
Answered

Cannot restore AxDB Database - DB in use

(0) ShareShare
ReportReport
Posted on by ShaqAX 709

Hi,

This is more technical question, but I'm trying to restore AxDB database from my test VM to my own devbox. I've stopped Dynamics 365 Service, there are two as I know of : Batch Management Service and DIXF Service. But every time I tried to restore from the BAK file, always failed, and it is said "Database is in use"

pastedimage1634730279042v1.png

In the Restore property I checked "Overwrite the existing database" option. Is there any setting I should checked as well ?

Or is there any more procedure that I should follow?

Thanks in advance.

I have the same question (0)
  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,160 Moderator on at

    You also need to stop World Wide Web Publishing Service. That's where the AOS runs.

    And I always stop also Management Reporter 2012 Processing Service.

  • ShaqAX Profile Picture
    ShaqAX 709 on at

    Hi Nikolaos,

    I did, and I didn't use Management Reporter. But the problem still persist.

    Thanks

  • Suggested answer
    Deepak Agarwal Profile Picture
    Deepak Agarwal 8,598 on at

    Hi,

    The best way to restore DB is to restore it first with a different name, maybe AXDB_UAT. Then stop below services and stop IIS in command prompt using iisreset/stop command.

    1. World wide web

    2. Management reporter

    3. Microsoft Dynamics 365 Unified Operations: Batch Management Service

    4. Microsoft Dynamics 365 Unified Operations: Data Import Export Framework Service

    Then delete existing AXDB and rename imported DB to AXDB.

    Refer below link for more details, 

    https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/dbmovement-scenario-exportuat#import-the-database

    In case you still facing issue with renaming, pl try to bring DB offline once and close all connection and then bring it online back. This trick works most of the time 

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,160 Moderator on at

    Also make sure that you don't have any open queries into the database in SSMS, and that Visual Studio is not running.

  • ShaqAX Profile Picture
    ShaqAX 709 on at

    Hi both,

    Many thanks for all the advices. Managed to restore, for I need to take it Offline. It is actually stated in Deepak's blog ->

    community.dynamics.com/.../restore-the-db-showing-db-in-use

    Thanks again.

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans