Loading ...
Sorry, an error occurred while loading the content.

4515Re: Shrinking MDF file

Expand Messages
  • p_livengood
    May 5, 2010
      You have to shrink the database, then then file

      --first run this
      DBCC SHRINKDATABASE (dbName)

      --then run this
      DBCC SHRINKFILE (logicalLogFileName)

      HTH
      Paul
      --- In SQLQueriesNoCode@yahoogroups.com, Noman Aftab <noman17pk@...> wrote:
      >
      > Hi,
      > I have a non-query database related question:
      > We have a database in SQL Server 2005 whose MDF file was increased to 300 GB. The system is used for reporting purposes only. We deleted somewhat 80% of the data through delete scripts but the file size of MDF didn't decreased. We were able to shrink the LDF file to a minimum (1MB), but the size for MDF is not decreasing by shrinking the database. Any suggestions?
      > Best Wishes,
      > Noman Aftab
      >
      >
      > http://www.corpus.quran.com/wordbyword.jsp
      > http://www.jalandhari.qsh.eu
      >
      >
      >
      > [Non-text portions of this message have been removed]
      >
    • Show all 18 messages in this topic