Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

AAG Backup Expand / Collapse
Author
Message
Posted Monday, September 2, 2013 9:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 12, 2014 5:25 AM
Points: 4, Visits: 26
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?
Post #1490654
Posted Tuesday, September 3, 2013 3:47 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:27 PM
Points: 13,776, Visits: 28,178
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
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1490849
Posted Tuesday, September 3, 2013 8:49 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:18 AM
Points: 31,078, Visits: 15,522
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







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1490991
Posted Tuesday, September 3, 2013 11:17 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:29 AM
Points: 5,872, Visits: 12,973
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.


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

Post #1491046
Posted Tuesday, September 3, 2013 10:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 12, 2014 5:25 AM
Points: 4, Visits: 26
Thank you all.....
Post #1491132
Posted Thursday, September 5, 2013 8:12 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 18, 2014 10:25 AM
Points: 301, Visits: 595
http://technet.microsoft.com/en-us/library/hh245119.aspx

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


MCSA SQL Server 2012
Post #1491809
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse