CREATE DATABASE [MyDB] ON PRIMARY 
( NAME = N'DataFile_dat', FILENAME = N'F:\MSSQL\Data\DataFile.MDF'), 
 FILEGROUP [IndexFileGroup] 
( NAME = N'Indexes', FILENAME = N'F:\MSSQL\Data\Indexes.MDF')
 LOG ON
( NAME = N'LogFile_log', FILENAME = N'F:\MSSQL\Data\LogFile.LDF')

RESTORE DATABASE MyDB
 FILE = 'DataFile_dat',
 FILE = 'Indexes'
FROM DISK = '\\Some_URL\F$\BackupFolder\MyDB_Backup.BAK'
 WITH REPLACE, RECOVERY,
MOVE 'DataFile_dat' TO 'D:\MSSQL\Data\DataFile.MDF',
MOVE 'Indexes' TO 'D:\MSSQL\Data\Indexes.MDF'

Msg  3257 , Level  16 , State  1 , Procedure RestoreMyDB, Line  20 
There is insufficient free space on disk volume 'D:\' to create the database.
The database requires XXXXXXXX additional free bytes, while only YYYYYYYY bytes are available.
Msg  3119 , Level  16 , State  4 , Procedure RestoreMyDB, Line  20 
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg  3013 , Level  16 , State  1 , Procedure RestoreMyDB, Line  20 
RESTORE DATABASE is terminating abnormally.

--To Restore Specific Files, Filegroups, or Pages: 
RESTORE DATABASE { database_name | @database_name_var } 
     <file_or_filegroup_or_pages> [ ,...f ]
[ FROM <backup_device> [ ,...n ] ] 
[ WITH 
   [ { CHECKSUM | NO_CHECKSUM } ]
   [ [ , ] { CONTINUE_AFTER_ERROR | STOP_ON_ERROR } ]
   [ [ , ] FILE = { file_number | @file_number } ] 
   [ [ , ] MEDIANAME = { media_name | @media_name_variable } ] 
   [ [ , ] MEDIAPASSWORD = { mediapassword |
                      @mediapassword_variable } ]
   [ [ , ] MOVE 'logical_file_name' TO 'operating_system_file_name' ] 
                [ ,...n ] 
   [ [ , ] PASSWORD = { password | @password_variable } ] 
   [ [ , ] NORECOVERY ] 
   [ [ , ] REPLACE ] 
   [ [ , ] RESTART ] 
   [ [ , ] RESTRICTED_USER ]
   [ [ , ] { REWIND | NOREWIND } ] 
   [ [ , ] STATS [ =percentage ] ] 
   [ [ , ] { UNLOAD | NOUNLOAD } ] 
]
[;]

<backup_device> ::=
{ 
   { logical_backup_device_name |
            @logical_backup_device_name_var }
   | { DISK | TAPE } = { 'physical_backup_device_name' |
              @physical_backup_device_name_var } 
} 

<file_or_filegroup_or_pages> ::=
{ 
   FILE = { logical_file_name | @logical_file_name_var }
   | FILEGROUP = { logical_filegroup_name | @logical_filegroup_name_var } }
   | PAGE = 'file:page [ ,...p ]'  
} 

<file_or_filegroup_or_pages> [ ,...f ]
...
<file_or_filegroup_or_pages> ::=
{ 
   FILE = { logical_file_name | @logical_file_name_var }
   | FILEGROUP = { logical_filegroup_name | @logical_filegroup_name_var } }
   | PAGE = 'file:page [ ,...p ]'  
}

 FILE = 'DataFile_dat',
 FILE = 'Indexes'

MODIFY FILE encountered operating system error  112  (There is not enough space on the disk.)
while attempting to expand the physical file 'F:\MSSQL\Data\LogFile.LDF'.

RESTORE DATABASE MyDB
 FILE = 'DataFile_dat',
 FILE = 'Indexes'
FROM DISK = '\\Some_URL\F$\BackupFolder\MyDB_Backup.BAK'
 WITH PARTIAL, CONTINUE_AFTER_ERROR, REPLACE, RECOVERY,
MOVE 'DataFile_dat' TO 'D:\MSSQL\Data\DataFile.MDF',
MOVE 'Indexes' TO 'D:\MSSQL\Data\Indexes.MDF'