CREATE DATABASE Sales
ON
PRIMARY(NAME=Sales.data,FILENAME='C:\mssql\data\Sales.mdf',
SIZE=10MB,
MAXSIZE=20MB,
FILEGROWTH=20%)
LOG ON
(NAME=Sales.log,FILENAME='C:\mssql\data\Sales.ldf',
SIZE=2MB,
MAXSIZE=10MB,
FILEGROWTH=1MB)
ON
PRIMARY(NAME=Sales.data,FILENAME='C:\mssql\data\Sales.mdf',
SIZE=10MB,
MAXSIZE=20MB,
FILEGROWTH=20%)
LOG ON
(NAME=Sales.log,FILENAME='C:\mssql\data\Sales.ldf',
SIZE=2MB,
MAXSIZE=10MB,
FILEGROWTH=1MB)
解决方案 »
- sql server
- 异地还原问题。
- sql无限极树的问题
- 哪位兄弟进来给小弟讲一下有关sql触发器的概念和用途
- 我在跨服务器导数据时出现下面问题,请各位帮助
- 请教:在SQL Server下如何选择某个表中除某列外的其他列
- 一个数字型的字段,保存数据时,如果没有数据,我在程序里把他设置为了-1,得到dataset帮定datagrid时却显示了-1,这时本应该为空才对,
- 读远程execl文件
- sql server 2005出现的问题
- 谁用过ERwin这个软件来设计数据库?跟用visio、sql server哪个好?越多参考越好!
- 怎么让select curren_user结果是nt验证登陆的用户名?
- 菜鸟一问
ON
PRIMARY(NAME=db_lx_data,FILENAME='D:\Microsoft SQL Server\MSSQL\Data\db_lx_data.mdf',
SIZE=10MB,
MAXSIZE=20MB,
FILEGROWTH=20%)
LOG ON
(NAME=db_lx_log,FILENAME='D:\Microsoft SQL Server\MSSQL\Data\db_lx_log.ldf',
SIZE=2MB,
MAXSIZE=10MB,
FILEGROWTH=1MB);
GO
ON
( NAME = Sales_dat,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\saledat.mdf',
SIZE = 1,
MAXSIZE = 5,
FILEGROWTH = 5 )
LOG ON
( NAME = 'Sales_log',
FILENAME = 'c:\program files\microsoft sql server\mssql\data\salelog.ldf',
SIZE = 1MB,
MAXSIZE = 5MB,
FILEGROWTH = 5MB )
GO在WIN2000+SQL SERVER2000下运行通过。
ON
PRIMARY(NAME=Sales.data,FILENAME='C:\mssql\data\Sales.mdf'
SIZE=10MB
MAXSIZE=20MB
FILEGROWTH=20%)
LOG ON
(NAME=Sales.log,FILENAME='C:\mssql\data\Sales.ldf'
SIZE=2MB
MAXSIZE=10MB
FILEGROWTH=1MB)执行后报错如下:
服务器:消息 153,级别 15 ,状态 1, 行 4
在CREATE/ALTER DATABASE语句中有SIZE选项的无效使用请问怎么解决?
[ ON
[ < filespec > [ ,...n ] ]
[ , < filegroup > [ ,...n ] ]
]
[ LOG ON { < filespec > [ ,...n ] } ]
[ COLLATE collation_name ]
[ FOR LOAD | FOR ATTACH ] < filespec > ::=[ PRIMARY ]
( [ 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
PRIMARY(NAME=Sales.data,FILENAME='C:\mssql\data\Sales.mdf',
SIZE=10MB,
MAXSIZE=20MB,
FILEGROWTH=20%)
LOG ON
(NAME=Sales.log,FILENAME='C:\mssql\data\Sales.ldf',
SIZE=2MB,
MAXSIZE=10MB,
FILEGROWTH=1MB)