• But why would you need a backup? I mean, it's not as if a disk will fail, or someone drops a table (or the entire database) or the data file gets corrupted or an adimn deletes the mdf accidentally or data modifed yesterday needs to be undone or ... </sarcasm>

    I'm almost tired of asking people if they have backups in the 'my database is corrupt'/'I need to recover deleted <something>' forum posts. The answer 99% of the time is no. The best I ever got from someone was "I didn't know I had to take backups"

    And don't get me started on the 'took a backup but never tested it and now it won't restore' situation

    <sigh>

    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