Home Forums SQL Server 2005 Administering I just became Keeper of the Ring. And I'm Boromir. RE: I just became Keeper of the Ring. And I'm Boromir.

  • If you're talking about a RAID array write cache backup battery, then you either must replace it or must disable the write cache or you are risking a corrupt database.

    Start with this

    http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    As for backup strategies, don't start with the backups, start with the business requirements for maximum data loss. If the business thinks that there will be no more than 15 minutes of data lost in any disaster (and losing a few hours would be catastrophic), then a strategy of weekly fulls and daily diffs could result in unpleasant surprises and job losses (probably yours)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass