When restoring a database where the data file(s) are located under a mount point, seems to be a problem with reporting free space available.
DB Size - Say 30GB (25 Data, 5 Log)
E:\ Drive 20GB with 15GB Free
Restoring database file to
E:\SQLMountPoint\
- This points to separate disk with more than enough free space
SQL prevents the restore by stating there is not enough free space.
A long work around is
assign a drive letter to the large disk
Restore database using temp drive letter - F:\SQLDATA\MyDB_Data.mdf
Update sysfiles - changing drive & path - E:\SQLMountPoint\SQLDATA\MyDB_Data.mdf
Stop & restart database...
Is there a better way
Wishlist - Restore only warns about free space - but allows continue...
Regards