Msg 3257 :There is insufficient free space on disk volume during SQL Server Restore

29 July,2014 by Jack Vamvas

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!

 Read More

Differential backup cannot be restored . BACKUP with COPY_ONLY

SQL Server faster restores with instant file initialisation

SQL Server - Display restore history for a single database


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Msg 3257 :There is insufficient free space on disk volume during SQL Server Restore


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer