Following way we can Shrink Database, Data Files and Log Files: 1. Using SQL Server Management Studio (GUI) 2. Using T-SQL script Please do not shrink without checking the recommendation otherwise you can see huge performance issue. This is just an example to show how to shring Database, Data Files and Log Files. 1. Using SQL Server Management Studio (GUI) 2. Using T-SQL Script: --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 |