July 11, 2008 at 4:13 am
I configured logshiping in my production database (15 mins interval)
also i take full backups on sunday, differential backup on weekdays and logbackup for every 1 hour
Whether the above mentioned manual backup affect the logshiping???
Plz reply??
July 11, 2008 at 1:46 pm
No regular backups like full and differential doesn't affect logshipping.
July 31, 2008 at 12:01 am
But I think Logbackup can break LSN no. used in logshipping.
July 31, 2008 at 2:12 am
Any log backups that you take on a DB that's the source of logshipping must be shipped to the secondary machine and applied. If you don't, the log backups taken after that will not apply. You'll get an error about LSN mismatch.
The full and diff backups are fine.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 1, 2008 at 2:32 am
Since you are already backing up the transaction log every 15 minutes in your log shipping setup, is there really a need to have another job that backs it up every hour?
If you really do need to do that, you would need to restore those hourly log backups on the secondary server too. You would need to sort them out first though, using either the file timestamp as a guide, or the backup details stored in msdb..backupset and msdb..backupmediafamily.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply