How to restore some percentage of backup file? I have a backup file size 10 GB in a remote location. When I tried to restore it in my pc it is giving error "insufficient storage."

Is there any alternative way to store some percentage of the data that includes the whole schema?

I am using SQL Server 2014 Enterprise.
You probably have an option of:


Create several filegroups and data files in these filegroups
Move some part of your data to new files using rebuild index command
When restoring your database from a backup specify remote location for some data files, and the other files restore locally.


Some useful links to begin with:


Move an Existing Index to a Different Filegroup (Microsoft Docs)
SQL Server Can Run Databases from Network Shares &amp; NAS by Brent Ozar