Can you shrink MDF file?

Question

The shrinking the Master Data file (MDF) as discussed is possible in two ways either by using shrink option in SSMS or by using command on T-SQL Script. Reorganizing the indexes after shrink operation may be necessary as it has bad impact on the indexes of the database and may lead to slower performance. 7 мая 2016 г.

Is it safe to shrink MDF file?

Shrinking MDF and NDF file is possible and there is no chance of data loss. It is not always advisable to shrink those file as those files are usually growing. There are cases when one database is separated in multiple database of any large table is dropped from database MDF and NDF can contain large empty space.

Why is my MDF file so big?

Because the MDF was allocated with 154Gb, or has grown to 154Gb through various operations. A database file has at least the size of the data in it, but it can be larger than the used amount by any amount.

Is it OK to shrink SQL database?

Shrinking a SQL Server database completely ignores logical index fragmenting, and results in massive fragmentation of all indexes. This can have a negative impact on query performance since it will take longer to 'locate' fragmented indexes.

How do I shrink a database file?

To shrink a data or log file1In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.2Expand Databases and then right-click the database that you want to shrink.3Point to Tasks, point to Shrink, and then click Files. ... 4Select the file type and file name.Shrink a File - SQL Server | Microsoft Docs

Expert · Answer