1、在一个数据库里,创建了一个主数据文件,一个次数据文件,还有一个日志文件,我到现在就知道创建,但是
不知道创建 次数据文件有什么用?
2、例如:
create database 商店管理
on
(
name='经销商',
filename='g:\data\经销商_dat.mdf',
size=1mb,
maxsize=unlimited,
filegrowth=5mb
)这里的 name=‘经销商’ 逻辑名有什么用,随便写个可不可以?
不知道创建 次数据文件有什么用?
2、例如:
create database 商店管理
on
(
name='经销商',
filename='g:\data\经销商_dat.mdf',
size=1mb,
maxsize=unlimited,
filegrowth=5mb
)这里的 name=‘经销商’ 逻辑名有什么用,随便写个可不可以?
GO
CREATE DATABASE Archive
ON
PRIMARY ( NAME = Arch1,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\archdat1.mdf',
SIZE = 100MB,
MAXSIZE = 200,
FILEGROWTH = 20),
( NAME = Arch2,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\archdat2.ndf',
SIZE = 100MB,
MAXSIZE = 200,
FILEGROWTH = 20),
( NAME = Arch3,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\archdat3.ndf',
SIZE = 100MB,
MAXSIZE = 200,
FILEGROWTH = 20)
LOG ON
( NAME = Archlog1,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\archlog1.ldf',
SIZE = 100MB,
MAXSIZE = 200,
FILEGROWTH = 20),
( NAME = Archlog2,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\archlog2.ldf',
SIZE = 100MB,
MAXSIZE = 200,
FILEGROWTH = 20)
GO