September 2, 2013 at 9:31 am
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?
September 3, 2013 at 3:47 am
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
September 3, 2013 at 8:49 am
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
September 3, 2013 at 11:17 am
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.
---------------------------------------------------------------------
September 3, 2013 at 10:23 pm
Thank you all.....
September 5, 2013 at 8:12 am
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy