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 )
新聞熱點
疑難解答