title: How do I specify a recovery model (full, simple or bulk-logged) when creating a database in T-SQL code?
body: <p>How do I specify a recovery model (full, simple or bulk-logged) when creating a database in a CREATE DATABASE query in T-SQL code?</p>