[SQL ] SQL Server- 無法create database
請教大家 以下的SQL 在SQL Server中執行有錯誤:
CREATE DATABASE [MyTest] ON (NAME = N'MyTest_Data', FILENAME = N'C:\Program
Files\Microsoft SQL Server\MSSQL\data\MyTest_Data.MDF' , SIZE = 2, FILEGROWTH
= 10%) LOG ON (NAME = N'MyTest_Log', FILENAME = N'C:\Program Files\Microsoft
SQL Server\MSSQL\data\MyTest_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
COLLATE Chinese_Taiwan_Stroke_CI_AS
錯誤訊息是:
Msg 1803, Level 16, State 1, Line 1
The CREATE DATABASE statement failed. The primary file must be at least 3 MB
to accommodate a copy of the model database.
請教大家我該如何解這問題?~
謝謝!
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 61.216.172.151
→
08/16 01:36, , 1F
08/16 01:36, 1F
→
08/17 17:42, , 2F
08/17 17:42, 2F
→
08/18 14:46, , 3F
08/18 14:46, 3F
→
08/18 15:11, , 4F
08/18 15:11, 4F
推
08/18 21:20, , 5F
08/18 21:20, 5F