Return code: x2DB4RESTORE DATABASE is terminating abnormally. There is insufficient free space. (4297924)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Return code: x2DB4RESTORE DATABASE is terminating abnormally. There is insufficient free space.
Description

Full error - Msg 61700, Level 16, State 1, Line 0Unexpected termination on thread: 0, Return code: x2DB4RESTORE DATABASE is terminating abnormally.Problems were identified while planning for the RESTORE statement. Previous messages provide details.There is insufficient free space on disk volume 'R:\' to create the database. The database requires 322122547200 additional free bytes, while only 991526912 bytes are available.
Cause

Issues with Microsoft 2008 R2 incorrectly reporting of space available on mount points:
Resolution

Make sure the SQL Service account user has FULL rights to the mount point.
https://connect.microsoft.com/SQLServer/feedback/details/675547/2008-r2-cu5-restore-database-onto-mount-point-incorrectly-estimates-available-free-space-fails
https://connect.microsoft.com/SQLServer/feedback/details/678633/incorrect-permissions-on-mount-point-directory-gives-incorrect-error-message-when-service-account-does-not-have-correct-permissions

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title