Link to home
Start Free TrialLog in
Avatar of smith1974
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.
ASKER CERTIFIED SOLUTION
Avatar of mumbaiexperts
mumbaiexperts
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of smith1974
smith1974

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
Test-replicationhealth should give you that.
Hi
This article explains clearly for your doubts
http://www.ntweekly.com/?p=531
ls check it.
thnks.