Restoring full back up taking forever
This is the expected behavior.
When you restore using &quot;With no recovery&quot;, it tell SQL to leave the DB in the &quot;recovery&quot; state (allowing you to restore subsequent backup).
If you want to make the database available, you can run a
Restore database [dbname] with RECOVERY;

Note that running this command will bring the DB online and you will be able to run query in it but it will also make all other restore impossible.
If you need to look at the data while in the middle of the restore process, you could use the &quot;with standby&quot; option
Restore database [dbname] from disk =N'path to backup' with STANDBY=N'path to the standby file that will be created'

Your other option would simply be to complete your restore (your transaction log backup) and make sure that on the last one, you change the &quot;norecovery&quot; by &quot;recovery&quot;