Thanks Lowell,

In above script, I want to check the current recovery model of the database and then set to SIMPLE.

Please advice.