September 8, 2008 at 1:28 am
Can we perform log backup of the dbs which were participating in replication and log shipping..
September 8, 2008 at 8:16 am
You can take backups of the log of a database that's used for replication as long as the DB is in full recovery mode. No problems there
The log shipping requires that all log backups that are taken on the source machine are applied on the failover. This is because log backups form a chain. If you backup the log on your primary server and don't apply that log backup to the secondary server, your log shipping will fail and will have to be reinitialised.
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply