Restoring AX database

(1) Share

Report

Posted on by Community Member

Scenario: I want to restore the AX database to new server. (In both server the version of AX and Server and everything other is same).

FYI,

1. I tried restoring database by clicking on existing database and selected files to restore. Only modelstore database got restored not other 2. If modelstore can why can't other 2 databases restored in this way.

2. deleted 3 AX database and restored the new database then installed AOS and successfully restored.

I want to know the proper way of restoring in my scenario.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Iulian Cordobin 8,201 on at

Like (1)

Report

Deleting the previous databases should be one of the proper ways to go. In this scenario you don't have to worry that the database is still in use, and as a result can't be overwritten (this is what happened in case 1). When you restore the database and don't delete the old ones, you should select Overwrite options as well as Close existing connection (I assume the AOS is stopped in all cases).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Cordobin,

Thank you for quick response.

yes AOS is stopped in both case.

I am still facing some user problem after restoring. If you can share the document/blog/ procedure for full restoration procedure that will be helpful.

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 49,443 User Group Leader on at

Like (1)

Report
Restoring DB is not a good practice. This should be avoided 100%, when it comes to production environments.

Yes if you do have a test system, you may think to play with it.

Every system do has some metadata, which is needed to run system, the same is for AX. There are couple of tables that should not be overridden.

If you have restored Database, you must fix data of those tables. One prominent example of this is userInfo table, where SID of user is very vital. Having that SID wrong may lead to stop of AOS service.

So, you must be doing two things if you have thought of DB restore.

Take backup of tables which have important metadata

Restore database with override option

Restore back those tables which has metadata.

http://msdynamicsaxtips.blogspot.com/2013/11/list-of-table-in-ax-2012-should-be.html

Note that if you are failing at point#2, you should discuss this on SQL Server Forum, where experts of the area can guide you better than AX Experts.

Was this reply helpful? Yes No