SQL Server 2016 가용성 그룹 만들기 Direct-Seeding 편

본 게시물은 개인적인 의견으로 작성되었으니 절대적인 정보가 아닐 수 있습니다. 참고만 하시고 궁금한 사항이 있으시면 연락주세요.

티스토리 뷰

SQL AlwaysON AG - CATEGORY

SQL Server 2016 가용성 그룹 만들기 Direct-Seeding 편

AWS-in 2016. 10. 14. 17:35

해당 기능은 T-SQL로만 가능하다. SQL Server 2016 에서 새로 생긴 기능이다.

일단 만들어보자.

-- SQLCMD Mode

:Connect AG2016-S1\AG1

-- For additional Transact-SQL code examples of creating an availability group with Direct Seeding

-- Create the availability group, MyAG:

CREATE AVAILABILITY GROUP [AG-Seeding]

WITH (AUTOMATED_BACKUP_PREFERENCE = SECONDARY,

DB_FAILOVER = ON,

DTC_SUPPORT = NONE)

FOR -- Database Not in

REPLICA ON

N'AG2016-S1\AG1' WITH (

ENDPOINT_URL = N'TCP://AG2016-S1.overtop.local:5022',

FAILOVER_MODE = AUTOMATIC,

AVAILABILITY_MODE = SYNCHRONOUS_COMMIT,

BACKUP_PRIORITY = 50,

SECONDARY_ROLE(ALLOW_CONNECTIONS = ALL),

SEEDING_MODE=AUTOMATIC

N'AG2016-S4\AG4' WITH (

ENDPOINT_URL = N'TCP://AG2016-S4.overtop.local:5022',

FAILOVER_MODE = MANUAL,

AVAILABILITY_MODE = SYNCHRONOUS_COMMIT,

BACKUP_PRIORITY = 50,

SECONDARY_ROLE(ALLOW_CONNECTIONS = ALL),

SEEDING_MODE=AUTOMATIC

);

ALTER AVAILABILITY GROUP [AG-Seeding]

ADD LISTENER N'AGSeedLsn' (

WITH IP ((N'10.1.14.76', N'255.255.255.0')), PORT=1433);

:Connect AG2016-S4\AG4

-- On the server instance that hosts the secondary replica,

-- join the secondary replica to the availability group:

ALTER AVAILABILITY GROUP [AG-Seeding] JOIN;

-- configure the newly joined replica permissions to create database:

ALTER AVAILABILITY GROUP [AG-Seeding]

GRANT CREATE ANY DATABASE

:Connect AG2016-S1\AG1

-- On the primary replica, add databases to your availability group.

-- When you add the database to the availability group,

-- seeding of the database to the secondary replica(s) commences.

-- When complete, these databases should appear on the primary and secondary as part of the availability group.

ALTER AVAILABILITY GROUP [AG-Seeding] ADD DATABASE [AGDirectSeeding01]

ALTER AVAILABILITY GROUP [AG-Seeding] ADD DATABASE [AGDirectSeeding02]

끝.

아주 간편하고 좋다. 언제 써야 좋을까? 고민해보자. ㅋㅋ

-- Direct Seeding DMVs

select * from sys.dm_hadr_automatic_seeding

select * from sys.dm_hadr_physical_seeding_stats

sp_readerrorlog

sp_cycle_errorlog

[SQL 로그]

2016-10-14 17:18:00.510 spid79 Always On: The local replica of availability group 'AG-Seeding' is preparing to transition to the primary role in response to a request from the Windows Server Failover Clustering (WSFC) cluster. This is an informational message only. No user action is req

2016-10-14 17:18:00.540 spid79 The state of the local availability replica in availability group 'AG-Seeding' has changed from 'RESOLVING_NORMAL' to 'PRIMARY_PENDING'. The state changed because the availability group is coming online. For more information, see the SQL Server error log

2016-10-14 17:18:00.540 Server The lease worker of availability group 'AG-Seeding' is now sleeping the excess lease time (164968 ms) supplied during online. This is an informational message only. No user action is required.

2016-10-14 17:18:14.890 Server The Service Broker endpoint is in disabled or stopped state.

2016-10-14 17:18:14.890 Server Server is listening on [ 10.1.14.76 <ipv4> 1433].

2016-10-14 17:18:14.890 Server Started listening on virtual network name 'AGSeedLsn'. No user action is required.

2016-10-14 17:18:14.930 Server The state of the local availability replica in availability group 'AG-Seeding' has changed from 'PRIMARY_PENDING' to 'PRIMARY_NORMAL'. The state changed because the local replica has completed processing Online command from Windows Server Failover Cluster

2016-10-14 17:18:14.930 Server The Service Broker endpoint is in disabled or stopped state.

2016-10-14 17:19:00.080 spid87s A connection for availability group 'AG-Seeding' from availability replica 'AG2016-S1\AG1' with id [801464FB-3175-4D31-B335-DF311E06F030] to 'AG2016-S4\AG4' with id [C5FB7CFF-6242-4273-A330-ED9DC0758F38] has been successfully established. This is an info

2016-10-14 17:19:08.110 spid89s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:0

2016-10-14 17:19:08.120 spid89s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:0

2016-10-14 17:19:08.160 spid89s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:0

2016-10-14 17:19:08.440 spid27s Processed 320 pages for database 'AGDirectSeeding01', file 'AGDirectSeeding01' on file 1.

2016-10-14 17:19:08.520 spid27s Processed 43 pages for database 'AGDirectSeeding01', file 'AGDirectSeeding01_log' on file 1.

2016-10-14 17:19:08.550 spid28s Processed 320 pages for database 'AGDirectSeeding02', file 'AGDirectSeeding02' on file 1.

2016-10-14 17:19:08.610 spid28s Processed 43 pages for database 'AGDirectSeeding02', file 'AGDirectSeeding02_log' on file 1.

2016-10-14 17:19:08.650 Backup Database backed up. Database: AGDirectSeeding01, creation date(time): 2016/10/14(14:40:17), pages dumped: 562, first LSN: 34:120:65, last LSN: 34:808:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{DD9628B0-E2EB-42FF-AB97

2016-10-14 17:19:08.690 spid27s BACKUP DATABASE successfully processed 363 pages in 0.366 seconds (7.748 MB/sec).

2016-10-14 17:19:08.690 Backup BACKUP DATABASE successfully processed 363 pages in 0.366 seconds (7.748 MB/sec).

2016-10-14 17:19:08.710 Backup Database backed up. Database: AGDirectSeeding02, creation date(time): 2016/10/14(14:40:27), pages dumped: 562, first LSN: 34:120:65, last LSN: 34:800:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{73772276-8EE6-431B-8F8A

2016-10-14 17:19:08.750 spid28s BACKUP DATABASE successfully processed 363 pages in 0.319 seconds (8.877 MB/sec).

2016-10-14 17:19:08.750 Backup BACKUP DATABASE successfully processed 363 pages in 0.319 seconds (8.877 MB/sec).

2016-10-14 17:19:09.600 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:0

2016-10-14 17:19:09.600 spid64s Always On Availability Groups connection with secondary database established for primary database 'AGDirectSeeding01' on the availability replica 'AG2016-S4\AG4' with Replica ID: {c5fb7cff-6242-4273-a330-ed9dc0758f38}. This is an informational message only

2016-10-14 17:19:09.620 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.670 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:0

2016-10-14 17:19:09.670 spid64s Always On Availability Groups connection with secondary database established for primary database 'AGDirectSeeding02' on the availability replica 'AG2016-S4\AG4' with Replica ID: {c5fb7cff-6242-4273-a330-ed9dc0758f38}. This is an informational message only

2016-10-14 17:19:09.680 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.740 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.750 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.750 spid64s Always On Availability Groups connection with secondary database established for primary database 'AGDirectSeeding01' on the availability replica 'AG2016-S4\AG4' with Replica ID: {c5fb7cff-6242-4273-a330-ed9dc0758f38}. This is an informational message only

2016-10-14 17:19:09.750 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.760 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.760 spid64s Always On Availability Groups connection with secondary database established for primary database 'AGDirectSeeding01' on the availability replica 'AG2016-S4\AG4' with Replica ID: {c5fb7cff-6242-4273-a330-ed9dc0758f38}. This is an informational message only

2016-10-14 17:19:09.760 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.780 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.800 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:4

2016-10-14 17:19:09.800 spid64s DbMgrPartnerCommitPolicy::SetSyncState: C5FB7CFF-6242-4273-A330-ED9DC0758F38:4

2016-10-14 17:19:09.800 spid30s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:4

2016-10-14 17:19:09.800 spid30s Always On Availability Groups connection with secondary database established for primary database 'AGDirectSeeding01' on the availability replica 'AG2016-S4\AG4' with Replica ID: {c5fb7cff-6242-4273-a330-ed9dc0758f38}. This is an informational message only

2016-10-14 17:19:09.800 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:4

2016-10-14 17:19:09.820 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.820 spid64s DbMgrPartnerCommitPolicy::SetSyncState: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.820 spid30s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.850 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.860 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:4

2016-10-14 17:19:09.860 spid64s DbMgrPartnerCommitPolicy::SetSyncState: C5FB7CFF-6242-4273-A330-ED9DC0758F38:4

2016-10-14 17:19:09.860 spid50s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.880 spid50s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.880 spid50s Always On Availability Groups connection with secondary database established for primary database 'AGDirectSeeding02' on the availability replica 'AG2016-S4\AG4' with Replica ID: {c5fb7cff-6242-4273-a330-ed9dc0758f38}. This is an informational message only

2016-10-14 17:19:09.880 spid50s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.890 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.890 spid64s Always On Availability Groups connection with secondary database established for primary database 'AGDirectSeeding02' on the availability replica 'AG2016-S4\AG4' with Replica ID: {c5fb7cff-6242-4273-a330-ed9dc0758f38}. This is an informational message only

2016-10-14 17:19:09.890 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.910 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.920 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:4

2016-10-14 17:19:09.920 spid64s DbMgrPartnerCommitPolicy::SetSyncState: C5FB7CFF-6242-4273-A330-ED9DC0758F38:4

2016-10-14 17:19:09.920 spid30s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:4

2016-10-14 17:19:09.920 spid30s Always On Availability Groups connection with secondary database established for primary database 'AGDirectSeeding02' on the availability replica 'AG2016-S4\AG4' with Replica ID: {c5fb7cff-6242-4273-a330-ed9dc0758f38}. This is an informational message only

2016-10-14 17:19:09.920 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:4

2016-10-14 17:19:09.930 spid64s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.930 spid64s DbMgrPartnerCommitPolicy::SetSyncState: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.930 spid30s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.940 spid30s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:1

2016-10-14 17:19:09.980 spid30s DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint: C5FB7CFF-6242-4273-A330-ED9DC0758F38:4

2016-10-14 17:19:09.980 spid30s DbMgrPartnerCommitPolicy::SetSyncState: C5FB7CFF-6242-4273-A330-ED9DC0758F38:4

2016-10-14 17:19:00.080 spid74s The state of the local availability replica in availability group 'AG-Seeding' has changed from 'RESOLVING_NORMAL' to 'SECONDARY_NORMAL'. The state changed because the availability group state has changed in Windows Server Failover Clustering (WSFC). For

2016-10-14 17:19:00.080 spid33s A connection for availability group 'AG-Seeding' from availability replica 'AG2016-S4\AG4' with id [C5FB7CFF-6242-4273-A330-ED9DC0758F38] to 'AG2016-S1\AG1' with id [801464FB-3175-4D31-B335-DF311E06F030] has been successfully established. This is an info

2016-10-14 17:19:08.180 spid75s Error: 911, Severity: 16, State: 1.

2016-10-14 17:19:08.180 spid75s Database 'AGDirectSeeding01' does not exist. Make sure that the name is entered correctly.

2016-10-14 17:19:08.310 spid76s Error: 911, Severity: 16, State: 1.

2016-10-14 17:19:08.310 spid76s Database 'AGDirectSeeding02' does not exist. Make sure that the name is entered correctly.

2016-10-14 17:19:09.180 spid75s Processed 320 pages for database 'AGDirectSeeding01', file 'AGDirectSeeding01' on file 1.

2016-10-14 17:19:09.180 spid75s Processed 43 pages for database 'AGDirectSeeding01', file 'AGDirectSeeding01_log' on file 1.

2016-10-14 17:19:09.340 spid75s [INFO] HkHostDbCtxt::Initialize(): Database ID: [7] 'AGDirectSeeding01'. XTP Engine version is 0.0.

2016-10-14 17:19:09.340 spid75s Starting up database 'AGDirectSeeding01'.

2016-10-14 17:19:09.350 spid75s [INFO] HkHostDbCtxt::Initialize(): Database ID: [7] 'AGDirectSeeding01'. XTP Engine version is 0.0.

2016-10-14 17:19:09.350 spid75s The database 'AGDirectSeeding01' is marked RESTORING and is in a state that does not allow recovery to be run.

2016-10-14 17:19:09.370 spid76s Processed 320 pages for database 'AGDirectSeeding02', file 'AGDirectSeeding02' on file 1.

2016-10-14 17:19:09.370 spid76s Processed 43 pages for database 'AGDirectSeeding02', file 'AGDirectSeeding02_log' on file 1.

2016-10-14 17:19:09.400 spid76s [INFO] HkHostDbCtxt::Initialize(): Database ID: [8] 'AGDirectSeeding02'. XTP Engine version is 0.0.

2016-10-14 17:19:09.400 spid76s Starting up database 'AGDirectSeeding02'.

2016-10-14 17:19:09.410 spid76s [INFO] HkHostDbCtxt::Initialize(): Database ID: [8] 'AGDirectSeeding02'. XTP Engine version is 0.0.

2016-10-14 17:19:09.420 spid76s The database 'AGDirectSeeding02' is marked RESTORING and is in a state that does not allow recovery to be run.

2016-10-14 17:19:09.480 Backup Database was restored: Database: AGDirectSeeding01, creation date(time): 2016/10/14(14:40:17), first LSN: 34:120:65, last LSN: 34:808:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{16FB7871-5515-4B52-B7EE-1FFE6CFA6F10}'}

2016-10-14 17:19:09.530 Backup Database was restored: Database: AGDirectSeeding02, creation date(time): 2016/10/14(14:40:27), first LSN: 34:120:65, last LSN: 34:800:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{DA14131A-8A75-4567-A170-FA9E3ACB4094}'}

2016-10-14 17:19:09.540 spid75s RESTORE DATABASE successfully processed 363 pages in 0.103 seconds (27.533 MB/sec).

2016-10-14 17:19:09.540 Backup RESTORE DATABASE successfully processed 363 pages in 0.103 seconds (27.533 MB/sec).

2016-10-14 17:19:09.580 spid76s RESTORE DATABASE successfully processed 363 pages in 0.062 seconds (45.677 MB/sec).

2016-10-14 17:19:09.580 Backup RESTORE DATABASE successfully processed 363 pages in 0.062 seconds (45.677 MB/sec).

2016-10-14 17:19:09.620 spid75s Always On Availability Groups connection with primary database established for secondary database 'AGDirectSeeding01' on the availability replica 'AG2016-S1\AG1' with Replica ID: {801464fb-3175-4d31-b335-df311e06f030}. This is an informational message only

2016-10-14 17:19:09.640 spid70s State information for database 'AGDirectSeeding01' - Hardened Lsn: '(34:808:1)' Commit LSN: '(0:0:0)' Commit Time: 'Jan 1 1900 12:00AM'

2016-10-14 17:19:09.640 spid56s Always On Availability Groups connection with primary database terminated for secondary database 'AGDirectSeeding01' on the availability replica 'AG2016-S1\AG1' with Replica ID: {801464fb-3175-4d31-b335-df311e06f030}. This is an informational message only.

2016-10-14 17:19:09.650 spid70s State information for database 'AGDirectSeeding01' - Hardened Lsn: '(34:808:1)' Commit LSN: '(0:0:0)' Commit Time: 'Jan 1 1900 12:00AM'

2016-10-14 17:19:09.650 spid70s [INFO] HkHostDbCtxt::Initialize(): Database ID: [7] 'AGDirectSeeding01'. XTP Engine version is 0.0.

2016-10-14 17:19:09.650 spid70s Starting up database 'AGDirectSeeding01'.

2016-10-14 17:19:09.670 spid70s [INFO] HkHostDbCtxt::Initialize(): Database ID: [7] 'AGDirectSeeding01'. XTP Engine version is 0.0.

2016-10-14 17:19:09.680 spid76s Always On Availability Groups connection with primary database established for secondary database 'AGDirectSeeding02' on the availability replica 'AG2016-S1\AG1' with Replica ID: {801464fb-3175-4d31-b335-df311e06f030}. This is an informational message only

2016-10-14 17:19:09.710 spid56s State information for database 'AGDirectSeeding02' - Hardened Lsn: '(34:800:1)' Commit LSN: '(0:0:0)' Commit Time: 'Jan 1 1900 12:00AM'

2016-10-14 17:19:09.710 spid33s Always On Availability Groups connection with primary database terminated for secondary database 'AGDirectSeeding02' on the availability replica 'AG2016-S1\AG1' with Replica ID: {801464fb-3175-4d31-b335-df311e06f030}. This is an informational message only.

2016-10-14 17:19:09.710 spid70s [INFO] HkHostDbCtxt::Initialize(): Database ID: [7] 'AGDirectSeeding01'. XTP Engine version is 0.0.

2016-10-14 17:19:09.730 spid56s State information for database 'AGDirectSeeding02' - Hardened Lsn: '(34:800:1)' Commit LSN: '(0:0:0)' Commit Time: 'Jan 1 1900 12:00AM'

2016-10-14 17:19:09.730 spid56s [INFO] HkHostDbCtxt::Initialize(): Database ID: [8] 'AGDirectSeeding02'. XTP Engine version is 0.0.

2016-10-14 17:19:09.730 spid56s Starting up database 'AGDirectSeeding02'.

2016-10-14 17:19:09.740 spid56s [INFO] HkHostDbCtxt::Initialize(): Database ID: [8] 'AGDirectSeeding02'. XTP Engine version is 0.0.

2016-10-14 17:19:09.750 spid70s Always On Availability Groups connection with primary database established for secondary database 'AGDirectSeeding01' on the availability replica 'AG2016-S1\AG1' with Replica ID: {801464fb-3175-4d31-b335-df311e06f030}. This is an informational message only

2016-10-14 17:19:09.750 spid70s The recovery LSN (34:808:1) was identified for the database with ID 7. This is an informational message only. No user action is required.

2016-10-14 17:19:09.760 spid33s Always On Availability Groups connection with primary database established for secondary database 'AGDirectSeeding01' on the availability replica 'AG2016-S1\AG1' with Replica ID: {801464fb-3175-4d31-b335-df311e06f030}. This is an informational message only

2016-10-14 17:19:09.760 spid33s The recovery LSN (34:808:1) was identified for the database with ID 7. This is an informational message only. No user action is required.

2016-10-14 17:19:09.830 spid70s Always On Availability Groups connection with primary database established for secondary database 'AGDirectSeeding01' on the availability replica 'AG2016-S1\AG1' with Replica ID: {801464fb-3175-4d31-b335-df311e06f030}. This is an informational message only

2016-10-14 17:19:09.840 spid56s [INFO] HkHostDbCtxt::Initialize(): Database ID: [8] 'AGDirectSeeding02'. XTP Engine version is 0.0.

2016-10-14 17:19:09.840 spid70s The recovery LSN (34:808:1) was identified for the database with ID 7. This is an informational message only. No user action is required.

2016-10-14 17:19:09.880 spid56s Always On Availability Groups connection with primary database established for secondary database 'AGDirectSeeding02' on the availability replica 'AG2016-S1\AG1' with Replica ID: {801464fb-3175-4d31-b335-df311e06f030}. This is an informational message only

2016-10-14 17:19:09.880 spid56s The recovery LSN (34:800:1) was identified for the database with ID 8. This is an informational message only. No user action is required.

2016-10-14 17:19:09.890 spid70s Always On Availability Groups connection with primary database established for secondary database 'AGDirectSeeding02' on the availability replica 'AG2016-S1\AG1' with Replica ID: {801464fb-3175-4d31-b335-df311e06f030}. This is an informational message only

2016-10-14 17:19:09.890 spid70s The recovery LSN (34:800:1) was identified for the database with ID 8. This is an informational message only. No user action is required.

2016-10-14 17:19:09.930 spid70s Always On Availability Groups connection with primary database established for secondary database 'AGDirectSeeding02' on the availability replica 'AG2016-S1\AG1' with Replica ID: {801464fb-3175-4d31-b335-df311e06f030}. This is an informational message only

2016-10-14 17:19:09.930 spid70s The recovery LSN (34:800:1) was identified for the database with ID 8. This is an informational message only. No user action is required.

'SQL AlwaysON AG' 카테고리의 다른 글

SQL Server 2016 가용성 그룹 만들기 (0)	2016.10.14
SQL Server 2016 가용성 그룹 만들기 T-SQL 편 (0)	2016.10.14
SQL 가용성그룹 복제본 노드 추가 시 제약조건 (0)	2016.06.13
SQL 가용성그룹의 데이터베이스에 대한 TDE 활성화 (0)	2016.02.16
SQL TDE 활성화된 DB를 가용성그룹에 추가하는 방법 (0)	2016.02.16

공유하기 링크

페이스북
카카오스토리
트위터

최근에 올라온 글

최근에 달린 댓글

글 보관함

Total

Today

Yesterday

AWSin

티스토리 뷰

SQL Server 2016 가용성 그룹 만들기 Direct-Seeding 편

'SQL AlwaysON AG' 카테고리의 다른 글

티스토리툴바