Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

What's the best/easiest backup solution for my use case?

  • Windows Server 2008 R2
  • Has a finance program called The Financial Edge (Blackbaud) that uses SQL Server 2008 R2 to keep its database
  • Stores user's files for them (i.e. it's also a file server)
  • We want to be able to rotate 2 external disks (one on-site, one off-site; swapped weekly)
share|improve this question
add comment

2 Answers

up vote 3 down vote accepted

Going to assume the data is less than 2TB. If so you could just use external USB drives and the built in windows backup along with SQL server backup. Next level up would be to stand up a dedicated backup server running System Center Data Protection Manager.

share|improve this answer
    
How do you rotate drives using Windows Server Backup? And as for SQL, the only way I've found to get it included in the Windows Server Backup is to have it do it's own backups, and have Windows Server Backup include that location to it's backups. –  David Apr 19 '12 at 17:52
    
Using stuff you already have, this is the way to go. The built-in tools provide you with enough to keep your data redundant. Personally, I enjoy third party tools (like Novastor) that will take a bare-metal image of the machine, and using things like VSS, it can make a complete backup of your system INCLUDING SQL. –  JohnThePro Apr 19 '12 at 17:56
    
What about the two drives with WSB? –  David Apr 19 '12 at 18:35
1  
@David - Yes, use the built in SQL backup and then backup that data to the external drive. You can use windows backup or just manually copy the backups. –  murisonc Apr 23 '12 at 14:43
1  
@David - WSB can be set up with multiple target drives. It will back up to any drive that is available. So if you plug both drives in, set up your backup, and then just leave one drive plugged in, it will happily back up. Then swap the drives every week or so. –  Mark Henderson Apr 23 '12 at 23:08
add comment

I would suggest using a combination of 2 very simple programs. Free versions of both should be sufficient in you case.

For file backups use SyncBack. Setup a task to sync in one direction (Source to Destination - your external drive) only and schedule it.

For SQL backup use SQLBackupAndFTP. As a target for storing your backups specify "Local/Network folder" and set it to a folder in your external drive. Schedule it to perform any types of backups as often as you need.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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