dbcc opentran (ServerAdmin)
go
dbcc shrinkfile (ServerAdmin_log, truncateonly)
dbcc shrinkfile (ServerAdmin_log, 0)
Results:
No active open transactions.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Cannot shrink log file 2 (ServerAdmin_Log) because the logical log file located at the end of the file is in use.
I cannot shrink the logfile and datafile to any amount then what it's currently at. How is this possible