• Bapi run

    SELECT NAME, FILEID FROM SYSFILES

    to get the fileID of the log file, then use that in the DBCC SHRINKFILE script



    Shamless self promotion - read my blog http://sirsql.net