CODE EXAMPLE FOR SQL

prosys sql log

USE ERPPRO;
ALTER DATABASE ERPPRO
SET RECOVERY SIMPLE
ALTER DATABASE ERPPRO
MODIFY FILE  (NAME = N'DMSPRO_TEST_log', FILEGROWTH = 100MB, MAXSIZE = 200MB )
GO
ALTER DATABASE ERPPRO
SET RECOVERY FULL
;

select * from sys.database_files;