Differences

This shows you the differences between two versions of the page.

--- computing:backup:ahsay_mssql [2014/05/13 10:54]
gcooper created
+++ computing:backup:ahsay_mssql [2020/04/29 11:31] (current)
gcooper
@@ Line 1: / Line 1: @@
 ====== 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 =====
@@ Line 21: / Line 23: @@
   * 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]]**.

Virtual Architects Support Wiki