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.
#1
André Arnaud de Cal...
293,280
Super User 2025 Season 1
#2
Martin Dráb
232,038
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
