How to Shrink Database And Database Files - SQL Server DBA Tutorial

In this video you will learn how to shrink database, database files and database log files. It also demonstrates best practices of shrinking SQL Server Database data files, log files and database as a whole.

Scripts used in this video

--Shrink Database Script
USE [SalesOrders]
GO
DBCC SHRINKDATABASE(N'SalesOrders', 10 )
GO

--Shrink DB Files Scripts
USE [SalesOrders]
GO
DBCC SHRINKFILE (N'SalesOrders' , 3)
GO

 

Shrink Database files and Database in SQL Server