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.
smith1974Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mumbaiexpertsCommented:
Hi
Use the two commands to check the status of the database
Here are the two commands that I use:

Get-MailboxDatabaseCopyStatus - http://technet.microsoft.com/en-us/library/dd298044.aspx

Test-ReplicationHealth - http://technet.microsoft.com/en-us/library/bb691314.aspx
Thnks.

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RadweldCommented:
0
smith1974Author Commented:
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
0
RadweldCommented:
Test-replicationhealth should give you that.
0
mumbaiexpertsCommented:
Hi
This article explains clearly for your doubts
http://www.ntweekly.com/?p=531
ls check it.
thnks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Exchange

From novice to tech pro — start learning today.