Showing posts with label What is the command name to shrink the data file and log file size in SQL server 2005. Show all posts
Showing posts with label What is the command name to shrink the data file and log file size in SQL server 2005. Show all posts

Friday 30 March 2012

What is the command name to shrink the data file and log file size in SQL server 2005

What is the command name to shrink the data file and log file size in SQL server 2005

The command name is : DBCC SHRINKDATABASE (Database Name) 

This command will shrink the data file and log file size. With this command you can specify that how much percentage space you want to free.