|
Step 2: Create the SAMPLE Database
- Create the SAMPLE database.
Use SQLServer's Enterprise Manager GUI, or using SQLServer's Query Analyzer,
execute this command to create the sample database. The command is shown on multiple lines for clarity, but should
be entered as one command:
- create database SAMPLE
on primary (name = 'SAMPLE', filename = '<Some_Dir>\SAMPLE_Data.mdf', size = 10MB, maxsize = 30 MB, filegrowth
= 5MB) log on (name = 'SAMPLE_Log', filename = '<Some_Dir>\SAMPLE_Log.ldf',
size = 5MB, maxsize = 20MB, filegrowth = 5MB)
Note:
- The filename is the actual path to an OS file.
- <Some_Dir> should be an existing directory -- a common place is "<SQLServer_Root>\data"
-- on the SQLServer server. The command creates the file "SAMPLE_Data.mdf"
and "SAMPLE_Log.ldf" in the directory specified.
Please see SQLServer documentation for more information on SQLServer's
Enterprise Manager and Query Analyzer tools.
 
- Alternatively, you can create a database with any name you choose. Whatever name you give it, specify the same database name in Steps 3 and 4 when you create the corresponding DataSource object.
|