Here is an T-SQL Query to find the list of all databases mirrored in a particular SQL Server instance.
SELECT [Database Name] = DB.name ,[Recovery Model] = DB.recovery_model_desc ,[Mirroring Status] = CASE WHEN DM.mirroring_state is NULL THEN 'Not Mirrored' ELSE 'Mirrored' END FROM sys.databases DB, sys.database_mirroring DM WHERE DB.database_id=DM.database_id ORDER by name
No comments:
Post a Comment