create database studentonprimary(name=stu1, filename='D:\mssqldata\studat1.mdf', size=50MB, maxsize=200, filegrowth=10),(name=stu2, filename='D:\mssqldata\studat2.ndf', size=50MB, maxsize=200, filegrowth=10),filegroup stugroup1(name=stugrp1_data1, filename='D:\mssqldata\stugrp1_data1.ndf', size=10, maxsize=50, filegrowth=5%),(name=stugrp1_data2, filename='D:\mssqldata\stugrp1_data2.ndf', size=10, maxsize=50, filegrowth=5%)log on(name=stulog1, filename='D:\mssqldata\stulog1.ldf', size=50MB, maxsize=100MB, filegrowth=5MB)go