恩 这个是写论文的 但电脑实在不是我的专业啊 真的是搞不懂 求各位高人指点指点 有错的地方请尽管指出 在下不胜感激!!CREATE DATABASE 教务管理数据库
ON (
NAME = 'Senate',
filename = 'd:\sql data\Senate_data1.mdf',
size = 1,
maxsize = unlimited,
filegrowth = 10% ),
filegroup data2
( filename = 'd:\sql data\Senate_data2.ndf',
size = 2,
maxsize = 100,
filegrowth = 1 ),
filegroup data3
( filename = 'd:\sql data\Senate_data3.ndf',
size = 3,
maxsize = 50,
filegrowth = 500kb )
log on
(
NAME = 'Senate',
filename = 'd:\sql data\Senate_log1.ldf',
size = 1mb,
maxsize = 25mb,
filegrowth = 10% ),
(
filename = 'd:\sql data\Senate_log2.ldf',
size = 1mb,
maxsize = 10mb,
filegrowth = 10% ),
(
filename = 'd:\sql data\Senate_log3.ldf',
size = 1mb,
maxsize = 5mb,
filegrowth = 512kb )
--------------------------------------------------------------------------------------
务器: 消息 1036,级别 16,状态 2,行 1
在此 CREATE/ALTER DATABASE 语句中需要文件选项 NAME。
服务器: 消息 1036,级别 16,状态 1,行 1
在此 CREATE/ALTER DATABASE 语句中需要文件选项 NAME。
服务器: 消息 1036,级别 16,状态 1,行 1
在此 CREATE/ALTER DATABASE 语句中需要文件选项 NAME。
服务器: 消息 1036,级别 16,状态 1,行 1
在此 CREATE/ALTER DATABASE 语句中需要文件选项 NAME。
ON (
NAME = 'Senate',
filename = 'd:\sql data\Senate_data1.mdf',
size = 1,
maxsize = unlimited,
filegrowth = 10% ),
filegroup data2
( filename = 'd:\sql data\Senate_data2.ndf',
size = 2,
maxsize = 100,
filegrowth = 1 ),
filegroup data3
( filename = 'd:\sql data\Senate_data3.ndf',
size = 3,
maxsize = 50,
filegrowth = 500kb )
log on
(
NAME = 'Senate',
filename = 'd:\sql data\Senate_log1.ldf',
size = 1mb,
maxsize = 25mb,
filegrowth = 10% ),
(
filename = 'd:\sql data\Senate_log2.ldf',
size = 1mb,
maxsize = 10mb,
filegrowth = 10% ),
(
filename = 'd:\sql data\Senate_log3.ldf',
size = 1mb,
maxsize = 5mb,
filegrowth = 512kb )
--------------------------------------------------------------------------------------
务器: 消息 1036,级别 16,状态 2,行 1
在此 CREATE/ALTER DATABASE 语句中需要文件选项 NAME。
服务器: 消息 1036,级别 16,状态 1,行 1
在此 CREATE/ALTER DATABASE 语句中需要文件选项 NAME。
服务器: 消息 1036,级别 16,状态 1,行 1
在此 CREATE/ALTER DATABASE 语句中需要文件选项 NAME。
服务器: 消息 1036,级别 16,状态 1,行 1
在此 CREATE/ALTER DATABASE 语句中需要文件选项 NAME。
ON (
NAME = N'Senate',
filename = 'd:\sql data\Senate_data1.mdf',
size = 3,
maxsize = unlimited,
filegrowth = 10% ),
filegroup data2
( Name = N'Senate2', filename = 'd:\sql data\Senate_data2.ndf',
size = 2,
maxsize = 100,
filegrowth = 1 ),
filegroup data3
( Name = N'Senate3', filename = 'd:\sql data\Senate_data3.ndf',
size = 3,
maxsize = 50,
filegrowth = 500kb )
log on
(
NAME = 'Senate_log',
filename = 'd:\sql data\Senate_log1.ldf',
size = 1mb,
maxsize = 25mb,
filegrowth = 10% ),
(
name = 'Senate2_log', filename = 'd:\sql data\Senate_log2.ldf',
size = 1mb,
maxsize = 10mb,
filegrowth = 10% ),
( name = 'Senate3_log',
filename = 'd:\sql data\Senate_log3.ldf',
size = 1mb,
maxsize = 5mb,
filegrowth = 512kb )
CREATE DATABASE database_name
[ ON
[ < filespec > [ ,...n ] ]
[ , < filegroup > [ ,...n ] ]
]
[ LOG ON { < filespec > [ ,...n ] } ]
[ COLLATE collation_name ]
[ FOR LOAD | FOR ATTACH ] < filespec > ::=[ PRIMARY ]
( [ NAME = logical_file_name , ] ---logical_file_name
FILENAME = 'os_file_name'
[ , SIZE = size ]
[ , MAXSIZE = { max_size | UNLIMITED } ]
[ , FILEGROWTH = growth_increment ] ) [ ,...n ]< filegroup > ::=FILEGROUP filegroup_name < filespec > [ ,...n ]
ON (
NAME = 'Senate',
filename = 'd:\sql data\Senate_data1.mdf', ---请把里面的''的东西改成 c:\senate_data10.mdf
size = 1,
maxsize = unlimited,
filegrowth = 10% ),
filegroup data2
( filename = 'd:\sql data\Senate_data2.ndf', ---请把里面的''的东西改成 c:\senate_data10.ndfsize = 2,
maxsize = 100,
filegrowth = 1 ),
filegroup data3
( filename = 'd:\sql data\Senate_data3.ndf', --- 请把里面的''的东西改成 c:\senate_data30.ndfsize = 3,
maxsize = 50,
filegrowth = 500kb )
log on
(
NAME = 'Senate',
filename = 'd:\sql data\Senate_log1.ldf', ---请把里面的''的东西改成 c:\Senate_log10.ldfsize = 1mb,
maxsize = 25mb,
filegrowth = 10% ),
(
filename = 'd:\sql data\Senate_log2.ldf', ---请把里面的''的东西改成 c:\Senate_log20.ldf
size = 1mb,
maxsize = 10mb,
filegrowth = 10% ),
(
filename = 'd:\sql data\Senate_log3.ldf', --- 请把里面的''的东西改成 c:\Senate_log30.ldf
size = 1mb,
maxsize = 5mb,
filegrowth = 512kb )
其他的没有必要改 另外需要提示你的这个脚本 仅仅能执行一次在同一个计算机的,如果你要执行第二次需要把 数据库名字改了 需要把 每个标注后面的文件名在加一个0