Posts

Showing posts from September, 2016

LOG FILE OF PRINCIPAL DATABASE IS GROWING ABNORMALLY IN MIRRORING.

Whenever there is any active transactions or REBUILD INDEXES activities are going there is a chance of log file growth in that particular principal database where that database has been participated in Mirroring. It means whenever Mirror database falls behind Principal please do the below steps.And if the amount of ACTIVE LOG is growing abnormally we can do the below steps 1) Stop Database Mirroring 2) Take the log backup that truncates the log and restore that in Mirroring WITH NORECOVERY option. 3)And RESTART the mirroing ---How to find how many databases are in mirroring state. SELECT A. name , CASE      WHEN B.mirroring_state is NULL THEN 'Mirroring not configured'      ELSE 'Mirroring configured' END as MirroringState FROM sys.databases A INNER JOIN sys.database_mirroring B ON A.database_id=B.database_id WHERE a.database_id > 4 ORDER BY A. NAME --How to check...