Restart SQL Server to create space on disk

• Brandie Tarvin

  SSC Guru

  Points: 173105

  More actions

  December 3, 2010 at 5:06 am

  #1258299

  Something not mentioned here, but happens in my work environment. Backup files take up space too.

  If you're not clearing out your backup files on a regular basis, and they are saved to this drive, they can also take up space. You absolutely want to keep backups, but don't keep so many that you don't have room for your regular database files. If you haven't changed the default backup directory, then this might be your problem.

  Also, are your user db data files also saved to C: or are they saved to another drive?

  Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

• Jeff Moden

  SSC Guru

  Points: 1004600

  More actions

  August 22, 2021 at 4:21 pm

  #3922602

  Personally, I never install SQL Server on the C:Drive.  I also never let the "Page File" live there and I also install all programs other than SQL Server on a separate drive.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)