question

Bugmesh avatar image
Bugmesh asked

Can you create an availability group on a single node cluster

We had our SAN go down and we are in the process of trying to rebuild clusters and groups, I have seen in the operating system that you create a single node AG, but I have not been able to find how to do this in SQL Server. It would be extremely helpful if someone could reveal how that is done. If the answer is Nope can't do it, then that's OK too

Thank You

clusteronalwaysavailabilitysingle node
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

·
Shawn_Melton avatar image
Shawn_Melton answered

Yes, it is no different than creating an AG with multiple replicas you just provide one. However do note though that since the AG has no place to replicate the database, the log will never truncate and will constantly grow until it has somewhere to replicate the log.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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.