SQL server datafiles

  • Is there a possibility to reduce the size of the database files (specially the MDF files)?

    Thanks in advance

  • If you have free space in your database you can use dbcc shrinkdb or dbcc shrinkfile. See BOL for syntax.

    HTH

    Ray Higdon MCSE, MCDBA, CCNA

    ------------

    Ray Higdon MCSE, MCDBA, CCNA

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply