Tuesday, January 26, 2016

SQL Server 2014 - Database Recovery Pending

While upgrading our SQL Server Databases I noticed some of the databases were showing "recovery pending" next to the database name in the SQL Server 2014 Management Studio. 

While backing up and restoring the databases on the new server I had moved some of the database files (.mdf) to a different folder.This caused the databases to be in an inconsistent state. The fix is to ensure the path to the database files (.mdf) is pointing to the correct files.

Below are the screenshots









No comments: