Nicholas Cain (4/14/2004)
Try shrinking it using the fileid (SELECT NAME, FILEID FROM SYSFILES), use the same syntax, just replace the filename with the fileid.
Just want 2 thank u cause that fixed my issue with 1 of the db`s although the error msg was in sys.database_files & I found some Indexes corruption, even after REPAIR_REBUILD, could not fix the shrink_log file issue till I googled it and found your solution, so thanx again.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant