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 |