database mirroring - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

database mirroring

Author

Topic

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2010-11-17 : 03:04:51

hi,

i had setup the database mirroring and its running. now how to confirm that. wht opeartin shd be done on princiapl database. and see in mirror database

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-17 : 11:58:44

You can't query the mirror database to check it. You'll need to use the database mirroring monitor to check if it's up to date.

And for a test, you could do a test failover.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-11-17 : 13:13:01

Check the sys.database_mirroring table. I use the following query for quick status checks:

select @@servername server, db_name(database_id) DB, mirroring_state_desc state,
mirroring_role_desc role, mirroring_partner_instance partner, 
mirroring_witness_name witness, mirroring_witness_state_desc witness_state
from sys.database_mirroring 
where mirroring_guid is not null 
order by DB

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources