create database dali_123
on
primary (name=dali_123_data1,
filename='c:\data\dali_123_data1.mdf',
size=10mb,
maxsize=20,
filegrowth=2)
log on
(name=dali_123_log1,
filename='c:\data\dali_123_log1.ldf',
size=10mb,
maxsize=20,
filegrowth=2)
go
on
primary (name=dali_123_data1,
filename='c:\data\dali_123_data1.mdf',
size=10mb,
maxsize=20,
filegrowth=2)
log on
(name=dali_123_log1,
filename='c:\data\dali_123_log1.ldf',
size=10mb,
maxsize=20,
filegrowth=2)
go
on
primary (name=dali_123_data1,
filename='c:\data\dali_123_data1.mdf',
size=10mb,
maxsize=20,
filegrowth=2),
(name=dali_123_data2,
filename='c:\data\dali_123_data2.mdf',
size=10mb,
maxsize=20,
filegrowth=2)
log on
(name=dali_123_log1,
filename='c:\data\dali_123_log1.ldf',
size=10mb,
maxsize=20,
filegrowth=2),
(name=dali_123_log2,
filename='c:\data\dali_123_log2.ldf',
size=10mb,
maxsize=20,
filegrowth=2)
go
create database mydb
on primary
(name=my_db_data1,
filenam='c:\temp\my_db_data1.mdf',
size=10,
maxsize=50,
filegrowth=15%)
其中这个filegrowth到底是按照maxsize还是按照size来计算增长值?在什么情况下发生这个增长?