In SQL Server 2008 Management Studio, the node of the mirror database appears as follows:
There is no change other than the different status indicator that is described. The icon of the mirror database appears correctly. The icon shows that the database is a mirror database. The icon also shows that the database is in the Synchronized state or in the Restoring state.
If you want to know the exact state of the mirror database on the server, run the following query:
SELECT <DB_NAME>(<database_id>) AS '<DatabaseName>' , mirroring_role_desc , mirroring_state_descFROM sys.database_mirroringWHERE mirroring_guid IS NOT NULL;
For the mirror server, the role appears as "MIRROR" and the state appears as "SYNCHRONIZED" when the state is already synchronized.
The principal server is not affected. The principal server shows the correct icon and status indicator.