SQL server datafiles

• Jan Jaap van der Most

  SSC Journeyman

  Points: 92

  More actions

  September 27, 2003 at 7:00 am

  #160780

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

  Thanks in advance

• ray_higdon

  SSCarpal Tunnel

  Points: 4589

  More actions

  September 27, 2003 at 7:35 am

  #476098

  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