You’re offline. This is a read only version of the page.
662
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?
Thank you.
Thank you!!
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.
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.
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.
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,900
Super User 2024 Season 2
#2
Martin Dráb
229,275
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (