dcsimg
 

Submitted by: Hannes du Preez(ojdupreez1978@gmail.com)

Wednesday Mar 18th 2020 by Hannes du Preez

Language: SQL, Expertise: Intermediate: See how to easily shrink the size of the data and log files in a database.

The following command shrinks the size of the data and log files in a database. Here is a small example:

DBCC SHRINKDATABASE (Database_Name, 10);  

This allows for 10 percent free space in the database.

Home
Mobile Site | Full Site