You’re offline. This is a read only version of the page.
35
Hi,
we want to get rid of some old databases... Some of them are AX 2012 Model databases.
Is there a way to make sure, no AOS is connected these instances? Maybe a SQL script or something?
Thanks in advance
Frank
SysClientSession, SysServerSession table in business database might be other useful tables to check if it is used recently.
Hi,
thank you! Good idea :)!
If an AOS is connected, then you can't delete the database since it's in use.
But that's not a very good way to determine whether the database is needed or not. The AOS might be off right now, but it's still a dev / test environment that is used.
A model database and a business database always belong together. You could check SysServerConfig table in the business database, to find out some hints about the AOS server that is using this database. Then find out if the server is still used for dev / test purposes.
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...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (