litu deb (2/1/2008)
I know how to shrink whole database and also individual file.
DBCC shrink database to shrink the whole database. DBCC ShrinkFile to shrink individual files
I would like to know if i shrink only the database what would be the impact
See Steve's comments, see the blog post I linked to, and be sure to check the links at the end of that. (to Paul randal's blog and the storage engine team's blog) Between them, they cover all the issues quite nicely
how come it reduce the size of database.
It only reduces the size of the DB if there's unused space in the data or log files. Shrink releases that space to the OS, so the file size decreases.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass