====== Ahsay - Microsoft SQL Server Backup ======

See also **[[https://www.sonoracomm.com/wiki/doku.php?do=search&id=ahsay|Other Ahsay pages in this wiki]]**

===== 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 **[[computing:windows:mssql_backup|Microsoft SQL Server Backup]]**.