May 5, 2015 at 3:37 am
Hi
I am looking at transaction log backups. Currently there is a maint plan setup to backup the logs every 15min. The job shows that it is successful but the backups are not created and the logs are not cleared. The databases are part of HAG(high avail groups). Is there any considerations other that just setting up the maint plan? The backup prefrences are set to primary on the HAG.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
May 5, 2015 at 4:06 am
The databases were fully backupped once?
Databases are in full/bulk logging mode?
Perhaps there are long running transactions/replications going on
You could convert the maintance plan to a normal job to see what's going wrong.
BACKUP LOG DATABASE X TO DISK='X:\AdventureWorks.TRN'
Or use Ola's backup script as a replacement for the backup/index maintenance plans
May 5, 2015 at 5:10 am
Scripted or manual backups work fine it is the maint plan that give successful but no backups created.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
May 5, 2015 at 5:14 am
Has somebody configured log backups to be done on one of the secondary nodes, or something like that?
May 5, 2015 at 5:21 am
Log backups has been configured on both but the backups are not getting created. I am getting the feeling I should just do it with a manual script.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
May 5, 2015 at 5:25 am
Do you mean the AG has been configured to use "Any Replica"?
Is there any sign of the backups in the msdb.dbo.backupset and msdb.dbo.backupmediafamily tables?
May 5, 2015 at 5:30 am
I changed it from Any to primary.
No backups get created, as if the maint plan skips over the databases in AG.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
May 5, 2015 at 5:35 am
You're not giving much information to work with! Where's the maintenance plan from, is there anything in the SQL log to indicate what's happening, etc?
May 5, 2015 at 5:43 am
Hi
It is a straight forward maint log backup created in SSMS. I see no errors in the log. I assumed that this would be a stupid mistake on my side. like AG's not supported by the maint plan log backups.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
May 5, 2015 at 9:29 am
Maintenance plans and AG work. I have had this problem before as well.
Try secondary only in the Ag Group and "copy-only backups" in the maintenance plan.
and yes when is fails it does not give much info in order to trouble shoot
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply