Thursday, March 29, 2012

Difference between Shrinking a DB and a FILE

Hi,

What is the difference between shrinking a DB with that of a file.

When you select a DB to shrink will it not shrink all the files in it.

Because when I select Files to shrink it does not prompt me with
a specific file.

So I am confused as to why SQL server 2K5 asks if you need to shrink DB or FILE

Tnx

Shrink database shrinks all the files in a database, shrink file shrinks one specific file in a database.

The way that data files(.mdfs) and log files(.ldfs) shrink is different, you should read in Books On Line about it.

No comments:

Post a Comment