Chef recipe for sql database

I am trying take database offline in my test environment using chef. but not sure what will be the steps after update the recipe . can any one help me?

I am trying to take offline DB in 2 node. let me know if you want to know more details

thanks in advance