We have 100 Databases in our DAG within Germany.
All Databases have named BERMB1, BERMB2, .....BERMB100.
They are all part of DAG : BERDAG01.
I would like on each morning to run a quite script that will tell me:
i. That each DB is mounted
ii. The each DB is replicating ok
iii. That each DB is good for connecvitivity
Can anyone think of any other test that maybe worthwhile?
And what script would I run that would return the above, per DB? I would like it all listed along with the DB name.
Any help appreciated.