Home / server / Questions / 381232
Accepted
David
Asked: 2012-04-20 09:38:52 +0800 CST

Backup for SQL & Server 2008 R2?

  • 772

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)
backup windows-server-2008-r2 sql-server-2008-r2

2 Answers

  1. Best Answer

    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.

    • 3

  2. 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.

    • 0