Friday 6 March 2020

MS SQL Server create database command by setting file growth size


--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