User Tools

Site Tools


computing:backup:ahsay_mssql

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

Recovery Model

https://www.sqlshack.com/understanding-database-recovery-models/

http://msdn.microsoft.com/en-us/library/ms190190.aspx

Microsoft System databases such as 'master', 'msdb' and 'model' must remain set to the SIMPLE recovery model. Therefore, you can only do Full backups on these databases reliably (no Transaction Log backups).

For other databases, particularly larger databases, you can also use Transaction Log backups. Set the recovery model of each database to FULL (not SIMPLE) with the OBM client.

:!: To change the database recovery mode from within Ahsay OBM, right-click on the database name in Backup Source to change.

See Microsoft SQL Server Backup.

computing/backup/ahsay_mssql.txt · Last modified: 2020/04/29 11:31 by gcooper