question

SQLDBA123 avatar image
SQLDBA123 asked

SQL Server Always ON --Adding database on 3rd node downtime required?

**Scenario:** 3 nodes stand-alone servers SQL/OS versions: SQL Server 2012 SP2/windows server 2012 R2 DataCenter1: **strong text** Server1 TestDB1 **DataCenter2:** Server2 TestDB1 Always ON configured with synch mode, automatic failover Datacenter1 to DataCenter2 AlwaysON Availability Group created from Datacenter1 to DataCenter2 We have DataCenter3(DR) and want to configure Always ON Asynch-mode from DataCenter1 - DataCenter3 for TestDB1 database. **DataCenter3** Server3 TestDB1 **Question:** Do we need any down time to configure Always ON ASynch-mode for DataCenter1 - DataCenter3 for TestDB1 database? (After adding the 3rd node into cluster, will add database in DataCenter1 - DataCenter3 servers) Thanks
sql-server-2012
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Wilfred van Dijk avatar image
Wilfred van Dijk answered
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.