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 9 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply