MS SQL Server Create database command with auto growth

Use master
go

CREATE DATABASE [auto_growth]
 CONTAINMENT = NONE
 ON  PRIMARY
( NAME = N'auto_growth',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SMRPLM\MSSQL\DATA\auto_growth.mdf' ,
SIZE = 3072KB ,      --<< initial size of data file 3mb     
FILEGROWTH = 1024KB )  --<< growth by 1mg

 LOG ON
( NAME = N'auto_log',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SMRPLM\MSSQL\DATA\auto_growth_log.ldf' ,
SIZE = 1024KB ,    --<< initial size of log file 1mb
FILEGROWTH = 10%)  --<< growth by 10%
GO

DBCC LogInfo;

Restore Adventure works DB backup on MSSQL Server 2017 DB using GUI Method

step 1




Step 2 :



STEP 3:





STEP 4:




STEP 5 :





STEP 6:

Query to check recovery model in MSSQL Server Database

Query to check recovery model in database excluding  'master','model','tempdb','msdb'


select [name], DATABASEPROPERTYEX([name],'recovery')
from sysdatabases
where name not in ('master','model','tempdb','msdb')

Recovery model query to simple below:

--Change the recovery mode:

USE master;

GO

-- Set recovery model to SIMPLE

ALTER DATABASE smrmindev  SET RECOVERY SIMPLE;

GO

Recovery model query to full mode below:

 -- Set recovery model to FULL

--Change the recovery mode:

USE master;

GO

 -- Set recovery model to FULL

ALTER DATABASE smrmindev SET RECOVERY FULL;

-- Set recovery model to FULL

ALTER DATABASE smrtest SET RECOVERY FULL;

GO

--- Check the status of recovery model.

select [name], DATABASEPROPERTYEX([name],'recovery')
from sysdatabases
where name not in ('master','model','tempdb','msdb')