September 22, 2009 at 1:13 am
oraculum (9/21/2009)
Hi Everyone!Just thought I would update you, I tried a clean restore of the database and ran a rebuild index job then a shrink, and blow me down with a feather it worked 1st time!
Maybe all the other attempts to shrink the previous version made things worse!
Thank you 🙂
so, its basically the restoration which did the trick. Were you trying with the same restoration earlier?
September 22, 2009 at 11:29 am
I appeciate that you managed to get this to work, but to save time would it be feasible to drop then re-add the column containing the BLOB data? I've used this trick in the past to reduce the time taken to prepare a database for dev usage, presumably the pages containing the out-of-row BLOB data are just deallocated.
Chris
November 10, 2009 at 10:25 am
Hi,
Can you explain what do you mean by "clean restore"? I'm having the same problem and need to shrink the database asap. 🙁
Do I really need to drop all the FK/PK/Indexes?
Thanks,
Annie
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply