USE master
GO
CREATE DATABASE DB1
ON PRIMARY
(   NAME='DB1_Data',
    FILENAME='C:\Database\DB1_Data.MDF',
    SIZE=20MB,
    MAXSIZE=UNLIMITED,
    FILEGROWTH=10% )
LOG ON
(   NAME='DB1_Log',
    FILENAME='C:\Database\DB1_Log.LDF',
    SIZE=10MB,
    MAXSIZE=UNLIMITED,
    FILEGROWTH=10% )
GO
EXEC sp_dboption 'SchedDb','trunc. log on chkpt.',true
GO