User Tools

Site Tools


computing:backup:ahsay_mssql

This is an old revision of the document!


Ahsay - Microsoft SQL Server Backup

Credentials

To back up MSSQL databases, you need:

  • Windows Admin Access
  • MSSQL Database Admin Access

You must enter two sets of credentials in the backup job definition.

:!: You may find it more reliable to use the sa user and password for database access.

Multiple Machines

It is common to have a MSSQL server running on a dedicated host but backing up to a single Ahsay backup account with other servers.

  • Use the Local Administrator account for configuration and filesystem access
    • <servername>\administrator
    • .obm configuration folder will be in C:\Users\Administrator\.obm
  • Use the sa database administrator account for database access
    • Password doesn't change when Windows passwords change
computing/backup/ahsay_mssql.1400000080.txt.gz · Last modified: 2014/05/13 10:54 by gcooper