regular full backup on secondary replica

Chaitanya Kiran 696 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.
12,654 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Marcin Policht 9,580 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 No comments

  2. LucyChen-MSFT 635 Reputation points Microsoft Vendor
    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 No comments