/*
Creates the following:
---------------------------------------------------
System Tables File	log\DBA_sys.mdf
Log File			log\DBA_log.ldf
Data and Index File	data\DBA_data.ndf

PATH		e:\apps\mssql7\

*/
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'DBA')
	DROP DATABASE [DBA]
GO

CREATE DATABASE [DBA]  ON 
	(	NAME = N'DBA_sys', 
		FILENAME = N'e:\apps\MSSQL7\log\DBA_sys.MDF' ,
		SIZE = 5, 
		MAXSIZE = 6, 
		FILEGROWTH = 10%
	) 
	LOG ON 
	(	NAME = N'DBA_Log', 
		FILENAME = N'e:\apps\MSSQL7\log\DBA_Log.LDF' , 
		SIZE = 10, 
		MAXSIZE = 12, 
		FILEGROWTH = 10%
	)
GO
ALTER DATABASE [DBA] ADD FILEGROUP [DataGroup] 
GO
ALTER DATABASE [DBA] ADD FILE
	(	NAME = N'DBA_data', 
		FILENAME = N'e:\apps\MSSQL7\data\DBA_data.NDF' , 
		SIZE = 50, 
		MAXSIZE = 56, 
		FILEGROWTH = 10%
	) 
	TO FILEGROUP [DataGroup]
GO
Alter database DBA modify filegroup DataGroup default
GO

exec sp_dboption N'DBA', N'autoclose', N'false'
GO

exec sp_dboption N'DBA', N'bulkcopy', N'false'
GO

exec sp_dboption N'DBA', N'trunc. log', N'false'
GO

exec sp_dboption N'DBA', N'torn page detection', N'false'
GO

exec sp_dboption N'DBA', N'read only', N'false'
GO

exec sp_dboption N'DBA', N'dbo use', N'false'
GO

exec sp_dboption N'DBA', N'single', N'false'
GO

exec sp_dboption N'DBA', N'autoshrink', N'false'
GO

exec sp_dboption N'DBA', N'ANSI null default', N'false'
GO

exec sp_dboption N'DBA', N'recursive triggers', N'false'
GO

exec sp_dboption N'DBA', N'ANSI nulls', N'false'
GO

exec sp_dboption N'DBA', N'concat null yields null', N'false'
GO

exec sp_dboption N'DBA', N'cursor close on commit', N'false'
GO

exec sp_dboption N'DBA', N'default to local cursor', N'false'
GO

exec sp_dboption N'DBA', N'quoted identifier', N'false'
GO

exec sp_dboption N'DBA', N'ANSI warnings', N'false'
GO

exec sp_dboption N'DBA', N'auto create statistics', N'true'
GO

exec sp_dboption N'DBA', N'auto update statistics', N'true'
GO

use [DBA]
GO