How to Shrink MDF Database Data File of SQL Server - SQL Server DBA Tutorial

In this video you will learn how to shrink MDF database file of SQL Server using SQL Server Management studio as well as T-SQL Script. It also talks about what are the best practices of shrinking SQL Server Database data files (mdf), also under what circumstances it is OK to shrink SQL Server Data Files (mdf, ndf).

Script used to Shrink Data File in SQL Server

USE [Demo]
GO
DBCC SHRINKFILE (N'Demo' , 3)
GO


How to Shrink MDF Database Data File of SQL Server - SQL Server DBA Tutorial

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.