-
Title
Insufficient free space error when restoring an existing SQL database through VDI -
Description
Error ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server] There is insufficient free space on disk volume 'I:\' to create the database. The database requires 335829213184 additional free bytes, while only 44887289856 bytes are available.
The restore option "Set database with RECOVERY; no more transaction logs can be restored" is selected and other options are left as default. NetVault is installed in I:\NetVault Backup with tmp configured as I:\NetVault Backup\tmp while SQL Server is installed in E:\
-
Cause
It has nothing to do with the NetVault tmp directory running out of space, the error is a SQL Server error.
-
Resolution
If the database exists, then SQL Server will take into preference the database default locations configured in the SQL Server. In this case, the database is about 300GB in size and is located in E:\ however the database default locations is set to I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ by default.
The database default locations can be verified by going to SQL Server Management Studio | Object Explorer, right click on the instance and select Properties. Click on Database Settings then check the Database default locations.
If the database does not exist, then SQL Server will restore to the original location where the database backup was taken. It was also noted in this case that when the existing database was deleted the restore completes without error.
-
Additional Information
NetVault Backup 8.5.3 Database: SQL 2005 SQL APM: 5.5.13