This question already has an answer here: • 4 answers I am working with a 500 GB SQL Server database. I need to reduce the size of the database data file after removing a large amount (50%) of the data.

I tried re indexing, it's good the database has de-fragmented. But the DB size is not reduced. I am not prepared to use shrink database.

Construction Autocad Software here. I have already tried compression and DBCC UpdateUsage but no space gain. Please advise me any other ways to reduce the database size. Our client will not allow us to take the DB Offline. It might take 5 hr to shrink the database and then re indexing will take 3 hrs, so in total we would need 8 hr down time. The Settlers 7 Offline Crack Mac Vs Pc more.

I am working with a 500 GB SQL Server database. I need to reduce the size of the database data file after removing a. Reduce MDF file size. Software Engineering. File reduces size, but MDF file is still big with 20G. The number of record in DB is reduced but MDF file is not reduced So how to reduce. SQL Server 2008.

I am looking for a solution without downtime. Step 0) Shrink disclaimer I'm not even going to say it. I'll let Brent Ozar tell you to In your comments, you mention you deleted 50% of the data in the database, so you very likely have a good use case for a one-time database shrink. (Assuming that the deleted data isn't going to come back.) I'm not even going to touch on shrinking logs.

We're just talking data files. Step 1) Look at file size Before actually thinking about shrinking a file, look at file size and how much free space there is.