/*------------------------------------------------------------------------------------------------------------

03/03/2009

This script will create the database HR

Before running the script be sure that the data and log files are in the correct path for the drives on the server.

*/

------------------------------------------------------------------------------------------------------------*/


USE master
GO

CREATE DATABASE HR --Name of the database
ON 
( NAME =HR_data, -- Logical name for Data File
   FILENAME = 'C:\dba\datafile\HR_data.mdf', -- Physical location for Data File
   SIZE = 100, -- Initial File Size in MB (Mega Bytes)
   MAXSIZE = 250, -- Maximum File Size in MB (Mega Bytes)
   FILEGROWTH = 10% ) --Filegrowth parameter using percent

LOG ON
( NAME = 'HR_log', -- Logical name for Log File
   FILENAME = 'C:\dba\datafile\HR_log.ldf', -- Physical location for Log File
   SIZE = 100MB, -- Initial Size in MB (Mega Bytes)
   MAXSIZE = 200MB, -- Maximum File Size in MB (Mega Bytes)
   FILEGROWTH = 10MB )--Filegrowth parameter using MB (Mega Bytes)
GO






/*

Compiled by http://www.learningsqlserver2008.com/, Kash Data Consulting LLC 

Disclaimer:

All sample code and scripts are compiled by Kash Data Consulting LLC for illustrative purposes only. Kash Data Consulting LLC, 
therefore, cannot guarantee or imply reliability, or function of this code or scripts.

All code contained herein are provided to you "AS IS" without any warranties of any kind. Please test all code and 
scripts in test environment before deployment in production systems.


*/