I have DB backup with size approx. 150 Mb.
I am trying to restore it and getting an error: "System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'C:\' to create the database. The database requires 67771760640 additional free bytes, while only 45085224960 bytes are available. (Microsoft.SqlServer.Smo)"
Restore is about to create DB with much bigger size than backup has. Is there a possibility to reduce size of DB being restored?
RESTORE HEADERONLY
-- there is a columnCompressed
that will be 0 or 1. – Jon Seigel Jul 16 '12 at 13:21