The .mdf (data) or .ldf (log) files might be missing, renamed, or located on a drive that is currently offline.
This command rebuilds the log file but may result in the loss of uncommitted data. recovery pending sql
: The database was not shut down cleanly, leaving uncommitted transactions that cannot be rolled back due to a damaged log file. recovery pending sql