HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

How to restore some percentage of backup file?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
filerestoresomehowpercentagebackup

Problem

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.

Solution

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 & NAS by Brent Ozar

Context

StackExchange Database Administrators Q#169058, answer score: 3

Revisions (0)

No revisions yet.