Check DB Mirroring Status

2012-02-10T05:02:00.000-08:00

Database mirroring is a primarily software solution for increasing database availability. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model. The simple and bulk-logged recovery models do not support database mirroring. Database mirroring is supported in SQL Server Standard and Enterprise.

Database mirroring offers a substantial improvement in availability over the level previously possible using Microsoft SQL Server and provides an easy-to-manage alternative or supplement to failover clustering or log shipping. When a database mirroring session is synchronized, database mirroring provides a hot standby server that supports rapid failover with no loss of data from committed transactions. During a typical mirroring session, after a production server fails, client applications can recover quickly by reconnecting to the standby server.

Note
You cannot mirror the master, msdb, temp, or model databases.

select DB_Name(database_id) as DBName,
mirroring_role_desc,mirroring_state_desc,
mirroring_safety_level_desc,mirroring_connection_timeout
from sys.database_mirroring
where mirroring_guid is not null

Check DB Owner Name

2012-02-10T01:37:00.000-08:00

We have successfully setup the mirroring between our primary site SQ1 and SQ02 servers. We have also configured the log shipping from our primary site to our secondary/DR site. It is working fine and we equal no of DBs available on DR site SQL server. These DBs are read only as per the log shipping configuration.

Now, at primary site user “A” is the owner of DBs but at DR site user “B” is the DB owner. seems this attribute is not getting replicated to DR site and we are not able to change the owner manually as DB is read only.

Is there any way to change the DB owner name at DR site without stopping the log shipping ?Yes,As shown in this query you can get owner name.

SELECT SUSER_SNAME(owner_sid) as Owner,* FROM sys.databases

MS SQL SERVER 2008

Check DB Mirroring Status

Check DB Owner Name