Skip to main content
Microsoft Dynamics NAV forum
Answered

How do I determine which database I'm using - Navision 2018

editSubscribe (0) ShareShare
ReportReport
Posted on by 660

HI all,

I'm in a fix. I have several database in my server. While I know which one is live, I'm not sure which of the test databases are meant for testing, and which one is for back ups.

May  I ask how do I determine this?

server-name.JPG

Thank you.

  • joshlabtech Profile Picture
    joshlabtech 660 on at
    RE: How do I determine which database I'm using - Navision 2018

    Thank you!!

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,636 on at
    RE: How do I determine which database I'm using - Navision 2018

    You can check in NAV Administration Tool, what server instances are running and when you select them you can check under database the database names.

  • joshlabtech Profile Picture
    joshlabtech 660 on at
    RE: How do I determine which database I'm using - Navision 2018

    Hi Steve,

    It was done by my predecessor, without leaving any documentation.

    There is no such things as right click properties, to see when was db created and modified?

    Thank you.

  • joshlabtech Profile Picture
    joshlabtech 660 on at
    RE: How do I determine which database I'm using - Navision 2018

    Hi Suresh,

    May  I know how and where can I view this "what NAV service tiers are running and which database they are using it."

    Thank you.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,636 on at
    RE: How do I determine which database I'm using - Navision 2018

    Hi, 

    There is no indication to tell which one is active or not, that is something who creates or maintains database needs to handle. One thing you could check is what NAV service tiers are running and which database they are using it.

  • Suggested answer
    Community Member Profile Picture
    Community Member UG Leader on at
    RE: How do I determine which database I'm using - Navision 2018

    Josh,

    This is a pickle. I too have many databases setup but I keep the names different and include a Date to define which is newer. Did you create these or did a Partner? If your Partner you might ask them which was the latest backup that you can test in with up-to-date data. If you cannot determine and logging into each does not tell you my next question is was your Test database different from PROD, meaning was there objects that you are about to test in TEST vs. PROD. If not, you might consider taking a backup of PROD and starting over with a new TEST database and naming it as such.

    In the pic you provided the ones called NAVAUTEST.. I would examine just to see how recent the data is.

    Hope this helps.

    Thanks,

    Steve

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,045 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,570 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans