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

 Posted by Virendradugar on 11/19/2009 | Category: Sql Server Interview questions | Views: 3458

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.

dbcc shrinkdatabase (TempDAabase,10)

This command will free only 10% space.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response