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