用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了!
至于您要存的路径,您也只要在那基础上改下就行了!!