question

NeophyteSQL avatar image
0 Votes"
NeophyteSQL asked SeeyaXi-msft commented

Shut down primary replica node always on

We have a always on 2 node set up
Primary replica needs to be shut down for an extended time for testing DR
What is the ideal way to accomplish this

2 node cluster
Asynchronous mode
Quorum has not been set up
Databases are synced from node a to node b

sql-server-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @NeophyteSQL ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

Hi @NeophyteSQL

Just checking in to see if above information was helpful. If you have any further updates on this issue, please feel free to post back. If you think my reply is helpful to you, please remember to mark it as an answer. Warm thanks.

Best regards,
Seeya

0 Votes 0 ·
SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @NeophyteSQL,

You can manually failover to make the primary replica become a secondary replica, and then make it OFFLINE. After you complete the corresponding work, you can bring it ONLINE and turn it the primary replica.
Refer to this: https://www.sqlshack.com/sql-server-always-on-availability-group-data-resynchronization/

Best regards,
Seeya


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

NeophyteSQL avatar image
0 Votes"
NeophyteSQL answered

thank you, i forgot to mention only few databases that are needed for BI purposes are synced from node a to node b.

not all databases are in sync, so failing over is not an option.

however, node A needs to be power down for extended time, what would be the ideal way to accomplish this without failing over to node B.

how does powering down node A affect node B. Does node B also need to be shut down the whole time when node A is down? is there a speciifc order

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered SeeyaXi-msft commented

Hi @NeophyteSQL,

Given that you need to power off, it is better to perform manual failover. Synchronous mode can also perform manual failover.

Does node B also need to be shut down the whole time when node A is down?

After a failover, the secondary copy becomes the primary copy, and it does not need to be shut down.

Best regards,
Seeya
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

the transaction logs on primary would continue to grow until failed back, correct?

IS this risky beecause we have limited disk space on the servers.

0 Votes 0 ·

Hi @NeophyteSQL,

the transaction logs on primary would continue to grow until failed back, correct?

I assume you are talking about a failover node B. Yes.

IS this risky beecause we have limited disk space on the servers.

If there is space on the disk, you can ignore it. If there is not much space left on the disk, you need to find an other disk where you can add more data files.
You can make a complete backup of the database to ensure that data will not be lost. (You should also have regular backup jobs).

BTW, you need to set the automatic growth value instead of proportionally, so that each increase will not be too large or too small.

Best regards,
Seeya
0 Votes 0 ·