• You can use dbcc shrinkfile instead of dbcc shrinkdb. This enables you to select the file that you want to shrink and set the new size. The question is – why? Shrinking the file causes unwanted effects such as fragmentation. Also if the database reached this size there is a good chance that it will reach this size again, so why shrink it at all?

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/