How can we help you today? How can we help you today?

Native replication and RedGate SQL Backup

Please ignore, this post is incorrect


Hi,

Have a database which is being transactionally replicated in SQL 2008R2 using native SQL commands. I would like to now introduce RedGate full backups and hourly transaction log backups, however I'm not sure how to integrate
the transaction log backups seeing as the replication takes it's own native log backups.

Would the simplest solution be for RedGate to take the once daily full backup and leave native SQL to do the transaction log backups as part of the replication. Can't see any other way.

Thanks
thedavegray
0

Comments

4 comments

Sort by
  • sachinyadavg629
    Looking to build a high-performance, cross-platform mobile app? Hire experienced React Native developers to transform your app ideas into reality. Specializing in scalable, robust, and user-friendly mobile applications, these developers leverage React Native’s latest features and tools to deliver tailored solutions for diverse industries. Elevate your digital presence with seamless app functionality, exceptional user experience, and timely project delivery. Contact skilled professionals today to kickstart your app development journey with confidence!
    sachinyadavg629
    0
  • sachinyadavg629
    An education app development company creates customized EdTech solutions, integrating advanced technologies like AI, gamification, and blockchain to enhance digital learning. Hire React Native developers for EdTech apps ensures cross-platform compatibility, faster development, and high performance, making it a cost-effective choice for seamless user experiences.
    sachinyadavg629
    0
  • sachinyadavg629
    Hire AI developers to help businesses automate processes, enhance decision-making, and improve customer experiences. AI-powered solutions boost efficiency, reduce costs, and enable data-driven insights for better strategies. When you hire ML developers, they build intelligent systems for personalized marketing, fraud detection, and predictive analytics. Additionally, when you hire Golang developers, they create high-performance, scalable applications that enhance AI and ML capabilities. Investing in top tech talent future-proofs businesses, driving innovation and sustainable growth.
    sachinyadavg629
    0
  • David Richard

    That’s an interesting situation. When working with SQL 2008R2 transactional replication, the replication agent doesn’t actually take its own transaction log backups—it just reads the transaction log entries. You can still configure RedGate to run your full backups and transaction log backups without interfering with replication. The key is to ensure the log backups are consistent and not truncated by multiple processes.

    One approach would be:

    • Let RedGate handle both full and log backups, since it fully supports replication scenarios.
    • Ensure your log backup schedule aligns with your recovery objectives (e.g., every hour).
    • Test the restore sequence (full + logs) in a dev environment to confirm replication isn’t impacted.

    I’ve seen a similar integration in an Education App Development Company project where large student databases were replicated for analytics and reporting. They successfully used RedGate for both full and log backups while keeping replication intact.

    So yes—you don’t have to split duties between native SQL and RedGate. It’s cleaner to let one tool (RedGate) manage all backups, provided you monitor and validate restore paths.

    David Richard
    0

Add comment

Please sign in to leave a comment.