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.

  • 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: http://msdn.microsoft.com/en-us/library/ms189035(v=sql.105).aspx

| 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 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.