I have the following script that creates a MS SQL database programmatically,
written primarily by an associate of mine, that works. Now I need to populate
the database with the default content.

What would be the best way of creating the DB:

1. Use "restore" of a backup file from a Db that I would like to replicate
(and how would I accomplish this?)
2. Is there a DB copy command in SQL that works like CREATE DATABASE?

Here's the create database scripts:

<cfquery name="qc" datasource="#request.ds#">
create database {db_name}
</cfquery>
<cfquery name="qc" datasource="#request.ds#">
sp_addlogin @loginame='{username}, @passwd='{password}', @defdb='{db_name}'
</cfquery>
<cfquery name="qc" datasource="#request.ds#">
use {db_name}
</cfquery>
<cfquery name="qc" datasource="#request.ds#">
sp_adduser @loginame='{username}'
</cfquery>
<cfquery name="qc" datasource="#request.ds#">
sp_addrolemember @rolename='db_datareader', @membername='{username}'
</cfquery>
<cfquery name="qc" datasource="#request.ds#">
sp_addrolemember @rolename='db_datawriter', @membername='{username}'
</cfquery>

At this point can I just pump in the BACKUP file from a DB I'd like to copy
into this new database?

Any advice would be great.