wallstreetsqlserverdba
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment