• What happens when "the db's broke" and you can't run a log backup? Say for instance if you lose a disk controller, or disks or a fire engulfs your server etc...

    what then?

    If you take a nightly Full backup and take log backups periodically throughout the day that you store on another machine you have a much better chance of recovering more data than you would with your current schedule.

    Worse yet, what happens when you do your full backup, and it's invalid, corrupted or something else? now you're out 2 days worth of data.

    But then again I'm just a bit on the paranoid side when it comes to these things...

    To help us help you read this[/url]For better help with performance problems please read this[/url]