the admin subsystem - Page 2

Modify the <filespec> settings to suit your environment. For most folks, the file path will be the only required modification.

CREATE DATABASE admin
 ON PRIMARY
 ( NAME = admin_Data,
   FILENAME = 'D:\MSSQL7\data\admin_Data.MDF',
   SIZE = 1600 KB,
   MAXSIZE = Unlimited,
   FILEGROWTH = 10% )
 LOG ON
 ( NAME = admin_Log,
   FILENAME = 'd:\MSSQL7\data\admin_Log.LDF',
   SIZE = 1024 KB,
   MAXSIZE = Unlimited,
   FILEGROWTH = 10% )