Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

Reduce size of SQL server log file truncate - Source :NAYCode.com


ALTER DATABASE db5
SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE (adb5_log,10)
GO
ALTER DATABASE db5
SET RECOVERY FULL
Source by naycode.com #
 
PREVIOUS NEXT
Tagged: #Reduce #size #SQL #server #log #file #truncate #Source
ADD COMMENT
Topic
Name
1+8 =