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