Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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
add comment

1 Answer 1

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

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
add comment

Your Answer

 
discard

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.