Adding a very large database to Alwayson Avalibility group

Svatopluk 21 Reputation points
2022-03-14T23:52:17.09+00:00

Hi there,

I have a 10 TB database that I will be moving from stand-alone sql server to AOAG sql server (2 node cluster). To make it fast I am going to use SAN snapshot and then attach the drives with files to the AOAG sql server and attached the database from the files - hoping to do that on both PRIMARY and REPLICA.
I was hoping that I could use 'Join only' only 'Select Initial Data Synchronization Page' to add the database to AOAG and start syncing. The quandary is that the database on SECONDARY replica must be in NORECOVERY state.
But how do I (put an attached database to NORECOVERY state) without restoring, please? (I do not have the time backing up and restoring the database)
Thank you!

@Svatopluk

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,903 questions
0 comments No comments
{count} votes

Accepted answer
  1. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2022-03-15T02:21:00.967+00:00

    Hi @Svatopluk ,

    > But how do I (put an attached database to NORECOVERY state) without restoring, please?

    No. Unfortunately, it is not possible to attach database with NORECOVERY.

    In addition, suggest you using log shipping to prepare this VLDB to primary replica and secondary replica. Select Join Only to start data synchronization as we used Log shipping to keep the VLDB in sync across all servers. Please refer to below blog to get detail information.

    Adding a VLDB database to an SQL Server Availability Group


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


0 additional answers

Sort by: Most helpful