FlushCache : New in SQL Server 2012

Starting SQL 2012 we have got something new added to the SQL error logs which was logged earlier when a TF was enabled. Below is the message which is new in the SQL error logs : 2013-09-20 03:01:48.10 spid14s     FlushCache: cleaned up 12773 bufs with 2061 writes in 96736 ms (avoided 11 new dirty bufs)…

0

The subscription(s) have been marked as inactive

While you are troubleshooting the following error : “The subscription(s) have ben marked as inactive” Please make sure you have checked the following : 1. MSSubscriptions  table and the value is showing as zero for the status column http://technet.microsoft.com/en-us/library/ms188368.aspx 2. The subscription for transaction replication have not crossed the max. retention period. 3. You have…

0