We have a SQL database that is about to suck up the whole hard drive space. We have identified tables we can remove and will do that. The database is 180 gig. My question: after we delete tables, how best to recover disk space. I have read about shrink and there seems to be some major pitfalls. If I reduce DB by 40% how long will shrink take? will reindexing help with fragmentation? I need space for the transaction log file. Please assist.