snippetsqlMinor
How to restore some percentage of backup file?
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.
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:
Some useful links to begin with:
- 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.