sp_helpdb ptitsolutions
--to check database and log file size information
ALTER DATABASE ptitsolutions SET RECOVERY SIMPLE
As per your own demand if dont wants to make log file
DBCC SHRINKFILE(DBNAME_log)
ALTER DATABASE DBNAME
MODIFY FILE(NAME = DBNAME_data, MAXSIZE = 500MB);
MODIFY FILE(NAME = DBNAME_data, SIZE = 500MB);
MODIFY FILE(NAME = DBNAME_log, MAXSIZE = 500MB);