• Don't forget to "fix" SQL Server after your OS defrag. Check your indexes to see if they need to be defragged (because a hard drive defrag will move your SQL files around once you've stopped the services) and update your statistics after fixing any index problems.

    I'm probably just being anal, but IMHO, it's never a good idea to defrag hard drives without doing SQL Server housekeeping afterward.

    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.