Looking into the various ways you can find out the Recovery model of databases in an SQL Server instance
This is going to be a rather short post. I have been teaching the Official Microsoft SQL Server courses in my capacity as MCT and to be totally honest with you I enjoy it very much.One of my favorite subject is Backup & Restore. This is maybe the main DBA task.There is no way to explain adequately Backup & Restore without talking about Recovery models.Well some people in the class did not know how to find the recovery model for each database in the server. Another common question is how to find out the recovery models for all databases at once. (
read more)