SQL database restore operation fails on Linux servers

Applies to: SQL Server 2017 on LinuxSQL Server 2017 Developer LinuxSQL Server 2017 Enterprise Core Linux

Symptoms


When you try to restore an SQL database on a Microsoft SQL Server 2017 Linux server, the operation fails during the restore process and returns an error message that resembles the following:

"MODIFY FILE encountered operating system error 31(A device attached to the system is not functioning.) while attempting to expand the physical file"

Cause


This problem may occur because the hard disk has run out of space. On Linux servers, SQL Server does not check the available space before the operation starts. 

Workaround


To work around this problem, restore the database on a volume that has enough space.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.