September 22, 2014 at 4:02 am
Hi Experts,
We are getting below error in our secondary replica.
The mirror database, "Financials", has insufficient transaction log data to preserve the log backup chain of the principal database. This may happen if a log backup from the principal database has not been taken or has not been restored on the mirror database. (Microsoft SQL Server, Error: 1478)
how can i resolve this?
TIA
September 22, 2014 at 4:59 am
This was removed by the editor as SPAM
September 22, 2014 at 6:27 am
jacksonandrew321 (9/22/2014)
As for some extent I know, u need to take full backup and a log backup as well on principal instance. Copy full and log backup from principal to mirror instance. On mirror instance restore full backup database with NORECOVERY option. On mirror instance apply log backup and then start synchronization on principal instance.
Thanks jacksonandrew321,
so basically need to start from scratch. How about recreating the same with 'Full' option?
September 22, 2014 at 7:16 am
Ratheesh.K.Nair (9/22/2014)
Hi Experts,We are getting below error in our secondary replica.
The mirror database, "Financials", has insufficient transaction log data to preserve the log backup chain of the principal database. This may happen if a log backup from the principal database has not been taken or has not been restored on the mirror database. (Microsoft SQL Server, Error: 1478)
how can i resolve this?
TIA
It looks as though data movement has been suspended to this secondary, check the AO config health and look for any errors
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 23, 2014 at 2:24 am
Perry Whittle (9/22/2014)
Ratheesh.K.Nair (9/22/2014)
Hi Experts,We are getting below error in our secondary replica.
The mirror database, "Financials", has insufficient transaction log data to preserve the log backup chain of the principal database. This may happen if a log backup from the principal database has not been taken or has not been restored on the mirror database. (Microsoft SQL Server, Error: 1478)
how can i resolve this?
TIA
It looks as though data movement has been suspended to this secondary, check the AO config health and look for any errors
Thanks Perry. Thats the only error i found from dashboard.
September 23, 2014 at 4:07 am
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply