March 26, 2009 at 6:13 am
Hi i have been going loopy the past few days trying to set up log shipping after a DR test and could get it to copy but not restore to DR the only error i kept getting was 'server out of sync'. Eventually i realised there was a T/Log backup job running every 15mins - im quite new to this hence my stupidity!
Anyway there were no errors in the logs and i just wondered why was i allowed to set up log shipping when there was a transaction log backup already running? Is this normal i didnt think it would be possible.
Also is there an log that i can look at for trans log errors or would that just be the event log or SQL log, it didnt seem to log any errors but i would have thought there should have been something to tell me of my mistake.
Thanks for reading
March 26, 2009 at 8:44 am
SQL server is powerful, but it cannot do everything for you
Logs will be in Error Logs and SQL Job histories, I think there are Log Shipping monitors tools out there as well
http://labs.red-gate.com/index.php/Log_Shipping_Monitor
Plus TLOG shipping is PER DATABASE, not PER SERVER, so I believe DBA should be the one in charge of setting it up and not conflicting with other jobs in place
March 26, 2009 at 8:59 am
ok fair enough thanks for the reply maybe i just expect too much 😀
March 27, 2009 at 5:18 am
little1 (3/26/2009)
Eventually i realised there was a T/Log backup job running every 15mins
Is this not the job created when you have setup logshipping with a latency of 15 mins or is this your Tlog backup as part of your DR plan?
Anyway there were no errors in the logs and i just wondered why was i allowed to set up log shipping when there was a transaction log backup already running? Is this normal i didnt think it would be possible.
It wouldn't be possible.
Also is there an log that i can look at for trans log errors or would that just be the event log or SQL log, it didnt seem to log any errors but i would have thought there should have been something to tell me of my mistake.
Thanks for reading
Everything should be logged in your log file. It's hard to read log file. Although you can find thris party tools check out Apex's log reader.http://www.apexsql.com/upgrades.asp
March 27, 2009 at 5:23 am
I think our application team enabled the T/Log job which ran every 15mins but i was unaware of it being enabled and also didnt realise this would affect the log shipping but i do now & wont forget that lesson 😉
I just didnt think i would be able to create the log shipping without it throwing up an error in that trans/log backups were active, i guess i just need to learn from this one. Got my SQL course in 2 weeks hopefully that will help bring all the bits of SQL info i have together in my head 🙂
March 27, 2009 at 5:30 am
Oh! you have got hat error already saying "Primary and secondary servers are out of synch". what happens is, if you take log backups separately breaks the log chain and secondary would not be able to restore the logs as the LSN's doesn't match.
If you wish to take log backups while you have log shipping setup then you should copy the log files from the same Backup folder that you have created for the log shipping. hope this gives you some insight.
Oh! good that you are taking a course but as always practice, practice and practice a lot.
March 27, 2009 at 5:42 am
Thanks for the advice really appreciated
March 27, 2009 at 6:21 am
little1 (3/27/2009)
Thanks for the advice really appreciated
My pleasure 🙂
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply