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 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,870 on at

    Not necessarily unless you are using it.

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at

    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

    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,096 on at

    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

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

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans