Unexpectedly long duration on Restore, no feedback.
Current issue: Restoring a 200GB database over vpn. Seems to be taking much longer than expected, and I can't see any feedback on progress.
DB is marked as loading, query is still 'running', but I can't see any activity. The physical database files were last updated (os level) a couple of hours ago.
I am concerned because the log shipping broke a while back, this is the recovery. The log backup drive ran out of space resulting in a bunch of 0 size files going across. Most of the dbs recovered with a little jiggery pokery, but not this one - this got stuck in a perpetual restore - possibly something to do with the 1gb or so transaction log backup...