patternMinor
Reducing DB size while restoring
Viewed 0 times
sizewhilereducingrestoring
Problem
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?
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?
Solution
A restore always restores the files to the same sizes they were when they were backed up.
There is currently no way to "restore with shrink."
You'll need to restore the files to a drive with sufficient free space, and perhaps consider shrinking the files at that point, then use your preferred technique to move the files to the spot you want.
There is currently no way to "restore with shrink."
You'll need to restore the files to a drive with sufficient free space, and perhaps consider shrinking the files at that point, then use your preferred technique to move the files to the spot you want.
Context
StackExchange Database Administrators Q#20953, answer score: 5
Revisions (0)
No revisions yet.