--Create database command by setting file growth size
CREATE DATABASE [fixed_size]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'auto_fixed_size',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SMRPLM\MSSQL\DATA\auto_fixed_size.mdf' ,
SIZE = 1024000KB , --<< initial size of data file 1000mb
FILEGROWTH = 102400KB )
LOG ON
( NAME = N'auto_fixed_size',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SMRPLM\MSSQL\DATA\auto_fixed_size.ldf' ,
SIZE = 102400KB ,
FILEGROWTH = 102400KB ) --<< growth by 100mb (PRE SIZED SO THAT THE AUTO GROWTH DOES NOT ACTIVATE)
GO
DBCC LogInfo
No comments:
Post a Comment