Redirected restore of a SQL database fails with - There is insufficient free space on disk volume 'C:\' to create the database.

Article:TECH204190  |  Created: 2013-03-22  |  Updated: 2013-04-05  |  Article URL http://www.symantec.com/docs/TECH204190
Article Type
Technical Solution


Subject

Issue



A redirected restore of SQL fails with an error indicating there is not enough free space, even though there is plenty of disk space in the target location.

 


Error



V-79-65323-3257 - There is insufficient free space on disk volume 'C:\' to create the database. The database requires 'n' additional free bytes, while only 'n' bytes are available.


Cause



If the backup came from a virtual machine and granular / GRT selections are being restored from tape, the error could be referring to the staging location.

When performing a GRT restore from a sequential device such as tape, it is required to stage the information on a local disk first, then the required file is extracted from the staged copy on local disk and restored.


Solution



Change the staging location as instructed in the following articles:

 How to change Granular Recovery Technology (GRT) temporary staging location for Backups and Restores (Backup Exec 2012) www.symantec.com/docs/TECH187371

 How to change the default staging location for Granular backup and restore jobs. (Backup Exec 2010) www.symantec.com/docs/TECH171749

 


Supplemental Materials

SourceUMI
ValueV-79-65323-3257
Description

There is insufficient free space on disk volume 'C:\' to create the database. The database requires 'n' additional free bytes, while only 'n' bytes are available.

 




Article URL http://www.symantec.com/docs/TECH204190


Terms of use for this information are found in Legal Notices