CREATE DATABASE mydb2ON PRIMARY( name="mydb2", /*主数据文件的逻辑名*/ filename="D:/Program Files/Microsoft SQL Server/MSSQL13.MSSQLSERVER/MSSQL/DATA/mydb2.mdf",/*.mdf 主数据文件储存位置*/ size=5mb, maxsize=100mb, filegrowth=15% /*增长率*/)log on( /***日志文件****/ name="mydb2_log", /*必须以_log 结尾**/ filename="D:/Program Files/Microsoft SQL Server/MSSQL13.MSSQLSERVER/MSSQL/DATA/mydb2_log.ldf", size=2mb, filegrowth=1mb )
新闻热点
疑难解答