-- =============================================
-- create database on mulitple file groups
-- =============================================
if exists (select * 
           from   master..sysdatabases 
           where  name = n'<database_name, sysname, TestDB>')
	drop database <database_name, sysname, TestDB>
go

create database <database_name, sysname, TestDB>
on primary
	( name = <logical_file_name_1, , TestDB_data>,
	  filename = n'<os_file_name_1, , c:\program files\microsoft sql server\mssql\data\TestDB_dat.mdf>',
          size = 10mb,
          maxsize = 200mb,
          filegrowth = 10%),

log on
	( name = <logical_log_file_name_1, , TestDB_Log>,
	  filename = n'<os_log_file_name_1, , c:\program files\microsoft sql server\mssql\data\TestDB_log.ldf>',
          size = 2.5mb,
          maxsize = 50mb,
          filegrowth = 10%)
go