This question already has an answer here:
I have a backup that's about 6Gb. It's a "light" backup of the original (with the log tables purged), which is about 14Gb.
I try to restore the backup on my SQL Express local server. It fails with a message like :
System.Data.SqlClient.Error: insufficient disk space. It asks for 227,891,019,776 bytes, which is absolutely crazy, and almost as big as my whole hard drive.
As found on other sites, I tried
RESTORE FILELISTONLY FROM DISK = 'backupfile.bak'.
The data file (column
Size) is 6,888,226,816 in size, but the log file is 221,006,987,264. The column
BackupSizeInBytes returns 6,259,736,576 and 0.
So, if I understand correctly, restore checks that I have enough space to restore the "theorical" size of the log file before proceeding, disregarding the actual log file size ?
How can I bypass that ? It's a bit difficult to get a backup, so if I can resolve my problem without having to return on the production server, it would be great.
Thank you !
Oh BTW, I am on SQL Server 2008 R2 Express.