作者zgccgz (hello)
看板Database
標題[SQL ] SQL Server- 無法create database
時間Tue Aug 16 00:45:55 2011
請教大家 以下的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
1F：→ ChingLan326:size=3 08/16 01:36
2F：→ zgccgz:謝謝你~ 08/17 17:42
3F：→ ChingLan326:所以改成3真的就可以了? 08/18 14:46
4F：→ zgccgz:嗯 真的可以~ 哈~ 3q3q~ 08/18 15:11
5F：推 ChingLan326:那這樣...答案不就已經在錯誤訊息裡了嗎.... 08/18 21:20