SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to Detach an existing content db from my sql server by deleting its .mdf, .ldf files and while I am trying to add new content db (which I got from other server) whose size is 50 GB my sql server shows me error indicating that It needs a size of 137 Gb. I am not sure why it needs 137 GB of space rather than 50Gb. I think its asking so much space because to provide space for both mdf and Ldf file, I am I correct ? else please suggest.

share|improve this question
Note : I have deleted older content db mdf and ldf file just for having extra space as I dont need them. – shreyas Oct 26 '12 at 18:58

Probably the log files are huge. Try Shrinking the database before backing up, and restoring.

MSDN about Shrink Database:

share|improve this answer
Thanks Amadeo. Actually the bak file is a compressed file of 50gb but when it converts to original file its size becomes 137 GB. – shreyas Nov 1 '12 at 0:17

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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