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
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.