I have a database backup file - the backup file itself is around 70 GB . It's comprised of one mdf and ndf and log file.
The mdf and ndf combined are about double the size of the backup file itself. When the db is restored its taking up about twice the size of the backup causing space issues.
The backup itself is on another server , not where the restored DB exists and to do the restore I used the restore from disk with 'move' command to move the three files to the drive where the restored db lives.
Question is whether after the restore is done can I remove the ndf file before I do an org import ? I'm attempting to upgrade a 4.0 database to 2011 but continually fail on space issues. I start with about 165 GB free and after the restore it still shows
about 27 free but import still fails .
Robert