I just noticed after I removed the with no_log option on my backup it has not worked. What should I put in its place after removing the no_log option?;)

Thank you very much for your expertise. I have one dbase that is set to simple instead of full. I would like it to be full. How...

Can you please tell me where in SQL would I verify if the dbase is setup for recovery mode?