SQL MODEL Database

MODEL Database Settings

USE [master]

GO

ALTER DATABASE [model] SET RECOVERY SIMPLE WITH NO_WAIT

GO

ALTER DATABASE [model] MODIFY FILE ( NAME = N'modeldev', SIZE = 30720KB , FILEGROWTH = 102400KB )

GO

ALTER DATABASE [model] MODIFY FILE ( NAME = N'modellog', SIZE = 3072KB , FILEGROWTH = 102400KB )