December 9, 2015 at 2:53 pm
What is the best way or alternative way to shrink the db file? My whole Database was 3 GB. I added one table that was 89 GB, which later realized I didn't need it. Its been dropped now. I want to my original size DB back. Currently its showing 92 GB of size where only 3GB is used.
December 9, 2015 at 3:12 pm
You can shrink the database, but you'll need to rebuild all the indexes, because shrinking the DB makes a mess of the indexing.
December 9, 2015 at 3:14 pm
I'm also worried about shrinking 89GB db taking longer to shrink.
December 10, 2015 at 3:32 am
It'll take a while. Do it in 5GB or so chunks.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply