SQL Server needs two primary files to operate: the .mdf (data) and the .ldf (log). If you moved a log file, deleted it, or if the file path is incorrect in the system catalog, SQL Server will stop cold. It knows it can't run recovery without the instruction manual (the log), so it waits for you to fix the path.

If you know the files were moved or the path is wrong, you have to tell SQL Server where they are.

The "Recovery Pending" status is fundamentally a startup or recovery-phase issue. When SQL Server starts, or when a database is brought online after an error, it must run a recovery process on every database. This process reads the transaction log to roll forward committed transactions and roll back uncommitted ones, ensuring the database is in a transactionally consistent state. If this process cannot complete, the database enters "Recovery Pending."