Share via

regular full backup on secondary replica

Chaitanya Kiran 776 Reputation points
2024-03-30T13:55:56.43+00:00

In Availability Groups(AG), can we take regular full backup on secondary replica

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,361 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Marcin Policht 18,270 Reputation points MVP
    2024-03-30T14:32:16.61+00:00

    Copy-only full backup - as per https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/active-secondaries-backup-on-secondary-replicas-always-on-availability-groups?view=sql-server-ver16

    Backup Types Supported on Secondary Replicas

    • BACKUP DATABASE supports only copy-only full backups of databases, files, or filegroups when it's executed on secondary replicas. Copy-only backups don't impact the log chain or clear the differential bitmap.

    If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

    hth

    Marcin

    0 comments
  2. LucyChenMSFT-4874 3,005 Reputation points
    2024-04-01T05:59:55.2166667+00:00

    Hi @Chaitanya Kiran,

    We cannot take regular full backup on secondary replica, it will change the database, you can take COPY_ONLY backup. Hope this article can help you well.

    In addition, here is a known issue: https://www.sqlservercentral.com/forums/topic/why-cant-we-take-regular-full-backup-on-secondary-replica, I hope this can help you understand.

    Best regards,

    Lucy Chen

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    https://docs.microsoft.com/en-us/answers/support/email-notifications

    0 comments