User Tools

Site Tools


wiki:backuppc_mssql

This is an old revision of the document!


Backup MSSQL Databases with BackupPC

Introduction

I did this before with Bareos/Bacula. I've since decided that product is a bit too black box for my liking. It always did what I asked of it, but the database would crash here and there and that freaked me out a bit. On to something new, and BackupPC was surprising better than I thought it would be. Admittedly it doesn't have an agent in the traditional sense which I don't like, but I was still able to achieve the needed goals.

What you'll need

  • Working BackupPC installation
  • SQL server account with sa-like privs - we'll create a more restricted backup user
  • Administrator account on server to install Cygwin SSH service
  • Unprivileged account on domain or local to server for backuppc user

Get the SQL bits out of the way

  1. Ordered List Item
wiki/backuppc_mssql.1433270105.txt.gz · Last modified: 2018/09/27 02:30 (external edit)