Chapter 3 PHYSICAL DATABASE DESIGN AND IMPLEMENTATION 113
Chapter 3 PHYSICAL DATABASE DESIGN AND IMPLEMENTATION 113 STEP BY STEP 3.1 Creating a Database Using the Create Database Wizard 1. Expand a server group, and then select the server in which to create a database. 2. On the Tools menu, click Wizards. 3. Expand Database. 4. Double-click Create Database Wizard. 5. Complete the steps in the wizard. Or, if you prefer to use the Enterprise Manager: STEP BY STEP 3.2 Creating a Database Using the Enterprise Manager 1. Expand a server group and then the server where the database is to be placed. 2. Right-click Databases, and then click New Database. 3. Enter a name for the database. 4. To specify how any specific file should grow, switch to the Data Files or Transaction Log tabs, highlight the file, select Automatically Grow File, then choose In Megabytes or By Percent and specify a value. To specify the file size limit, select Unrestricted Filegrowth or Restrict Filegrowth (MB) and specify a value. To use T-SQL to create a database, use this code: CREATE DATABASE MyDatabase ON (NAME = DataStore , FILENAME = d:data directoryDataStore_MyDatabase.mdf , SIZE = 1MB, MAXSIZE = 5MB, FILEGROWTH = 1MB) LOG ON continues
For high quality jboss hosting services please check jboss web hosting website.