用SQL 语言创建一个简单的archive数据库。
来源:百度知道 编辑:UC知道 时间:2024/05/21 07:16:05
主文件位置: C:\Program Files\Microsoft SQL Server\MSSQL\Data\archdat1.mdf
次文件位置: C:\Program Files\Microsoft SQL Server\MSSQL\Data\archdat2.ndf
和C:\Program Files\Microsoft SQL Server\MSSQL\Data\archdat3.ndf
日志文件位置:C:\Program Files\Microsoft SQL Server\MSSQL\Data\archlog1.ldf
和C:\Program Files\Microsoft SQL Server\MSSQL\Data\archlog2.ldf
确实很简单!!!
如果您要创建其他什么的
您可以sql的联机丛书,那里您可以查询语法.
每一个语法那里面都有例子的.
您只要改动几个句子就OK了!
至于您要存的路径,您也只要在那基础上改下就行了!!
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,
FIL