用SQL 语言创建一个简单的archive数据库。
发布网友
发布时间:2022-09-30 11:55
我来回答
共2个回答
热心网友
时间:2024-10-24 14:23
CREATE DATABASE Archive
ON
PRIMARY ( NAME = archdat1,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\archdat1.mdf',
SIZE = 10MB,
MAXSIZE = 20,
FILEGROWTH = 2),
( NAME = archdat2,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\archdat2.ndf',
SIZE = 10MB,
MAXSIZE = 20,
FILEGROWTH = 2),
( NAME = archdat,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\archdat3.ndf',
SIZE = 10MB,
MAXSIZE = 20,
FILEGROWTH = 2)
LOG ON
( NAME = Archlog1,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\archlog1.ldf',
SIZE = 10MB,
MAXSIZE = 20,
FILEGROWTH = 2),
( NAME = Archlog2,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\archlog2.ldf',
SIZE = 10MB,
MAXSIZE = 20,
FILEGROWTH = 2)
GO
参考资料:太简单的,还要参考资料吗?
热心网友
时间:2024-10-24 14:24
确实很简单!!!
如果您要创建其他什么的
您可以sql的联机丛书,那里您可以查询语法.
每一个语法那里面都有例子的.
您只要改动几个句子就OK了!
至于您要存的路径,您也只要在那基础上改下就行了!!