create database EMSI01
on primary(//容易写错
name='EMSI01',
filename='G:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\EMSI01.mdf',
size=10MB,
maxsize=100MB,
filegrowth=5MB
)
log on(
name='EMSI01_log',
filename='G:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\EMSI01_log.ldf',
size=10MB,
maxsize=100MB,
filegrowth=5MB
)
在数据库EMIS1中;把日志文件初始大小修改为10MB,增长量为每次增长5MB,最大大小保持不变。
最新推荐文章于 2023-07-12 10:12:08 发布