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. 


No comments:

Post a Comment