2

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?

  • If the backup was compressed, then your actual database may be 67 GB... – JNK Jul 16 '12 at 13:15
  • @JNK, can I somehow find out it backup was compressed? – Gopher Jul 16 '12 at 13:18
  • 1
    Use RESTORE HEADERONLY -- there is a column Compressed that will be 0 or 1. – Jon Seigel Jul 16 '12 at 13:21
4

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.

  • Alter database + set offline + move files manually + set online is much, much safer than detach + move + attach. – Aaron Bertrand Jul 16 '12 at 13:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.