how to check primary server in mirroring?
['View the status of the principal and mirror databases.', 'Expand Databases in Management Studio to view the status of the principal and mirror databases. Figure 27.9 shows an example for the principal database.', 'Query the sys.']