We have 200gb SQL (2008 R2) DB which I am trying to restore to a new empty db.
it takes about 1 hour to restore from 0% to 100% however its never finish the task and spinning an hour glass for over 6 hours.
there are no processes running on the SQL and i tried it for the second time . first time gave up after 3 hours.
Data partition still has 200gb of free space (after mdf file restored 200gb)
log partition still has 40gb space (log files are 70gb) after log file is restored
what is causing restore ( i do a restore from device and point to a backup file on another local partition) not to finish?