Better ways to shrink database in SQL Server

Updated on August 13, 2020     Kisan Patel

Let’s learn how to shrink database in SQL Server

Step 1 : Right click on database => properties => options => change Recovery model Full to Simple.

Step 2 : Right click on database => Task => Shrink => File.

Step 3 : First change file type Data to Log and in Shrink action select Reorganize pages before releasing unused space and Click OK.

Step 4 : Then change file type Log to Data and in Shrink action select Reorganize pages before releasing unused space and Click OK.

Step 5 : After above step revert Recovery model Simple to Full as shown in step 1.