Monday, April 16, 2012

Check auto page repair history

-- Check auto page repair history (New in SQL 2008)

SELECT DB_NAME(database_id) AS [database_name], database_id, file_id, page_id, error_type, page_status, modification_time
FROM sys.dm_db_mirroring_auto_page_repair

No comments:

Post a Comment