Viewing 2 posts - 1 through 3 (of 3 total)
Strange, why does ssms then suggest this line when you apply this on a lig file when you choose for the option shrink file.
I checked it on my test system...
March 4, 2014 at 6:35 am
#1693863
This should do it also.
DBCC SHRINKFILE (N'<DATABASE_LOG_FILE_NAME>' , 0, TRUNCATEONLY)
March 4, 2014 at 5:10 am
#1693826