Return
-
Title
Restoring a database backup is stuck at 0% -
Description
When restoring a backup made in Litespeed, from a mapped network drive (e.g. Y:\), it hangs at 0% and never completes.
There is no job failure in the Litespeed Activity window though, and no errors in the Event Viewer. -
Cause
The issue occurs as Litespeed hardcoded the knowledge that the drive had been swapped to be used as another drive letter. Even when applying a new disk and reinstalling SQL & Litespeed, Litespeed doesn't like the fact that the drive used to be the other drive. SQL however was able to restore directly from the disk. Swapping the drive back allows it to work again. -
Resolution
The workaround is to move the backup file to the C drive local to Litespeed, and the same backup file restores fine, or swap the drive letter back, if it had been changed.