up vote 1 down vote favorite
share [g+] share [fb]

We recently had a failure on one of our servers. The server was not accessible and we could get any data from it. We had a backup plan that took a full backup every second day and then then a diff backup every 6 hour or something.

I use Jungle Disk to get the data from the server to a external storage and it was this that failed us this time. There will always be a delay between the diffrential backup is finnished and Jungle Disk has copied the file over to the cloud. And in this case our last diff backup was made like 1 hour before and therefore made all of our previous diff backups useless.

Is there any way to setup a diff backup so that i do not always have to have the latest version of the diff backup and just restore the backup with so many diff backups that i have accessible?

link|improve this question
feedback

1 Answer

up vote 1 down vote

Protecting your SQL Server data starts with the discs - you put your data files on dedicated RAID drives (ideally RAID10), put your transaction log files on another RAID10 drive, and TEMPDB elsewhere. This is for performance reasons, but it's also for recoverability - if one of the drives fails, you've got a chance. RAID should allow rebuilds, but also if your data drive has failed, you should be able to get the latest transactions out of the transaction log.

Next comes SQL Server backups - they should go to a separate disc, and then get taken off the server either to tape, or another server off-site. Depending on the size of the databases, and your maintenance windows, a full daily backup might be appropriate - or a full backup weekly. On top of this, put frequent transaction log backups (hourly perhaps), and maybe differentials as well depending on the size of your databases.

The final part is checking. Frequently check your restores by actually doing the restore somewhere else. Check that the backups are going offsite somehow. Test test test

link|improve this answer
Thanks :) But i kind of know all this but as always it's a matter of money and so on. We can't spend to much money on a super SLA and this time we couldn't get access to the server for 24 h. My question was basically if it is possible to restore a database even if one of the diff backups where missing. – Stuck Jul 14 '10 at 12:21
Yes, you just need the latest full backup - and a differential backup. So, if you take a full backup, and then three differentials across different days - you just restore the full backup, and any of the differentials depending on what you need. – Peter Schofield Jul 14 '10 at 12:26
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.