Notifications
Announcements
No record found.
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
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.
Hi,
thank you! Good idea :)!
SysClientSession, SysServerSession table in business database might be other useful tables to check if it is used recently.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 544 Most Valuable Professional
André Arnaud de Cal... 450 Super User 2025 Season 2
Sohaib Cheema 250 User Group Leader
