ALTER DATABASE <databasename> SET ALLOW_SNAPSHOT_ISOLATION ON
USE [master]
GO
ALTER DATABASE [<databasename>] SET RECOVERY SIMPLE WITH NO_WAIT
GO
USE [master]
GO
ALTER DATABASE [<databasename>] MODIFY FILE ( NAME = N'<databasename>_log',
FILEGROWTH = 102400KB )
GO
USE master
GO
sp_configure 'show advanced option', 1
GO
USE master
GO
sp_configure 'show advanced option', 1
GO
EXEC sys.sp_configure N'max server memory (MB)', N'<Memory Size>'
GO
EXEC sys.sp_configure N'max degree of parallelism', N'0'
GO
RECONFIGURE WITH OVERRIDE
GO