Recovery_pending
How I resolved “Recovery_Pending State” which occurred while moving SQL Server files
I ran into an issue lately while moving some files around. “Recovery Pending State” in SQL Server is what I kept bumping my head against.
My goal was to move my files on my desktop to a new drive since I received a replacement. TempDB needed to be altered for the location but I didn’t need to move those files since SQL Server re-creates them. (You can’t back them up either!)