作者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