June 11, 2012 at 1:27 pm
Here is what I got:
Server A, Database A
Server B, Database A
Created log shipping setup for database A from Server A to Server B.
Have 3 jobs:
Server A: Log Backup Job (every 15 mins)
Server 2: Copy Log and Restore Log (every 15 mins)
Log backup and copy job works fine. Restore is also running fine but its not restoring logs.
Getting following error:
The log in this backup set begins at LSN which is too recent. The earlier log backup can be applied.
We have another backup job which backs up log backup every 10 mins.
I think that job is interfering this log shipping setup.
What are my options?
I cannot disable this log backup job which runs every 10 mins because thats a business requirement.
Thanks,
San
June 11, 2012 at 3:44 pm
when logshipping the only backups of the log must be done via the logshipping jobs.
You will have to remove the 10 min log backups outside of logshipping and change the logshipping backup frequency to 10 mins to fulfill your business requirements.
to reestablish logshipping your easiest option is to restart from a fresh full backup, you wont need to remove and rebuild logshipping set up itself.
---------------------------------------------------------------------
June 11, 2012 at 3:56 pm
george sibbald (6/11/2012)
when logshipping the only backups of the log must be done via the logshipping jobs.You will have to remove the 10 min log backups outside of logshipping and change the logshipping backup frequency to 10 mins to fulfill your business requirements.
to reestablish logshipping your easiest option is to restart from a fresh full backup, you wont need to remove and rebuild logshipping set up itself.
Can you temporarally suspend (stop) logshipping, run a differential backup, apply the differential backup to the logshipping destination database (with NO RECOVERY), restart logshipping? Just asking as I haven't worked with logshipping other than in a test environment years ago.
June 12, 2012 at 1:43 am
you can restart from a differential if no further full backup of the primary has been done since the one used to initialise logshipping, i.e. the primary and the secondary have the same differential base.
---------------------------------------------------------------------
June 12, 2012 at 1:45 am
Ideally you shouldn't be having a log backup job when you have log shipping doing it for you.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 12, 2012 at 1:49 am
Sachin Nandanwar (6/12/2012)
Ideally you shouldn't be having a log backup job when you have log shipping doing it for you.
to reinforce that you definitely shouldn't have other log backup jobs when log shipping is running
---------------------------------------------------------------------
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply