Database Shrinking Commands
• DBCC SHRINKDATABASE (ShrinkDB, 10) • DBCC SHRINKFILE (ShrinkDB, 10)
Note:-
Imapact of shrinking database:-
1. Causes pages being moved from the front of file to the end
2. It will cause massive fragmentation
3. It will not reduce the size of the data file, but actually increase it
4. That shrinking a database will cause unnecessary I/O hits
5. That shrinking a database was a futile endeavor because of poor planning regarding sizing of database
6. And that shrinking a database should be very rarely done