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) / Microsoft Dynamics NAV...
Microsoft Dynamics NAV (Archived)

Microsoft Dynamics NAV W1 5.0 SP1

(0) ShareShare
ReportReport
Posted on by Community Member

I would like to restore a database from a current backup of our production database, but exclude the data.  So just restoring a database which would contain objects, design, tables, etc. just no data entry items that we have entered.  Is this possible?

Thanks...

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at

    If you use SQL backup then it will restore everything, but if you have NAV backup then you restore only the objects by checking off companies and leave on the Application Objects

  • Verified answer
    keoma Profile Picture
    keoma 32,729 on at

    restore the backup to a new database. then select all objects, export them as fob file. create a complete new, empty database, import the fob files with the objects.

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