USE master
GO
CREATE DATABASE students
ON
PRIMARY ( NAME = student1,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\student1.mdf',
SIZE = 200MB,
FILEGROWTH = 10),
( NAME = student2,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\student2.ndf',
SIZE = 100MB,
FILEGROWTH = 1mb)
LOG ON
( NAME = studentlog1,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\studentlog1.ldf',
MAXSIZE = 50,
FILEGROWTH = 1mb),
( NAME = studentlog2,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\studentlog2.ldf',
MAXSIZE = 50,
FILEGROWTH = 1mb)
GO
GO
CREATE DATABASE students
ON
PRIMARY ( NAME = student1,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\student1.mdf',
SIZE = 200MB,
FILEGROWTH = 10),
( NAME = student2,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\student2.ndf',
SIZE = 100MB,
FILEGROWTH = 1mb)
LOG ON
( NAME = studentlog1,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\studentlog1.ldf',
MAXSIZE = 50,
FILEGROWTH = 1mb),
( NAME = studentlog2,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\studentlog2.ldf',
MAXSIZE = 50,
FILEGROWTH = 1mb)
GO
一个数据库可以有多个副数据文件,副数据文件的扩展名是.NDF应该是题目有问题,而且日志文件总是按顺序访问的,一个文件装满后,再切换到下一个文件。多个事物日志文件并不能提高性能,只能增加日志的长度。