SQL: Resume Database mirroring

alter database <database_name> set partner resume

SQL: when it was last used

SELECT accdate, name FROM master.dbo.syslogins

Viewing the Safety Setting and State of the Witness

SELECT mirroring_safety_level_desc, mirroring_witness_name, mirroring_witness_state_desc FROM sys.database_mirroring

 

Check the recovery model of the databases

SELECT name, recovery_model_desc

FROM sys.databases

How check what is preventing your transaction log from being truncated

What might be preventing your transaction log from being truncated:

SELECT name, log_reuse_wait_desc

FROM sys.databases