AAG Backup

Question

AAG Backup

rajeshvarun

SSC Enthusiast

Points: 188
More actions
September 2, 2013 at 9:31 am

#297403

Hi 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?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398690 More actions · Answer 1

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.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Steve Jones - SSC Editor SSC Guru Points: 734444 More actions · Answer 2

Grant Fritchey (9/3/2013)
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.

+1

george sibbald SSC Guru Points: 104210 More actions · Answer 3

you 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.

---------------------------------------------------------------------

rajeshvarun SSC Enthusiast Points: 188 More actions · Answer 4

rajeshvarun

SSC Enthusiast

Points: 188

September 3, 2013 at 10:23 pm

#1647175

Thank you all.....

lkennedy76 SSChampion Points: 13683 More actions · Answer 5

http://technet.microsoft.com/en-us/library/hh245119.aspx

I found all my answers here. Hope this helps as well.

MCSE SQL Server 2012\2014\2016