Policy Based Management to check database recovery model to be Simple in Simple Steps:
1. Create a Condition based on a Facet of Database
2. Now Create a policy using the condition created above to evaluate on Demand
3.Now Evaluate the above policy to check any deviations:
4.Output will look like this, showing Red mark on database with any deviations
Learn about SQL Server detecting logical consistency based issues and how to resolve them.
Learn about SQL Server error 1222 and how to resolve the lock request time out…
Discover the new features of Microsoft SQL Server 2022 and how they compare to previous…
SQL Server Error 1222 lock request time out period exceeded Lock request time out…
SQL Server Error : 427, Severity: 20. Could not load the definition for constraint ID…
SQL Server Error : 204, Severity: 20. Normalization error in node %ls.
This website uses cookies.