Shrink A database in SQL
Posted on 2016-08-10
I have an SQL server 2008 r2 with 300 gigs of space however, I'm down to 77 gigs (yikes). The particular database currently is 150875.06 MB I went to the properties and shrink database and I'm running this but it's been running for over an hour. I'm not sure if this is correct. Is there another way for me to get some room. I already have the options set for recovery model simple on all the 10 database partitions. I'm not a DBA by any means and there are 10 partitions already. the main database is the largest and the one I'm trying to shrink. I'm using SQL Management Studio for this task. Is there a better, faster way?