SQL RESTORE WITH RECOVERY; Hangs at 100%
As it turns out the issue was environmentally related and pretty straight forward:
First of all, I was attempting to back up from a non-shrunk back up version of the origin database.
The size of the log files was actually a known issue, hence we usually back up from a shrunk version of the database.
So if anyone is having a similar problem, trying shrinking the database first and then backing it up and restoring from that.
Secondly, I was attempting to backup the database to an external drive over USB3.
Also, interestingly, I watched the progress of the working restoration command and it too had a status of 'suspended' with 'wait_type' "BACKUPTHREAD" - even whilst it was still progressing (as evident by the percentage of completion increasing in the percent_complete) column! So I'm still lost as to what thats about...
But at least I can restore my backups now :-)
I had the same problem it was due to the size of the DB.Although the backup shows 9 MB, when I right click the DB in SQL server management and select properties, the size shown was 25 GB!What I did is that I changed the DB to "Simple Recovery", shrinked the log file,backup again, and I could restore now.