要使用AlwaysOn可用性组存储,需要先创建一个可用性组和一个或多个可用性组副本。下面是一个示例代码,演示如何使用Transact-SQL创建可用性组和副本。
CREATE AVAILABILITY GROUP MyAvailabilityGroup
WITH (AUTOMATED_BACKUP_PREFERENCE = SECONDARY)
FOR REPLICA ON
'Replica1' WITH (
ENDPOINT_URL = 'TCP://Replica1.contoso.com:5022',
AVAILABILITY_MODE = SYNCHRONOUS_COMMIT,
FAILOVER_MODE = AUTOMATIC,
SEEDING_MODE = AUTOMATIC),
'Replica2' WITH (
ENDPOINT_URL = 'TCP://Replica2.contoso.com:5022',
AVAILABILITY_MODE = SYNCHRONOUS_COMMIT,
FAILOVER_MODE = AUTOMATIC,
SEEDING_MODE = AUTOMATIC);
ALTER AVAILABILITY GROUP MyAvailabilityGroup
ADD DATABASE MyDatabase;
ALTER AVAILABILITY GROUP MyAvailabilityGroup
ADD REPLICA ON
'Replica3' WITH (
ENDPOINT_URL = 'TCP://Replica3.contoso.com:5022',
AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT,
FAILOVER_MODE = MANUAL,
SEEDING_MODE = MANUAL);
ALTER AVAILABILITY GROUP MyAvailabilityGroup
JOIN;
以上代码演示了如何创建一个包含多个副本的AlwaysOn可用性组存储。注意,这只是一个示例,并且需要根据实际环境进行修改和调整。