If there is a break in the restore process then we can follow the steps below to try solve the problem.

First, Open SSMS and execute the following command to look at database Status.

SELECT NAME, STATE_DESC FROM SYS.DATABASES

As soon as you confirm that database is in restoring status, then we execute the following command:

RESTORE DATABASE [DBNAME]
FROM  DISK ='DATABASE FILE PATH'
WITH RESTART, STATS =20
GO
Share This