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

2 comments:

  1. TODAY I GOT MY DESIRED XMAS LOAN AMOUNT $520,000.00 FROM A RELIABLE AND TRUSTED LOAN COMPANY. IF YOU NEED A LOAN NOW EMAIL CONTACT drbenjaminfinance@gmail.com

    Hello, I'm here to testify of how i got my loan from BENJAMIN LOAN FINANCE(drbenjaminfinance@gmail.com) I don't know if you are in need of an urgent loan to pay bills, start business or build a house, they offer all kinds of loan. So feel free to contact Dr. Benjamin Owen he holds all of the information about how to obtain money quickly and painlessly without cost/stress via Email: drbenjaminfinance@gmail.com

    Consider all your financial problems tackled and solved ASAP. Share this to help a soul right now THANKS.

    ReplyDelete