SQLServerCentral.com / SQL Server 2012 / SQL 2012 - General / AAG Backup / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 22:37:35 GMT20RE: AAG Backuphttp://www.sqlservercentral.com/Forums/Topic1490654-2799-1.aspxhttp://technet.microsoft.com/en-us/library/hh245119.aspxI found all my answers here. Hope this helps as well.Thu, 05 Sep 2013 08:12:19 GMTlkennedy76RE: AAG Backuphttp://www.sqlservercentral.com/Forums/Topic1490654-2799-1.aspxThank you all.....Tue, 03 Sep 2013 22:23:30 GMTrajeshvarunRE: AAG Backuphttp://www.sqlservercentral.com/Forums/Topic1490654-2799-1.aspxyou cannot do a log backup on the master database as it can only be in simple mode. That will be why the TLOG backup is failing for system databases (model and msdb may also be in simple mode).Full backups will suffice for system databases.Tue, 03 Sep 2013 11:17:15 GMTgeorge sibbaldRE: AAG Backuphttp://www.sqlservercentral.com/Forums/Topic1490654-2799-1.aspx[quote][b]Grant Fritchey (9/3/2013)[/b][hr]You must use COPY_ONLY when backing up a database on a secondary server. When backing up a database on the primary you can run a regular backup, or a COPY_ONLY backup. As to the transaction logs for system databases, not all system databases have transaction logs, and no, in general, they don't need to be backed up. For system databases I usually just run full backups.[/quote]+1Tue, 03 Sep 2013 08:49:17 GMTSteve Jones - SSC EditorRE: AAG Backuphttp://www.sqlservercentral.com/Forums/Topic1490654-2799-1.aspxYou must use COPY_ONLY when backing up a database on a secondary server. When backing up a database on the primary you can run a regular backup, or a COPY_ONLY backup. As to the transaction logs for system databases, not all system databases have transaction logs, and no, in general, they don't need to be backed up. For system databases I usually just run full backups.Tue, 03 Sep 2013 03:47:19 GMTGrant FritcheyAAG Backuphttp://www.sqlservercentral.com/Forums/Topic1490654-2799-1.aspxHi all I have 2 doubts on this can anyone please clarify: On primary for system database backup I have not selected copy only backup, will that be okie? On secondary while configuring Txlog backup If I select all databases backup plan is failing where as if I choose user databases backup it is running fine. Don't we have txlog bkp for system databases backups in AAG?Mon, 02 Sep 2013 09:31:22 GMTrajeshvarun