smith1974
asked on
Check Exchange 2010 Databases
Hi
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks...
So for all servers BERMB1, BERMB2, .....BERMB100, do you know how I can find out:
1. Which server the DB is mounted on (or indeed if it is mounted)
2. The status of its replication health
So for all servers BERMB1, BERMB2, .....BERMB100, do you know how I can find out:
1. Which server the DB is mounted on (or indeed if it is mounted)
2. The status of its replication health
Test-replicationhealth should give you that.
http://technet.microsoft.com/en-us/library/dd351258.aspx