SQL Server Performance Forum – Threads Archive
Log Shipping and backup
Hi, First, thanks for help with solution for Reporting server.Now I’m getting another problem. We have log backup every 2 hours on our production server.
Now, If I set-up Log Shipping every 1 hour what is going to happened with my normal backup?
In the other hand normal backup (log backup) can interrupt my log shipping. Am I right? I understand that I should make backups of log shipping files to tape and disable my normal log backup job. Of course Full backup can still remain unchanged.
Log shipping takes care of transaction logs and will not have any issue on the affect of normal backup. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Yes, Buy I have to disable Log Backup on my normal backup procedure.
If not Log Shipping wil fail.
Am I right.
If you are running a log backup in a different job then yes you need to disable it… Check the following two…
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx
http://support.microsoft.com/kb/314515 MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
Yes it will invalidate the LSN for multiple log backups and log shipping monitor reports the issues. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
And in most of the cases it fails due to LSN mismatch so better be careful with this. Hemantgiri S. Goswami
MS SQL Server MVP
————————-
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami http://hemantgirisgoswami.blogspot.com
Thanks again <img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />
]]>