SQL Server 2012 - Log Shipping from a database that is part of an availability group - by Neil Matthewson

Status : 

 


1
0
Sign in
to vote
ID 773419 Comments
Status Active Workarounds
Type Bug Repros 1
Opened 12/4/2012 6:37:49 AM
Access Restriction Public

Description

When log shipping a database that is part of an availability group, although all jobs succeed a trn file is not produced. Therefore it is not copied, nor is it restored.

An example of it not being produced;


NULL
Microsoft (R) SQL Server Log Shipping Agent
[Assembly Version = 11.0.0.0, File Version = 11.0.2100.60 ((SQL11_RTM).120210-1917 )]
Copyright (c) 2012 Microsoft. All rights reserved.
NULL
2012-11-17 12:44:42.93  ----- START OF TRANSACTION LOG BACKUP -----
2012-11-17 12:44:43.00  Starting transaction log backup. Primary ID: '0a6c7977-a1e3-4967-b4c6-ee88482ab1c4'
2012-11-17 12:44:43.01  Retrieving backup settings. Primary ID: '0a6c7977-a1e3-4967-b4c6-ee88482ab1c4'
2012-11-17 12:44:43.03  Retrieved backup settings. Primary Database: 'ABC', Backup Directory: '\\ABCDB04\pendingv$\ABC', Backup Retention Period: 240 minute(s), Backup Compression: Server Default
2012-11-17 12:44:43.15  Deleting old log backup files. Primary Database: 'ABC'
2012-11-17 12:44:43.16  The backup operation was successful. Primary Database: 'ABC', Log Backup File: '' 
2012-11-17 12:44:43.17  ----- END OF TRANSACTION LOG BACKUP   -----
NULL
Exit Status: 0 (Success)
NULL


The workaround is to select 'Primary' under backup preferences. 


NULL
2012-11-17 12:46:07.00         ----- START OF TRANSACTION LOG BACKUP -----
2012-11-17 12:46:07.05         Starting transaction log backup. Primary ID: '0a6c7977-a1e3-4967-b4c6-ee88482ab1c4'
2012-11-17 12:46:07.05         Retrieving backup settings. Primary ID: '0a6c7977-a1e3-4967-b4c6-ee88482ab1c4'
2012-11-17 12:46:07.07         Retrieved backup settings. Primary Database: 'ABC', Backup Directory: '\\ABCDB04\pendingv$\ABC', Backup Retention Period: 240 minute(s), Backup Compression: Server Default
2012-11-17 12:46:07.15         Backing up transaction log. Primary Database: 'ABC', Log Backup File: '\\ABCDB04\pendingv$\ABC\ABC_20121117104607.trn'
2012-11-17 12:46:07.28         Deleting old log backup files. Primary Database: 'ABC'
2012-11-17 12:46:07.31         The backup operation was successful. Primary Database: 'ABC', Log Backup File: '\\ABCDB04\pendingv$\ABC\ABC_20121117104607.trn' 
2012-11-17 12:46:07.33         ----- END OF TRANSACTION LOG BACKUP   -----
NULL
Exit Status: 0 (Success)
NULL




This is ambiguous since these backup preferences are being sold as full backup options imo, and yet with this selected I can still go and perform a backup on a secondary server.
Sign in to post a comment.