Msg 8985, Level 16, State 1, Line 2 Could not locate file '' for database '' in sys.database_files. The file either does not exist, or was dropped.

This error raised when i want to shrink log file, the solution for this just rename the logical file in SQL management studio, i am using SQL 2012 version : In my case this error caused by, when restore backup file we choose another name for db, unfortunately...

READ MORE - Msg 8985, Level 16, State 1, Line 2 Could not locate file '' for database '' in sys.database_files. The file either does not exist, or was dropped.