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 NAV (Archived) / Backup and Restore NAV DB
Microsoft Dynamics NAV (Archived)

Backup and Restore NAV DB

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

I have a question about NAV DB Backup and Restore.

If I backup SQL DB, do I need to backup Development Environment?

If I restore SQL DB, do I need to restore Development Environment?

We have a Production System and a Test System. If we want to backup Production System DB and migrate data to Test System, do we need to consider the Development Environment?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Alex A Profile Picture
    Alex A 2,634 on at
    RE: Backup and Restore NAV DB

    Not necessarily unless you are using it.

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,233 Super User 2025 Season 2 on at
    RE: Backup and Restore NAV DB

    Allen,

    What do you mean by Development Environment ? do you mean the objects or development database.

    If you take a SQL backup it includes the data and the object changes, so if you restore production DB on Test System then you are overwriting everything including the objects and the data you have in the TEST system.

    If you are using SQL backup/restore option then what I recommend is always take the backup of  all the objects from the TEST database before restore and once you restore the production, take the objects backup and re-import them using development environment that way your pending modifications you have in  the TEST will be restored.

    I hope this answer your question.

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Backup and Restore NAV DB

    Hi Allen,

    You do no need to do backup / restore Development Environment, if you use SQL DB backup option.

    Further, if you want to restore the Production System to Test System, it will completely overwrite the entire database (Including Data & Development Environment Objects).

    Hence, please ensure that, objects in Production & Test Environment are in sync., before you restore.

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Backup and Restore NAV DB

    As mentioned by Suresh and Vishal, SQL backup will include not only the data, but all the objects of your database, so you can continue the developments using Development Environment when you just restore the backup.

    If you want to be sure that the objects will not be modified and you would need to import to Test System only the data, you should not use SQL restore backup (as it will overwrite your objects in Test System), but consider alternative sources of import, e.g. RapidStart service.

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 NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#2
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans