CREATE DATABASE 时想到的问题
USE master
GO
CREATE DATABASE SQLStudy
ON
PRIMARY (NAME = SQLStudy_Data1,
FILENAME = 'D:\Microsoft SQL Server\MSSQL\Data\sqlstudy_Data1.mdf',
SIZE = 10,
FILEGROWTH = 10%),
(NAME = SQLStudy_Data2,
FILENAME = 'D:\Microsoft SQL Server\MSSQL\Data\sqlstudy_Data2.mdf',
SIZE = 10,
FILEGROWTH = 10%),
(NAME = SQLStudy_Data3,
FILENAME = 'D:\Microsoft SQL Server\MSSQL\Data\sqlstudy_Data3.mdf',
SIZE = 10,
FILEGROWTH = 10%)
LOG ON
(NAME = SQLStudy_Log1,
FILENAME = 'D:\Microsoft SQL Server\MSSQL\Data\sqlstudy_Log.ldf',
SIZE = 10,
FILEGROWTH = 10%),
(NAME = SQLStudy_Log2,
FILENAME = 'D:\Microsoft SQL Server\MSSQL\Data\sqlstudy_Log2.ldf',
SIZE = 10,
FILEGROWTH = 10%),
(NAME = SQLStudy_Log3,
FILENAME = 'D:\Microsoft SQL Server\MSSQL\Data\sqlstudy_Log3.ldf',
SIZE = 10,
FILEGROWTH = 10%)
GO
以上的语句执行后成功,但是我想不通的是:
三个DATA文件和三个LOG文件,他们之间到底什么关系。数据库数据存储的时候是同时写入到这些文件里面,还是不同的内容存入不同的DATA文件中。这样建立一个数据库,主要是为了解决什么问题?有什么优化的功能是一个数据文件不能达到的?