• 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