Home Forums SQL Server 2005 Business Intelligence Space Issue in C drive RE: Space Issue in C drive

  • December 17, 2013 at 4:11 am

    #1673997

    Koen Verbeeck (12/17/2013)

    And why o why do you keep your log files on your C drive?

    That is waiting for disaster to strike.

    ++1, you need to move your files

    you can do the following:

    Detach the database, move the files, reattach the database.

    OR

    Use the ALTER DATABASE ... ALTER FILE to change the metadata. Take the database offline, move the files, bring the DB back online.

    Do it hurry and do not make database on C Drive from now on 🙂