Shrink mdf file size

He holds a Masters of Science degree and numerous database certifications. Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service.

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long term multi-channel campaigns to drive leads for their sales pipeline. Is your SQL Server running slow and you want to speed it up without sharing server credentials?

In my Comprehensive Database Performance Health Check , we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours. Once you learn my business secrets, you will fix the majority of problems in the future.

Hello Pinal,. I have seen many blogs from you on SQL server and i have always found them useful and easy to understand. Thanks for all the information you provide. Forgot your password? Ask a Question. How to reduce the mdf file size in SQL server ? Please Sign up or sign in to vote.

See more: SQL-Server Posted Aug am Member Add a Solution. Top Rated Most Recent. Accept Solution Reject Solution. First of all - do NOT shrink a database or its files without good reason SQL will perform better if you let it allocate the files in the way finds it best If despite this you have to shrink, than do not shrink a database in use. Shrink is a very IO expensive operation and doing it while other users are logged in will disturb their work.

Copy Code. Posted Aug am Kornfeld Eliyahu Peter. Remember that the MDF file stores your data - and if there is a lot of data, you can't free up much space. Posted Aug am OriginalGriff. And if in the future, you should light a candle, light one for them. You must be logged in to reply to this topic. Login to reply. January 12, at pm Database total size is 5. However, after shrinking size does not change at all.

Still 5. How can I free up that 1. Attachments: You must be logged in to view attached files. What command did you run to shrink, please post the exact TSQL.