創(chuàng)建一個名為TEST2的數(shù)據(jù)庫，它有2個數(shù)據(jù)文件，其中主數(shù)據(jù)文件為100MB，最大大小為200MB，按20MB增長；1個輔助數(shù)據(jù)文件為20MB，最大大小不限，按10%增長；有2個日志文件，大小均為50MB，最大大小均為100MB,按10MB增長。

create database db_test2on ( name='test_data1', filename='D:/PRogram Files (x86)/Microsoft Office/db_test2.mdf', size=5MB, maxsize=50MB, filegrowth=10%),( name='test_data2', filename='D:/Program Files (x86)/Microsoft Office/db_test2.mdf', size=5mb, maxsize=unlimited, filegrowth=10%)log on ( name='test_log1', filename='D:/Program Files (x86)/Microsoft Office/test_log1.ldf', size=2mb, maxsize=5MB, filegrowth=1MB),( name='test_llog2', filename='D:/Program Files (x86)/Microsoft Office/test_log2.ldf', size=50mb, maxsize=100mb, filegrowth=10mb)go