How to see the current recovery model for a databaseKarthikeyan Anbarasan15yPublished Mar 29, 2011, 12:00 AMUpdated Mar 30, 2011, 1:25 AM2.9k00Reactions×25BlogSELECT [name],state_desc,recovery_model_desc FROM sys.databasesCommentsJoin the conversation! Your thoughts help the community grow.Sign in to leave a commentIt is the same account you read, post and publish with — and you will come straight back to this page.Sign inCreate an account
Join the conversation! Your thoughts help the community grow.