DatabaseTutorial

Reducing/Shrinking the Size of SQL Server Database

SQL Server Database

The size of SQL Server Database can be reduced/shrunk using any of the following two methods-

Method 1: With the help of SQL Server Management Studio

Under this method, follow the steps given below for shrinking or reducing the size of SQL Server Database (.MDF and .LDF)-

Step 1: Right-click the database name >>Tasks>>Shrink>>Database

database 1

Step 2: Click OK

data base 2

OR

Method 2: With the help of Transact SQL Command

Under this method, follow the steps given below for shrinking or reducing the size of the SQL Server database using the SQL Command-

Step 1: Open the window- SQL Server Management Studio

Step 2: Connect it to the Database Engine

Step 3: Click on New Query from the Standard Bar

data base 3

Step 4: Enter the following SQL command in the query window and click on Execute

DBCC SHRINKDATABASE (DatabaseName, ‘target percent’); this command helps in shrinking the database

Database 4

We hope that you must have understood how you can shrink/reduce the size of your database using any of the two methods discussed above. If you still face any difficulty, feel free to reach out to the bodHOST Team for an unmatched and proactive 24×7 tech support.

 

Leave a Reply

Your email address will not be published. Required fields are marked *