Question: During a SQL Server Restore of a database from a BAK file – this error message appeared:
Msg 3257, Level 16, State 1, Line 1
There is insufficient free space on disk volume 'G:\' to create the database. The database requires 280972754944 additional free bytes, while only 196351672320 bytes are available.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
What can I do to fix this error message and successfully complete the RESTORE?
Answer: The first thing to check is how much space the database actually requires. To view the space required for the RESTORE use the RESTORE FILELISTONLY
RESTORE FILELISTONLY FROM DISK='backup_file_location'
Based on the information organise some extra diskspace to accommodate the file size.
Some other options:
1) Before taking the source BACKUP shrink the file
2) Detach the source database , and reattach the MDF file on target server. Useful if the transaction log file is bigger than the disk available . Be careful if it’s a Production system!