none
DPM 2010 - DEFRAG ? RRS feed

  • Question

  • I know there's no way to defrag the raw storage space used for recovery points, but what about the OS drive with the SQL databases ? Can that be safely defragmented, is a manual defrag sufficient and do I need to shutdown or stop any processes or services first ?

    Thursday, September 30, 2010 7:28 PM

Answers

  • Look in scheduled tasks and you will se defrag Wednessdays I think
    • Marked as answer by tgoetzman Friday, October 1, 2010 3:12 PM
    Friday, October 1, 2010 4:00 AM
  • The server is Windows Server 2008 R2 Standard 64bit and the SQL is SQL Server 2008.

    Thank you - I see there is a defrag task for Wednesday

    • Marked as answer by tgoetzman Tuesday, November 9, 2010 8:07 PM
    Friday, October 1, 2010 3:08 PM

All replies

  • For starters we need to know OS version and SQL version to give a satisfactory answer.

    Justy a shot in the dark until someone more knowledgeable comes along:

    I have been told (haven't verified it yet) that Windows Server 2008 does its own defragging so is unecessary.

    SQL services should probably be stopped when defragging if you are on Windows 2003

    Thursday, September 30, 2010 8:06 PM
  • Look in scheduled tasks and you will se defrag Wednessdays I think
    • Marked as answer by tgoetzman Friday, October 1, 2010 3:12 PM
    Friday, October 1, 2010 4:00 AM
  • The server is Windows Server 2008 R2 Standard 64bit and the SQL is SQL Server 2008.

    Thank you - I see there is a defrag task for Wednesday

    • Marked as answer by tgoetzman Tuesday, November 9, 2010 8:07 PM
    Friday, October 1, 2010 3:08 PM