API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 21st, 2020
1,773
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 66.37 KB | None | 0 0
raw download clone embed print report
  1. Date,Source,Severity,Message
  2. 04/21/2020 17:34:48,spid90,Unknown,Stale/aborted version cleanup was aborted for database id '5' due to database shutdown.
  3. 04/21/2020 17:34:48,spid90,Unknown,Error: 22003<c/> Severity: 16<c/> State: 1.
  4. 04/21/2020 17:34:45,spid121,Unknown,[FabricReplicaManager] RefreshFabricProperty could not find CFabricReplicaController for partition [D0C328AD-F880-49BE-9E9F-149444D63C2C]
  5. 04/21/2020 17:34:44,spid65s,Unknown,[ReplicaController] Dropping AG with AG ID '634112F0-35E9-4799-9141-B4B81EC0E073' and replica ID 'F2DD00F6-F237-4A56-B122-48637580373F'.
  6. 04/21/2020 17:34:44,spid65s,Unknown,[TransportSubscriber] Destroyed transport subscriber for database [c26ec868-5d64-4773-b627-dc346663bd2b]<c/> AG [634112F0-35E9-4799-9141-B4B81EC0E073].
  7. 04/21/2020 17:34:44,spid65s,Unknown,[ReplicaController] Replica controller for database [c26ec868-5d64-4773-b627-dc346663bd2b]<c/> AG ID [634112F0-35E9-4799-9141-B4B81EC0E073]<c/> replica ID [F2DD00F6-F237-4A56-B122-48637580373F] is transitioning from state [RESOLVING] to state [NONE] due to trigger [DESTROY].
  8. 04/21/2020 17:34:44,spid65s,Unknown,[ReplicaController] Creating AG with AG ID [634112F0-35E9-4799-9141-B4B81EC0E073]<c/> AG name [c26ec868-5d64-4773-b627-dc346663bd2b]<c/> and replica ID [F2DD00F6-F237-4A56-B122-48637580373F].
  9. 04/21/2020 17:34:44,spid65s,Unknown,[ReplicaController] Dropping AG with AG ID '634112F0-35E9-4799-9141-B4B81EC0E073' and replica ID '15F265D3-44D2-4745-9383-1D00B3516417'.
  10. 04/21/2020 17:34:44,Server,Unknown,[CFabricReplicaController::Init] Adding Backup Secrets with result: 0
  11. 04/21/2020 17:34:44,Server,Unknown,[CFabricReplicaController::AddOrUpdateDatabaseBackupSecrets] Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' Property '[BackupSecrets]' added to credential repository
  12. 04/21/2020 17:34:44,Server,Unknown,[CFabricReplicaController::AddOrUpdateDatabaseBackupSecrets] HostReg_GetSecretElements namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' Property '[BackupSecrets]' XPath '[/Secrets/BackupFiles]' returned hr = [0]
  13. 04/21/2020 17:34:44,Server,Unknown,[CFabricReplicaController::AddOrUpdateDatabaseBackupSecrets] HostReg_GetSecretElements namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' Property '[BackupSecrets]' XPath '[/Secrets/Version]' returned hr = [0]
  14. 04/21/2020 17:34:44,Server,Unknown,[CFabricReplicaController::AddOrUpdateDatabaseBackupSecrets] HostReg_GetSecretForService property '[BackupSecrets]' under namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' returned hr = [0]
  15. 04/21/2020 17:34:44,Server,Unknown,[CFabricReplicaController::AddOrUpdateDatabaseBackupSecrets] Before retrieving property '[BackupSecrets]' under namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  16. 04/21/2020 17:34:44,Server,Unknown,DWLSSettings Fabric property read return code [0]. Fabric call was [successful].
  17. 04/21/2020 17:34:44,Server,Unknown,Failed to retrieve Property '[DWLSSettings]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'. Error code:[-2147017783]
  18. 04/21/2020 17:34:44,Server,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: DWLSSettings with result: 80071bc9
  19. 04/21/2020 17:34:44,Server,Unknown,Querying Property Manager for Property '[DWLSSettings]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  20. 04/21/2020 17:34:44,Server,Unknown,Failed to retrieve Property '[TdsForwarderTarget]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'. Error code:[-2147017783]
  21. 04/21/2020 17:34:44,Server,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: TdsForwarderTarget with result: 80071bc9
  22. 04/21/2020 17:34:44,Server,Unknown,Querying Property Manager for Property '[TdsForwarderTarget]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  23. 04/21/2020 17:34:44,Server,Unknown,[ReplicaController] 'HekatonUpdateSloRequestId' fabric property is set to [] for database [c26ec868-5d64-4773-b627-dc346663bd2b]
  24. 04/21/2020 17:34:44,Server,Unknown,Failed to retrieve Property '[HekatonUpdateSloRequestId]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'. Error code:[-2147017783]
  25. 04/21/2020 17:34:44,Server,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: HekatonUpdateSloRequestId with result: 80071bc9
  26. 04/21/2020 17:34:44,Server,Unknown,Querying Property Manager for Property '[HekatonUpdateSloRequestId]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  27. 04/21/2020 17:34:44,Server,Unknown,[ReplicaController] 'IsVldbReadableSecondary' Fabric property is set to [false] for database [c26ec868-5d64-4773-b627-dc346663bd2b] Availability Group [00000000-0000-0000-0000-000000000000] Replica [00000000-0000-0000-0000-000000000000]
  28. 04/21/2020 17:34:44,Server,Unknown,Failed to retrieve Property '[IsVldbReadableSecondary]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'. Error code:[-2147017783]
  29. 04/21/2020 17:34:44,Server,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: IsVldbReadableSecondary with result: 80071bc9
  30. 04/21/2020 17:34:44,Server,Unknown,Querying Property Manager for Property '[IsVldbReadableSecondary]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  31. 04/21/2020 17:34:44,Server,Unknown,[ReplicaController] 'XtpEnabled' Fabric property is set to [true] for database [c26ec868-5d64-4773-b627-dc346663bd2b] Availability Group [00000000-0000-0000-0000-000000000000] Replica [00000000-0000-0000-0000-000000000000]
  32. 04/21/2020 17:34:44,Server,Unknown,Retrieved Property '[XtpEnabled]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' successfully. Size:[1]
  33. 04/21/2020 17:34:44,Server,Unknown,Querying Property Manager for Property '[XtpEnabled]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  34. 04/21/2020 17:34:44,Server,Unknown,[ReplicaController] Setting BlockUserAccess false for DB [c26ec868-5d64-4773-b627-dc346663bd2b] since the Fabric property was not found.
  35. 04/21/2020 17:34:44,Server,Unknown,Failed to retrieve Property '[BlockUserAccess]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'. Error code:[-2147017783]
  36. 04/21/2020 17:34:44,Server,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: BlockUserAccess with result: 80071bc9
  37. 04/21/2020 17:34:44,Server,Unknown,Querying Property Manager for Property '[BlockUserAccess]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  38. 04/21/2020 17:34:44,Server,Unknown,[ReplicaController] Setting BlockDirectAccess false for DB [c26ec868-5d64-4773-b627-dc346663bd2b] since the Fabric property was not found.
  39. 04/21/2020 17:34:44,Server,Unknown,Failed to retrieve Property '[BlockDirectAccess]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'. Error code:[-2147017783]
  40. 04/21/2020 17:34:44,Server,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: BlockDirectAccess with result: 80071bc9
  41. 04/21/2020 17:34:44,Server,Unknown,Querying Property Manager for Property '[BlockDirectAccess]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  42. 04/21/2020 17:34:44,Server,Unknown,Retrieved Property '[LogicalDatabaseName]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' successfully. Size:[8]
  43. 04/21/2020 17:34:44,Server,Unknown,Querying Property Manager for Property '[LogicalDatabaseName]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  44. 04/21/2020 17:34:44,Server,Unknown,[ReplicaController] Database Type for DB [c26ec868-5d64-4773-b627-dc346663bd2b] is [3].
  45. 04/21/2020 17:34:44,Server,Unknown,ParseRgDeflatedSloSettings failed in CFabricReplicaController::Init with HRESULT = 80071bc9
  46. 04/21/2020 17:34:44,Server,Unknown,No Deflation Settings DEFAULT property found or failed for this SQL instance with hr: [80071bc9]. Returning error.
  47. 04/21/2020 17:34:44,Server,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: DeflationSettings-Default with result: 80071bc9
  48. 04/21/2020 17:34:44,Server,Unknown,No Deflation Settings property found or failed for this SQL instance with hr: [80071bc9]<c/> using defaults.
  49. 04/21/2020 17:34:44,Server,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: DeflationSettings-MIGP8G5smallvmtight with result: 80071bc9
  50. 04/21/2020 17:34:44,Server,Unknown,[XDB_DATABASE_SETTINGS_PROPERTY_APPLEVEL]: value is '<Database><MaxDbMaxSizeinMB>4194304</MaxDbMaxSizeinMB><InitialDbFileSizeinMB>16</InitialDbFileSizeinMB><DbFileGrowthinMB>16</DbFileGrowthinMB><RecoveryIntervalMin>1</RecoveryIntervalMin><DbLimitForDbScopedXeBufferKB>131072</DbLimitForDbScopedXeBufferKB><MinDbMaxSizeinMB>100</MinDbMaxSizeinMB><DefaultDbMaxSizeinMB>1048576</DefaultDbMaxSizeinMB><LogSizeinMB>1048576</LogSizeinMB><CheckpointRateIO>0</CheckpointRateIO><CheckpointRateMBps>14</CheckpointRateMBps></Database>'
  51. 04/21/2020 17:34:44,Server,Unknown,[XDB_DATABASE_SETTINGS_PROPERTY]: DatabaseSettings property name for database [c26ec868-5d64-4773-b627-dc346663bd2b] is 'DatabaseSettings-MIGP8G5smallvmtight'
  52. 04/21/2020 17:34:44,Server,Unknown,Retrieved Property '[DatabaseSettings]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' successfully. Size:[72]
  53. 04/21/2020 17:34:44,Server,Unknown,Querying Property Manager for Property '[DatabaseSettings]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  54. 04/21/2020 17:34:44,Server,Unknown,SloRgPropertyBag property for database [c26ec868-5d64-4773-b627-dc346663bd2b]<nl/> <SloRgMapping><primary><name>MIGP8G5SMALLVMTIGHT_SQLG5_NP8</name><degree_of_parallelism>8</degree_of_parallelism><cpu_max>100</cpu_max><cpu_limit /><pool_workers_max>840</pool_workers_max><group_workers_max>800</group_workers_max><db_memory_max>36263117</db_memory_max><hk_memory_max>26345472</hk_memory_max><hk_user_memory_max>6586368</hk_user_memory_max><memory_grant_max>25</memory_grant_max><group_alternate_io_factor>1</group_alternate_io_factor><group_log_threshold_for_throttle>0.75</group_log_threshold_for_throttle><slo_violation_detection_threshold>15</slo_violation_detection_threshold><pool_slo_violation_detection_threshold>15</pool_slo_violation_detection_threshold><shared>false</shared><cpu_affinity>8</cpu_affinity><group_cpu_min>0</group_cpu_min><group_cpu_max>100</group_cpu_max><transaction_max_size>0</transaction_max_size><group_log_temp_db_byte_factor>0.25</group_log_temp_db_byte_factor><slo_violation_cpu_min>0</slo_vio
  55. 04/21/2020 17:34:44,Server,Unknown,SloRgPropertyBag property len for database [c26ec868-5d64-4773-b627-dc346663bd2b] is 4452<c/> property is<nl/> <SloRgMapping><primary><name>MIGP8G5SMALLVMTIGHT_SQLG5_NP8</name><degree_of_parallelism>8</degree_of_parallelism><cpu_max>100</cpu_max><cpu_limit /><pool_workers_max>840</pool_workers_max><group_workers_max>800</group_workers_max><db_memory_max>36263117</db_memory_max><hk_memory_max>26345472</hk_memory_max><hk_user_memory_max>6586368</hk_user_memory_max><memory_grant_max>25</memory_grant_max><group_alternate_io_factor>1</group_alternate_io_factor><group_log_threshold_for_throttle>0.75</group_log_threshold_for_throttle><slo_violation_detection_threshold>15</slo_violation_detection_threshold><pool_slo_violation_detection_threshold>15</pool_slo_violation_detection_threshold><shared>false</shared><cpu_affinity>8</cpu_affinity><group_cpu_min>0</group_cpu_min><group_cpu_max>100</group_cpu_max><transaction_max_size>0</transaction_max_size><group_log_temp_db_byte_factor>0.25</group_log_temp_db_byte_factor><slo_vio
  56. 04/21/2020 17:34:44,Server,Unknown,Retrieved Property '[SloPropertyBag]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' successfully. Size:[4452]
  57. 04/21/2020 17:34:44,Server,Unknown,Querying Property Manager for Property '[SloPropertyBag]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  58. 04/21/2020 17:34:44,Server,Unknown,Retrieved Property '[ServiceObjectiveName]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' successfully. Size:[38]
  59. 04/21/2020 17:34:44,Server,Unknown,Querying Property Manager for Property '[ServiceObjectiveName]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  60. 04/21/2020 17:34:44,Server,Unknown,Retrieved Property '[ServiceObjectiveId]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' successfully. Size:[72]
  61. 04/21/2020 17:34:44,Server,Unknown,Querying Property Manager for Property '[ServiceObjectiveId]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  62. 04/21/2020 17:34:44,Server,Unknown,IsInCreate Fabric property is set to [true]. Fabric call succeeded was [true].
  63. 04/21/2020 17:34:44,Server,Unknown,Retrieved Property '[IsInCreate]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' successfully. Size:[1]
  64. 04/21/2020 17:34:44,Server,Unknown,Querying Property Manager for Property '[IsInCreate]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  65. 04/21/2020 17:34:44,spid65s,Unknown,[TransportSubscriber] Destroyed transport subscriber for database [c26ec868-5d64-4773-b627-dc346663bd2b]<c/> AG [634112F0-35E9-4799-9141-B4B81EC0E073].
  66. 04/21/2020 17:34:44,spid65s,Unknown,SloInfo Cleared in CloudPartitionStats: DBId5
  67. 04/21/2020 17:34:44,spid65s,Unknown,Volume file entity not null. File ID 2 from Database ID 5.
  68. 04/21/2020 17:34:44,spid65s,Unknown,Volume file entity not null. File ID 1 from Database ID 5.
  69. 04/21/2020 17:34:44,spid65s,Unknown,TaskCloseAllDatabaseAuditSessions not enqueued. No Audits sessions to delete for Database Id: 5
  70. 04/21/2020 17:34:44,spid65s,Unknown,[TransportSubscriber] Stopping transport for database [c26ec868-5d64-4773-b627-dc346663bd2b]<c/> AG [634112F0-35E9-4799-9141-B4B81EC0E073].
  71. 04/21/2020 17:34:44,spid65s,Unknown,Windows Fabric partition 'c26ec868-5d64-4773-b627-dc346663bd2b' (partition ID 'D0C328AD-F880-49BE-9E9F-149444D63C2C') encountered error 'CHANGE_ROLE_FAILED' and is reporting 'transient' failure to Windows Fabric. Refer to the SQL Server error log for information about the errors that were encountered.. If this condition persists<c/> contact the system administrator.
  72. 04/21/2020 17:34:44,spid65s,Unknown,Error: 41621<c/> Severity: 16<c/> State: 1.
  73. 04/21/2020 17:34:44,spid65s,Unknown,Fabric replica publisher encountered an error (SQL Error Code: 41615<c/> State: 3) while publishing event 'FABRIC_REPLICA_STATE_CHANGE' to subscriber of type 'SUBSCRIBER_TYPE_FABRIC_DBR' on Fabric partition 'c26ec868-5d64-4773-b627-dc346663bd2b' (partition ID: 'D0C328AD-F880-49BE-9E9F-149444D63C2C'). Refer to the SQL error code for more details. If this condition persists<c/> contact the system administrator.
  74. 04/21/2020 17:34:44,spid65s,Unknown,Error: 41629<c/> Severity: 16<c/> State: 0.
  75. 04/21/2020 17:34:44,spid65s,Unknown,Fabric Service 'c26ec868-5d64-4773-b627-dc346663bd2b' encountered a permanent error while performing a Windows Fabric operation on 'c26ec868-5d64-4773-b627-dc346663bd2b' database (ID 5). Refer to the SQL Server error log for information about the errors that were encountered. If this condition persists<c/> contact the system administrator.
  76. 04/21/2020 17:34:44,spid65s,Unknown,[FabricDbrSubscriber::RestoreRoutine] Restore FAILED with result: 3 '[FAILED]'
  77. 04/21/2020 17:34:44,spid78,Unknown,Http code after sending the notification for action NotifyRestoreProgress: 204
  78. 04/21/2020 17:34:44,spid78,Unknown,Sending the notification action: NotifyRestoreProgress
  79. 04/21/2020 17:34:44,spid119,Unknown,Setting database option MULTI_USER to ON for database 'c26ec868-5d64-4773-b627-dc346663bd2b'.
  80. 04/21/2020 17:34:44,spid78,Unknown,Http code after sending the notification for action NotifyRestoreProgress: 204
  81. 04/21/2020 17:34:44,spid78,Unknown,Sending the notification action: NotifyRestoreProgress
  82. 04/21/2020 17:34:44,spid119,Unknown,DBCC TRACEOFF 2558<c/> server process ID (SPID) 119. This is an informational message only; no user action is required.
  83. 04/21/2020 17:34:44,spid119,Unknown,DBCC CHECKDB for database id 5 found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 0 seconds.
  84. 04/21/2020 17:34:44,spid119,Unknown,DBCC CHECKDB (c26ec868-5d64-4773-b627-dc346663bd2b) WITH all_errormsgs<c/> no_infomsgs<c/> tablock<c/> physical_only executed by DB8C1\WF-uVAECRUHJyoVNcq found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 0 seconds.
  85. 04/21/2020 17:34:44,spid119,Unknown,[VersionCleaner][DbId:5][CleanupVersionsFromDb] failed for database due to an exception 22003. This is not fatal. Cleanup will happen in the next cycle.
  86. 04/21/2020 17:34:44,spid119,Unknown,DBCC TRACEON 2558<c/> server process ID (SPID) 119. This is an informational message only; no user action is required.
  87. 04/21/2020 17:34:44,spid78,Unknown,Http code after sending the notification for action NotifyRestoreProgress: 204
  88. 04/21/2020 17:34:44,spid78,Unknown,Sending the notification action: NotifyRestoreProgress
  89. 04/21/2020 17:34:44,spid119,Unknown,Setting database option SINGLE_USER to ON for database 'c26ec868-5d64-4773-b627-dc346663bd2b'.
  90. 04/21/2020 17:34:44,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): RESTORE DATABASE finished
  91. 04/21/2020 17:34:44,Backup,Unknown,RESTORE DATABASE successfully processed 0 pages in 0.693 seconds (0.000 MB/sec).
  92. 04/21/2020 17:34:44,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Resuming any halted Fulltext crawls
  93. 04/21/2020 17:34:44,Backup,Unknown,Restore is complete on database 'c26ec868-5d64-4773-b627-dc346663bd2b'. The database is now available.
  94. 04/21/2020 17:34:44,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Database is restarted
  95. 04/21/2020 17:34:44,spid110,Unknown,RECOVERY (c26ec868-5d64-4773-b627-dc346663bd2b<c/> 5): XactRM::PrepareLocalXact<c/> Preparing particpant xact<c/> XdesId = 19160 0
  96. 04/21/2020 17:34:44,spid110,Unknown,RECOVERY (c26ec868-5d64-4773-b627-dc346663bd2b<c/> 5): XactRM::PrepareLocalXact<c/> Preparing particpant xact<c/> XdesId = 0 0
  97. 04/21/2020 17:34:44,spid110,Unknown,RECOVERY (c26ec868-5d64-4773-b627-dc346663bd2b<c/> 5): XactRM::PrepareLocalXact<c/> Preparing particpant xact<c/> XdesId = 0 0
  98. 04/21/2020 17:34:44,spid110,Unknown,RECOVERY (c26ec868-5d64-4773-b627-dc346663bd2b<c/> 5): XactRM::PrepareLocalXact<c/> Preparing master xact<c/> XdesId = 882 0
  99. 04/21/2020 17:34:44,spid110,Unknown,Synchronize Database 'c26ec868-5d64-4773-b627-dc346663bd2b' (5) with Resource Database.
  100. 04/21/2020 17:34:44,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): PostRestoreReplicationFixup is complete
  101. 04/21/2020 17:34:44,spid83,Unknown,Backup(replicatedmaster): BACKUP LOG finished
  102. 04/21/2020 17:34:44,spid83,Unknown,Backup(replicatedmaster): Scheduling incremental checkpoint as a background job
  103. 04/21/2020 17:34:44,spid83,Unknown,[INFO] [CKPT] HkHostDbCtxt::RegisterHkTruncationLsnChange(): Database ID: [32763]. Updated HkTruncationLsn in truncation manager. HkRecoveryLSN: {'00000000:00000000:0000'}. HkLogTruncationLSN: {'00000000:00000000:0000'}. HkSyncRecoveryLSN: {'00000000:00000000:0000'}. HkTrimLSN: {'00000000:00000000:0000'}. Host backup LSN: {'000000E1:00001D68:0001'}. DbState: Online.
  104. 04/21/2020 17:34:44,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): PostRestoreReplicationFixup begins
  105. 04/21/2020 17:34:44,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): PostRestoreContainerFixups is complete
  106. 04/21/2020 17:34:44,spid110,Unknown,RECOVERY (c26ec868-5d64-4773-b627-dc346663bd2b<c/> 5): XactRM::PrepareLocalXact<c/> Preparing particpant xact<c/> XdesId = 19159 0
  107. 04/21/2020 17:34:44,spid110,Unknown,RECOVERY (c26ec868-5d64-4773-b627-dc346663bd2b<c/> 5): XactRM::PrepareLocalXact<c/> Preparing master xact<c/> XdesId = 872 0
  108. 04/21/2020 17:34:44,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): PostRestoreContainerFixups begins
  109. 04/21/2020 17:34:44,spid110,Unknown,Cleaning up SEReplicated flag from rowsets.
  110. 04/21/2020 17:34:44,spid110,Unknown,Parallel redo is shutdown for database 'c26ec868-5d64-4773-b627-dc346663bd2b' with worker pool size [1].
  111. 04/21/2020 17:34:44,spid110,Unknown,Recovery completed for database c26ec868-5d64-4773-b627-dc346663bd2b (database ID 5) in 1 second(s) (analysis 21 ms<c/> redo 0 ms<c/> undo 24 ms [system undo 0 ms<c/> regular undo 0 ms].) ADR-enabled=1<c/> Is primary=1. This is an informational message only. No user action is required.
  112. 04/21/2020 17:34:44,spid110,Unknown,Db Id [5]. PVS(long) allocation cache added<c/>rowset id 72057594042974208<c/> cacheId 1099511627950<c/> cache partition number 8
  113. 04/21/2020 17:34:44,spid110,Unknown,Db Id [5]. PVS(regular) allocation cache added<c/>rowset id 72057594042908672<c/> cacheId 1099511627948<c/> cache partition number 8
  114. 04/21/2020 17:34:44,spid110,Unknown,Db Id [5]. Persistent store table<c/> rowset id 72057594042974208<c/> rowset id in recovery unit 72057594042974208<c/> write session partition number 8
  115. 04/21/2020 17:34:44,spid110,Unknown,Db Id [5]. Persistent store table<c/> rowset id 72057594042974208<c/> rowset id in recovery unit 72057594042974208<c/> write session partition number 8. Inserts will be optimized
  116. 04/21/2020 17:34:44,spid110,Unknown,Db Id [5]. Persistent store table<c/> rowset id 72057594042908672<c/> rowset id in recovery unit 72057594042908672<c/> write session partition number 8
  117. 04/21/2020 17:34:44,spid110,Unknown,Db Id [5]. Persistent store table<c/> rowset id 72057594042908672<c/> rowset id in recovery unit 72057594042908672<c/> write session partition number 8. Inserts will be optimized
  118. 04/21/2020 17:34:44,spid110,Unknown,The tail of the log for database c26ec868-5d64-4773-b627-dc346663bd2b is being rewritten to match the new sector size of 4096 bytes. 2560 bytes at offset 103936 in file https://wasdpweu1aprsmi8237.blob.core.windows.net/managedserver-c043d6f1-f913-451b-a056-57328905cdd2/data/c26ec868-5d64-4773-b627-dc346663bd2b_2.ldf will be written.
  119. 04/21/2020 17:34:44,spid110,Unknown,Recovery of database 'c26ec868-5d64-4773-b627-dc346663bd2b' (5) is 22% complete (approximately 1 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
  120. 04/21/2020 17:34:44,spid110,Unknown,[RecoveryUnit::SetupRedoSuspendLsnFromWinfab] Failed to read the fabric property value.
  121. 04/21/2020 17:34:44,spid110,Unknown,[CFabricReplicaManager::GetRedoSuspendLsnPropertyInternal]: No property of RedoSuspendLsn found.
  122. 04/21/2020 17:34:44,spid110,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: RedoSuspendLsn with result: 80071bc9
  123. 04/21/2020 17:34:44,spid110,Unknown,[RecoveryUnit::SetupRedoSkipLsnFromWinfab] Failed to read the fabric property value.
  124. 04/21/2020 17:34:44,spid110,Unknown,[CFabricReplicaManager::GetRedoSkipLsnPropertyInternal]: No property of RedoSkipLsn found.
  125. 04/21/2020 17:34:44,spid110,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: RedoSkipLsn with result: 80071bc9
  126. 04/21/2020 17:34:44,spid110,Unknown,[INFO] [CKPT] HkRecoveryContextImpl::CompleteAnalysisPass(): Database ID: [5]. mostRecentCkpt = 0x0000000000000000; m_MostRecentCkpt = 0x0000000000000000. m_IsAnalysisFinished = false. m_DurableRecoveryLsn = 00000000:00000000:0000. XTP will not deploy.
  127. 04/21/2020 17:34:44,spid110,Unknown,Recovery of database 'c26ec868-5d64-4773-b627-dc346663bd2b' (5) is 1% complete (approximately 2 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
  128. 04/21/2020 17:34:44,spid110,Unknown,Recovery of database 'c26ec868-5d64-4773-b627-dc346663bd2b' (5) is 0% complete (approximately 3 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
  129. 04/21/2020 17:34:44,spid110,Unknown,[INFO] [CKPT] HkHostDbCtxt::RegisterHkTruncationLsnChange(): Database ID: [5]. Updated HkTruncationLsn in truncation manager. HkRecoveryLSN: {'00000000:00000000:0000'}. HkLogTruncationLSN: {'00000000:00000000:0000'}. HkSyncRecoveryLSN: {'00000000:00000000:0000'}. HkTrimLSN: {'00000000:00000000:0000'}. Host backup LSN: {'00000025:000000BB:0001'}. DbState: Online.
  130. 04/21/2020 17:34:44,spid110,Unknown,Parallel redo is started for database 'c26ec868-5d64-4773-b627-dc346663bd2b' with worker pool size [1].
  131. 04/21/2020 17:34:44,spid83,Unknown,Backup(replicatedmaster): Writing the end of backup set
  132. 04/21/2020 17:34:44,spid83,Unknown,Backup(replicatedmaster): Writing the trailing metadata
  133. 04/21/2020 17:34:44,spid83,Unknown,Backup(replicatedmaster): Copying transaction log is complete
  134. 04/21/2020 17:34:44,spid83,Unknown,Backup(replicatedmaster): 100 percent (28672/28672 bytes) processed
  135. 04/21/2020 17:34:43,spid83,Unknown,Backup(replicatedmaster): Copying transaction log
  136. 04/21/2020 17:34:43,spid83,Unknown,Backup(replicatedmaster): Writing the leading metadata
  137. 04/21/2020 17:34:43,spid83,Unknown,Backup(replicatedmaster): Last LSN: 225:7528:1
  138. 04/21/2020 17:34:43,spid83,Unknown,Backup(replicatedmaster): Work estimation is complete
  139. 04/21/2020 17:34:43,spid83,Unknown,Backup(replicatedmaster): Estimated total size = 28672 bytes (data size = 0 bytes<c/> log size = 28672 bytes)
  140. 04/21/2020 17:34:43,spid83,Unknown,Backup(replicatedmaster): First LSN: 225:7472:1
  141. 04/21/2020 17:34:43,spid110,Unknown,Version of database c26ec868-5d64-4773-b627-dc346663bd2b at startup is 904.
  142. 04/21/2020 17:34:43,spid110,Unknown,Copying dbt_inactiveDurationMin 0<c/> dbt_deactivationCount 0<c/> dbt_lastDeactivationDate 1900-01-01 00:00:00.000<c/> dbt_deactivationIntervalMin 0<c/> dbt_needToAdjustInterval 0 from bootpage.
  143. 04/21/2020 17:34:43,spid83,Unknown,Backup(replicatedmaster): Start LSN: 225:7424:3<c/> SERepl LSN: 0:0:0
  144. 04/21/2020 17:34:43,spid83,Unknown,Backup(replicatedmaster): Effective options: Checksum=1<c/> Compression=1<c/> Encryption=0<c/> BufferCount=64<c/> MaxTransferSize=4096 KB
  145. 04/21/2020 17:34:43,spid83,Unknown,Backup(replicatedmaster): The media set is ready for backup
  146. 04/21/2020 17:34:43,spid110,Unknown,Starting up database 'c26ec868-5d64-4773-b627-dc346663bd2b'.
  147. 04/21/2020 17:34:43,spid110,Unknown,SloInfo Created in DBTable and Set to CloudPartitionStats
  148. 04/21/2020 17:34:43,spid110,Unknown,[5]. Feature Status: PVS: 1. CTR: 1. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 0.
  149. 04/21/2020 17:34:43,spid110,Unknown,SloInfo Cleared in CloudPartitionStats: DBId5
  150. 04/21/2020 17:34:43,spid110,Unknown,Volume file entity not null. File ID 2 from Database ID 5.
  151. 04/21/2020 17:34:43,spid110,Unknown,Volume file entity not null. File ID 1 from Database ID 5.
  152. 04/21/2020 17:34:43,spid110,Unknown,TaskCloseAllDatabaseAuditSessions not enqueued. No Audits sessions to delete for Database Id: 5
  153. 04/21/2020 17:34:43,spid83,Unknown,Backup(replicatedmaster): Preparing the media set for writing
  154. 04/21/2020 17:34:43,spid83,Unknown,Backup(replicatedmaster): The backup media set is open
  155. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Restarting database for ONLINE
  156. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Transitioning database to ONLINE
  157. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Acquired X lock on the database
  158. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Acquiring X lock on the database
  159. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): RESTORE LOG started
  160. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Acquiring U lock on the database
  161. 04/21/2020 17:34:43,spid78,Unknown,Http code after sending the notification for action NotifyRestoreProgress: 204
  162. 04/21/2020 17:34:43,spid83,Unknown,Backup(replicatedmaster): Opening the backup media set
  163. 04/21/2020 17:34:43,spid83,Unknown,Backup(replicatedmaster): Skipped SafeCheckpoint
  164. 04/21/2020 17:34:43,spid83,Unknown,Backup(replicatedmaster): Synchronizing with other operations on the database is complete
  165. 04/21/2020 17:34:43,spid83,Unknown,Backup(replicatedmaster): Acquiring bulk-op lock on the database
  166. 04/21/2020 17:34:43,spid83,Unknown,Backup(replicatedmaster): Acquiring S lock on the database
  167. 04/21/2020 17:34:43,spid83,Unknown,Backup(replicatedmaster): BACKUP LOG started
  168. 04/21/2020 17:34:43,spid78,Unknown,Sending the notification action: NotifyRestoreProgress
  169. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): RESTORE DATABASE finished
  170. 04/21/2020 17:34:43,Backup,Unknown,RESTORE DATABASE successfully processed 346 pages in 0.164 seconds (16.443 MB/sec).
  171. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): MSDB maintenance is complete
  172. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Writing history records for NoteRestore is complete (elapsed = 23 ms)
  173. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Writing history records for NoteRestore
  174. 04/21/2020 17:34:43,Backup,Unknown,Database was restored: Database: c26ec868-5d64-4773-b627-dc346663bd2b<c/> creation date(time): 2020/04/21(16:56:06)<c/> first LSN: 37:168:48<c/> last LSN: 37:187:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=URL: {'https://databaseimport.blob.core.windows.net/databaseimport/Test.bak'}). Informational message. No user action required.
  175. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Resuming any halted Fulltext crawls
  176. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Database fixup is complete
  177. 04/21/2020 17:34:43,spid110,Unknown,[INFO] [CKPT] HkHostDbCtxt::RegisterHkTruncationLsnChange(): Database ID: [5]. Updated HkTruncationLsn in truncation manager. HkRecoveryLSN: {'00000000:00000000:0000'}. HkLogTruncationLSN: {'00000000:00000000:0000'}. HkSyncRecoveryLSN: {'00000000:00000000:0000'}. HkTrimLSN: {'00000000:00000000:0000'}. Host backup LSN: {'00000000:00000000:0000'}. DbState: Restoring.
  178. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Offline roll-forward is complete
  179. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Stop LSN: 37:187:1
  180. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): First LSN: 37:168:48<c/> Last LSN: 37:187:1
  181. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Processing VLF headers is complete
  182. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Processing 4 VLF headers
  183. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Offline roll-forward begins
  184. 04/21/2020 17:34:43,spid110,Unknown,The database 'c26ec868-5d64-4773-b627-dc346663bd2b' is marked RESTORING and is in a state that does not allow recovery to be run.
  185. 04/21/2020 17:34:43,spid110,Unknown,Version of database c26ec868-5d64-4773-b627-dc346663bd2b at startup is 904.
  186. 04/21/2020 17:34:43,spid110,Unknown,Copying dbt_inactiveDurationMin 0<c/> dbt_deactivationCount 0<c/> dbt_lastDeactivationDate 1900-01-01 00:00:00.000<c/> dbt_deactivationIntervalMin 0<c/> dbt_needToAdjustInterval 0 from bootpage.
  187. 04/21/2020 17:34:43,spid110,Unknown,Starting up database 'c26ec868-5d64-4773-b627-dc346663bd2b'.
  188. 04/21/2020 17:34:43,spid110,Unknown,SloInfo Created in DBTable and Set to CloudPartitionStats
  189. 04/21/2020 17:34:43,spid110,Unknown,[5]. Feature Status: PVS: 1. CTR: 1. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 0.
  190. 04/21/2020 17:34:43,spid110,Unknown,Volume file entity not null. File ID 2 from Database ID 5.
  191. 04/21/2020 17:34:43,spid110,Unknown,Volume file entity not null. File ID 1 from Database ID 5.
  192. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Backup set is restored
  193. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Data transfer is complete
  194. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Log zeroing is complete
  195. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Waiting for log zeroing to complete
  196. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): 100 percent (2827776/2827776 bytes) processed
  197. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): FileHandleCache: Initial CacheSize: 64
  198. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Transferring data
  199. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Estimated total size to transfer = 2827776 bytes
  200. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Restoring the backup set
  201. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Containers are ready
  202. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Preparing containers
  203. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Attached database as DB_ID=5
  204. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Dropping the database
  205. 04/21/2020 17:34:43,spid110,Unknown,SloInfo Cleared in CloudPartitionStats: DBId5
  206. 04/21/2020 17:34:43,spid110,Unknown,Volume file entity not null. File ID 2 from Database ID 5.
  207. 04/21/2020 17:34:43,spid110,Unknown,Volume file entity not null. File ID 1 from Database ID 5.
  208. 04/21/2020 17:34:43,spid110,Unknown,TaskCloseAllDatabaseAuditSessions not enqueued. No Audits sessions to delete for Database Id: 5
  209. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Beginning OFFLINE restore
  210. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Planning is complete
  211. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Effective options: Checksum=0<c/> Compression=0<c/> Encryption=0<c/> BufferCount=8<c/> MaxTransferSize=3072 KB
  212. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Acquired X lock on the database
  213. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Acquiring X lock on the database
  214. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Halting Fulltext crawls
  215. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Planning begins
  216. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Processing the leading metadata
  217. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Opening the backup set
  218. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Acquiring bulk-op lock on the database
  219. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): RESTORE DATABASE started
  220. 04/21/2020 17:34:43,spid110,Unknown,Restore(c26ec868-5d64-4773-b627-dc346663bd2b): Acquiring U lock on the database
  221. 04/21/2020 17:34:43,spid78,Unknown,Http code after sending the notification for action NotifyRestoreProgress: 204
  222. 04/21/2020 17:34:43,spid78,Unknown,Sending the notification action: NotifyRestoreProgress
  223. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.syssoftobjrefs.
  224. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.syssqlguides.
  225. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.sysasymkeys.
  226. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.sysrts.
  227. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.sysremsvcbinds.
  228. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.sysclsobjs.
  229. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.sysendpts.
  230. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.sysidxstats.
  231. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.sysscalartypes.
  232. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.sysxprops.
  233. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.sysrmtlgns.
  234. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.syscerts.
  235. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.sysnsobjs.
  236. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.sysxsrvs.
  237. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.sysxlgns.
  238. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.syscolpars.
  239. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.sysextfileformats.
  240. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.sysextsources.
  241. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.sysschobjs.
  242. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.sysdbreg.
  243. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.sysowners.
  244. 04/21/2020 17:34:43,spid65s,Unknown,index restored for c26ec868-5d64-4773-b627-dc346663bd2b.syspriorities.
  245. 04/21/2020 17:34:42,spid65s,Unknown,Parallel redo is shutdown for database 'c26ec868-5d64-4773-b627-dc346663bd2b' with worker pool size [1].
  246. 04/21/2020 17:34:42,spid65s,Unknown,Recovery completed for database c26ec868-5d64-4773-b627-dc346663bd2b (database ID 5) in 1 second(s) (analysis 9 ms<c/> redo 0 ms<c/> undo 23 ms [system undo 0 ms<c/> regular undo 0 ms].) ADR-enabled=1<c/> Is primary=1. This is an informational message only. No user action is required.
  247. 04/21/2020 17:34:42,spid65s,Unknown,Db Id [5]. PVS(long) allocation cache added<c/>rowset id 72057594042974208<c/> cacheId 1099511627950<c/> cache partition number 8
  248. 04/21/2020 17:34:42,spid65s,Unknown,Db Id [5]. PVS(regular) allocation cache added<c/>rowset id 72057594042908672<c/> cacheId 1099511627948<c/> cache partition number 8
  249. 04/21/2020 17:34:42,spid65s,Unknown,Db Id [5]. Persistent store table<c/> rowset id 72057594042974208<c/> rowset id in recovery unit 72057594042974208<c/> write session partition number 8
  250. 04/21/2020 17:34:42,spid65s,Unknown,Db Id [5]. Persistent store table<c/> rowset id 72057594042974208<c/> rowset id in recovery unit 72057594042974208<c/> write session partition number 8. Inserts will be optimized
  251. 04/21/2020 17:34:42,spid65s,Unknown,Db Id [5]. Persistent store table<c/> rowset id 72057594042908672<c/> rowset id in recovery unit 72057594042908672<c/> write session partition number 8
  252. 04/21/2020 17:34:42,spid65s,Unknown,Db Id [5]. Persistent store table<c/> rowset id 72057594042908672<c/> rowset id in recovery unit 72057594042908672<c/> write session partition number 8. Inserts will be optimized
  253. 04/21/2020 17:34:42,spid65s,Unknown,FixupLogTail(progress) zeroing 2 from 0x5000 to 0x6000.
  254. 04/21/2020 17:34:42,spid65s,Unknown,Recovery of database 'c26ec868-5d64-4773-b627-dc346663bd2b' (5) is 0% complete (approximately 1 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
  255. 04/21/2020 17:34:42,spid65s,Unknown,[RecoveryUnit::SetupRedoSuspendLsnFromWinfab] Failed to read the fabric property value.
  256. 04/21/2020 17:34:42,spid65s,Unknown,[CFabricReplicaManager::GetRedoSuspendLsnPropertyInternal]: No property of RedoSuspendLsn found.
  257. 04/21/2020 17:34:42,spid65s,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: RedoSuspendLsn with result: 80071bc9
  258. 04/21/2020 17:34:42,spid65s,Unknown,[RecoveryUnit::SetupRedoSkipLsnFromWinfab] Failed to read the fabric property value.
  259. 04/21/2020 17:34:42,spid65s,Unknown,[CFabricReplicaManager::GetRedoSkipLsnPropertyInternal]: No property of RedoSkipLsn found.
  260. 04/21/2020 17:34:42,spid65s,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: RedoSkipLsn with result: 80071bc9
  261. 04/21/2020 17:34:42,spid65s,Unknown,[INFO] [CKPT] HkRecoveryContextImpl::CompleteAnalysisPass(): Database ID: [5]. mostRecentCkpt = 0x0000000000000000; m_MostRecentCkpt = 0x0000000000000000. m_IsAnalysisFinished = false. m_DurableRecoveryLsn = 00000000:00000000:0000. XTP will not deploy.
  262. 04/21/2020 17:34:42,spid65s,Unknown,Recovery of database 'c26ec868-5d64-4773-b627-dc346663bd2b' (5) is 0% complete (approximately 3 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
  263. 04/21/2020 17:34:42,spid65s,Unknown,Recovery of database 'c26ec868-5d64-4773-b627-dc346663bd2b' (5) is 0% complete (approximately 3 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
  264. 04/21/2020 17:34:42,spid65s,Unknown,[INFO] [CKPT] HkHostDbCtxt::RegisterHkTruncationLsnChange(): Database ID: [5]. Updated HkTruncationLsn in truncation manager. HkRecoveryLSN: {'00000000:00000000:0000'}. HkLogTruncationLSN: {'00000000:00000000:0000'}. HkSyncRecoveryLSN: {'00000000:00000000:0000'}. HkTrimLSN: {'00000000:00000000:0000'}. Host backup LSN: {'00000000:00000000:0000'}. DbState: Online.
  265. 04/21/2020 17:34:42,spid65s,Unknown,Parallel redo is started for database 'c26ec868-5d64-4773-b627-dc346663bd2b' with worker pool size [1].
  266. 04/21/2020 17:34:42,spid65s,Unknown,Version of database c26ec868-5d64-4773-b627-dc346663bd2b at startup is 910.
  267. 04/21/2020 17:34:42,spid65s,Unknown,Copying dbt_inactiveDurationMin 0<c/> dbt_deactivationCount 0<c/> dbt_lastDeactivationDate 1900-01-01 00:00:00.000<c/> dbt_deactivationIntervalMin 0<c/> dbt_needToAdjustInterval 0 from bootpage.
  268. 04/21/2020 17:34:42,spid65s,Unknown,Starting up database 'c26ec868-5d64-4773-b627-dc346663bd2b'.
  269. 04/21/2020 17:34:42,spid65s,Unknown,SloInfo Created in DBTable and Set to CloudPartitionStats
  270. 04/21/2020 17:34:42,spid65s,Unknown,[5]. Feature Status: PVS: 1. CTR: 1. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 0.
  271. 04/21/2020 17:34:42,spid65s,Unknown,Volume file entity not null. File ID 2 from Database ID 5.
  272. 04/21/2020 17:34:42,spid65s,Unknown,Volume file entity not null. File ID 1 from Database ID 5.
  273. 04/21/2020 17:34:41,spid65s,Unknown,Volume file entity not null. File ID 2 from Database ID 5.
  274. 04/21/2020 17:34:41,spid65s,Unknown,Volume file entity not null. File ID 1 from Database ID 5.
  275. 04/21/2020 17:34:41,spid65s,Unknown,[DbrSubscriber] DBR Subscriber is creating database files. Database: c26ec868-5d64-4773-b627-dc346663bd2b<c/> Partition ID: D0C328AD-F880-49BE-9E9F-149444D63C2C.
  276. 04/21/2020 17:34:41,spid65s,Unknown,Creating xtp container XTP at C:\WFRoot\DB8C.1\Fabric\work\Applications\Worker.CL_App13\work\data\c26ec868-5d64-4773-b627-dc346663bd2b.xtp.
  277. 04/21/2020 17:34:41,spid65s,Unknown,[FabricDbrSubscriber::GetHekatonFileGroupId] Property '[XtpFileGroupId]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' either doesn't exist or is not set. Returning default: 2
  278. 04/21/2020 17:34:41,spid65s,Unknown,Retrieved Property '[XtpFileGroupId]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' successfully. Size:[0]
  279. 04/21/2020 17:34:41,spid65s,Unknown,Querying Property Manager for Property '[XtpFileGroupId]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  280. 04/21/2020 17:34:41,spid65s,Unknown,[ReplicaController] 'HddData' Fabric property is set to [false] for database [c26ec868-5d64-4773-b627-dc346663bd2b] Availability Group [634112F0-35E9-4799-9141-B4B81EC0E073] Replica [15F265D3-44D2-4745-9383-1D00B3516417]
  281. 04/21/2020 17:34:41,spid65s,Unknown,Failed to retrieve Property '[HddData]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'. Error code:[-2147017783]
  282. 04/21/2020 17:34:41,spid65s,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: HddData with result: 80071bc9
  283. 04/21/2020 17:34:41,spid65s,Unknown,Querying Property Manager for Property '[HddData]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  284. 04/21/2020 17:34:41,spid65s,Unknown,DBR Subscriber found data container secret.
  285. 04/21/2020 17:34:41,spid65s,Unknown,DBR Subscriber is checking data container secret.
  286. 04/21/2020 17:34:41,spid65s,Unknown,DBR Subscriber found data container secret.
  287. 04/21/2020 17:34:41,spid65s,Unknown,DBR Subscriber is checking data container secret.
  288. 04/21/2020 17:34:41,spid65s,Unknown,[ReplicaController] 'HddData' Fabric property is set to [false] for database [c26ec868-5d64-4773-b627-dc346663bd2b] Availability Group [634112F0-35E9-4799-9141-B4B81EC0E073] Replica [15F265D3-44D2-4745-9383-1D00B3516417]
  289. 04/21/2020 17:34:41,spid65s,Unknown,Failed to retrieve Property '[HddData]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'. Error code:[-2147017783]
  290. 04/21/2020 17:34:41,spid65s,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: HddData with result: 80071bc9
  291. 04/21/2020 17:34:41,spid65s,Unknown,Querying Property Manager for Property '[HddData]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  292. 04/21/2020 17:34:41,spid65s,Unknown,[DbrSubscriber] DBR Subscriber is creating datafiles across disks. Database: c26ec868-5d64-4773-b627-dc346663bd2b<c/> Partition ID: D0C328AD-F880-49BE-9E9F-149444D63C2C.
  293. 04/21/2020 17:34:41,spid65s,Unknown,AppInstanceId [dbmssql]. LeaseOrderId [SQLXDB-0000000000000001-01D617F25EA803DF-0000000200000000-01D617F26036BD0E]
  294. 04/21/2020 17:34:41,spid65s,Unknown,AppInstanceId [dbmssql]. LeaseOrderId [SQLXDB-0000000000000001-01D617F25EA803DF-0000000200000000-01D617F26036BD0E]
  295. 04/21/2020 17:34:41,spid65s,Unknown,[DbrSubscriber] Path at C:\WFRoot\DB8C.1\Fabric\work\Applications\Worker.CL_App13\work\data\c26ec868-5d64-4773-b627-dc346663bd2b.xtp doesn't exist. Skipping deleting it. Database: c26ec868-5d64-4773-b627-dc346663bd2b<c/> Partition ID: D0C328AD-F880-49BE-9E9F-149444D63C2C.
  296. 04/21/2020 17:34:41,spid65s,Unknown,[DbrSubscriber] DBR Subscriber is deleting the database files. Database: c26ec868-5d64-4773-b627-dc346663bd2b<c/> Partition ID: D0C328AD-F880-49BE-9E9F-149444D63C2C.
  297. 04/21/2020 17:34:41,spid65s,Unknown,IsInCreate Fabric property is set to [true]. Fabric call succeeded was [true].
  298. 04/21/2020 17:34:41,spid65s,Unknown,Retrieved Property '[IsInCreate]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' successfully. Size:[1]
  299. 04/21/2020 17:34:41,spid65s,Unknown,Querying Property Manager for Property '[IsInCreate]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  300. 04/21/2020 17:34:41,spid65s,Unknown,DBR Subscriber found data container secret.
  301. 04/21/2020 17:34:41,spid65s,Unknown,DBR Subscriber is checking data container secret.
  302. 04/21/2020 17:34:41,spid65s,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: StorageAccountType with result: 80071bc9
  303. 04/21/2020 17:34:41,spid65s,Unknown,Retrieved Property '[ServiceObjectiveId]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' successfully. Size:[72]
  304. 04/21/2020 17:34:41,spid65s,Unknown,Querying Property Manager for Property '[ServiceObjectiveId]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  305. 04/21/2020 17:34:41,spid65s,Unknown,DBR Subscriber found data container secret.
  306. 04/21/2020 17:34:41,spid65s,Unknown,DBR Subscriber is checking data container secret.
  307. 04/21/2020 17:34:41,spid65s,Unknown,[CFabricReplicaController::SetPerFileStorageType] Setting database 5 file 2 to have storage type 2
  308. 04/21/2020 17:34:41,spid65s,Unknown,DBR Subscriber found data container secret.
  309. 04/21/2020 17:34:41,spid65s,Unknown,DBR Subscriber is checking data container secret.
  310. 04/21/2020 17:34:41,spid65s,Unknown,[CFabricReplicaController::SetPerFileStorageType] Setting database 5 file 1 to have storage type 2
  311. 04/21/2020 17:34:41,spid65s,Unknown,Retrieved Property '[RemoteReplicas]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' successfully. Size:[724]
  312. 04/21/2020 17:34:41,spid65s,Unknown,Querying Property Manager for Property '[RemoteReplicas]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  313. 04/21/2020 17:34:41,spid65s,Unknown,[DbrSubscriber] Database does not exist on instance<c/> hence attaching database on switching role to Primary. Database: c26ec868-5d64-4773-b627-dc346663bd2b<c/> Partition ID: D0C328AD-F880-49BE-9E9F-149444D63C2C.
  314. 04/21/2020 17:34:41,spid65s,Unknown,[FabricDbrSubscriber::GetRestoreSecret] Property '[RestoreSecret]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' failed parsing or empty
  315. 04/21/2020 17:34:41,spid65s,Unknown,[ReplicaController::IsExternalBackupMigration] Replica is Secondary. RestoreRequestType = '[NativeRestore]'. Returning [False]
  316. 04/21/2020 17:34:41,spid65s,Unknown,[ReplicaController::IsExternalBackupMigration] Replica is Primary. RestoreRequestType = '[NativeRestore]'. Returning [False]
  317. 04/21/2020 17:34:41,spid65s,Unknown,[ReplicaController::IsExternalBackupMigration] Property '[RestoreConfiguration]' exists
  318. 04/21/2020 17:34:41,spid65s,Unknown,Retrieved Property '[RestoreConfiguration]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' successfully. Size:[699]
  319. 04/21/2020 17:34:41,spid65s,Unknown,Querying Property Manager for Property '[RestoreConfiguration]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  320. 04/21/2020 17:34:41,spid65s,Unknown,[FabricDbrSubscriber::PrepareForRestoreIfNeeded] Property '[RestoreConfiguration]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' exists
  321. 04/21/2020 17:34:41,spid65s,Unknown,[FabricDbrSubscriber::PrepareForRestoreIfNeeded] Querying Property Manager for Property '[RestoreConfiguration]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  322. 04/21/2020 17:34:41,spid65s,Unknown,[TransportSubscriber] Starting transport for database [c26ec868-5d64-4773-b627-dc346663bd2b]<c/> AG [634112F0-35E9-4799-9141-B4B81EC0E073].
  323. 04/21/2020 17:34:41,spid65s,Unknown,[ReplicaController] Replica controller for database [c26ec868-5d64-4773-b627-dc346663bd2b]<c/> AG ID [634112F0-35E9-4799-9141-B4B81EC0E073]<c/> replica ID [15F265D3-44D2-4745-9383-1D00B3516417] is transitioning from state [RESOLVING] to state [PRIMARY] due to trigger [BECOME_PRIMARY].
  324. 04/21/2020 17:34:41,spid65s,Unknown,[LAGController] Layered AG replica role for database 'c26ec868-5d64-4773-b627-dc346663bd2b' is :[LAG_REPLICA_ROLE_NONE]
  325. 04/21/2020 17:34:41,spid65s,Unknown,[LAGController] Get GeoDR Configuration for Uri:'fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b'. Result:[0]. Duration:[2] ms
  326. 04/21/2020 17:34:41,spid65s,Unknown,Failed to retrieve Property '[Partners]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'. Error code:[-2147017783]
  327. 04/21/2020 17:34:41,spid65s,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: Partners with result: 80071bc9
  328. 04/21/2020 17:34:41,spid65s,Unknown,Querying Property Manager for Property '[Partners]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  329. 04/21/2020 17:34:41,spid65s,Unknown,[ReplicaController] Reading from Fabric property GeoDR partner configuration for DB [c26ec868-5d64-4773-b627-dc346663bd2b]<c/> AG ID[634112F0-35E9-4799-9141-B4B81EC0E073]<c/> replica ID[15F265D3-44D2-4745-9383-1D00B3516417] in replica state [RESOLVING].
  330. 04/21/2020 17:34:41,spid65s,Unknown,[ReplicaController] Creating AG with AG ID [634112F0-35E9-4799-9141-B4B81EC0E073]<c/> AG name [c26ec868-5d64-4773-b627-dc346663bd2b]<c/> and replica ID [15F265D3-44D2-4745-9383-1D00B3516417].
  331. 04/21/2020 17:34:41,Server,Unknown,[CFabricReplicaController::Init] Adding Backup Secrets with result: 0
  332. 04/21/2020 17:34:41,Server,Unknown,[CFabricReplicaController::AddOrUpdateDatabaseBackupSecrets] Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' Property '[BackupSecrets]' added to credential repository
  333. 04/21/2020 17:34:41,Server,Unknown,[CFabricReplicaController::AddOrUpdateDatabaseBackupSecrets] HostReg_GetSecretElements namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' Property '[BackupSecrets]' XPath '[/Secrets/BackupFiles]' returned hr = [0]
  334. 04/21/2020 17:34:41,Server,Unknown,[CFabricReplicaController::AddOrUpdateDatabaseBackupSecrets] HostReg_GetSecretElements namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' Property '[BackupSecrets]' XPath '[/Secrets/Version]' returned hr = [0]
  335. 04/21/2020 17:34:41,Server,Unknown,[CFabricReplicaController::AddOrUpdateDatabaseBackupSecrets] HostReg_GetSecretForService property '[BackupSecrets]' under namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' returned hr = [0]
  336. 04/21/2020 17:34:41,Server,Unknown,[CFabricReplicaController::AddOrUpdateDatabaseBackupSecrets] Before retrieving property '[BackupSecrets]' under namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  337. 04/21/2020 17:34:41,Server,Unknown,DWLSSettings Fabric property read return code [0]. Fabric call was [successful].
  338. 04/21/2020 17:34:41,Server,Unknown,Failed to retrieve Property '[DWLSSettings]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'. Error code:[-2147017783]
  339. 04/21/2020 17:34:41,Server,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: DWLSSettings with result: 80071bc9
  340. 04/21/2020 17:34:41,Server,Unknown,Querying Property Manager for Property '[DWLSSettings]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  341. 04/21/2020 17:34:41,Server,Unknown,Failed to retrieve Property '[TdsForwarderTarget]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'. Error code:[-2147017783]
  342. 04/21/2020 17:34:41,Server,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: TdsForwarderTarget with result: 80071bc9
  343. 04/21/2020 17:34:41,Server,Unknown,Querying Property Manager for Property '[TdsForwarderTarget]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  344. 04/21/2020 17:34:41,Server,Unknown,[ReplicaController] 'HekatonUpdateSloRequestId' fabric property is set to [] for database [c26ec868-5d64-4773-b627-dc346663bd2b]
  345. 04/21/2020 17:34:41,Server,Unknown,Failed to retrieve Property '[HekatonUpdateSloRequestId]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'. Error code:[-2147017783]
  346. 04/21/2020 17:34:41,Server,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: HekatonUpdateSloRequestId with result: 80071bc9
  347. 04/21/2020 17:34:41,Server,Unknown,Querying Property Manager for Property '[HekatonUpdateSloRequestId]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  348. 04/21/2020 17:34:41,Server,Unknown,[ReplicaController] 'IsVldbReadableSecondary' Fabric property is set to [false] for database [c26ec868-5d64-4773-b627-dc346663bd2b] Availability Group [00000000-0000-0000-0000-000000000000] Replica [00000000-0000-0000-0000-000000000000]
  349. 04/21/2020 17:34:41,Server,Unknown,Failed to retrieve Property '[IsVldbReadableSecondary]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'. Error code:[-2147017783]
  350. 04/21/2020 17:34:41,Server,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: IsVldbReadableSecondary with result: 80071bc9
  351. 04/21/2020 17:34:41,Server,Unknown,Querying Property Manager for Property '[IsVldbReadableSecondary]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  352. 04/21/2020 17:34:41,Server,Unknown,[ReplicaController] 'XtpEnabled' Fabric property is set to [true] for database [c26ec868-5d64-4773-b627-dc346663bd2b] Availability Group [00000000-0000-0000-0000-000000000000] Replica [00000000-0000-0000-0000-000000000000]
  353. 04/21/2020 17:34:41,Server,Unknown,Retrieved Property '[XtpEnabled]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' successfully. Size:[1]
  354. 04/21/2020 17:34:41,Server,Unknown,Querying Property Manager for Property '[XtpEnabled]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  355. 04/21/2020 17:34:41,Server,Unknown,[ReplicaController] Setting BlockUserAccess false for DB [c26ec868-5d64-4773-b627-dc346663bd2b] since the Fabric property was not found.
  356. 04/21/2020 17:34:41,Server,Unknown,Failed to retrieve Property '[BlockUserAccess]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'. Error code:[-2147017783]
  357. 04/21/2020 17:34:41,Server,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: BlockUserAccess with result: 80071bc9
  358. 04/21/2020 17:34:41,Server,Unknown,Querying Property Manager for Property '[BlockUserAccess]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  359. 04/21/2020 17:34:41,Server,Unknown,[ReplicaController] Setting BlockDirectAccess false for DB [c26ec868-5d64-4773-b627-dc346663bd2b] since the Fabric property was not found.
  360. 04/21/2020 17:34:41,Server,Unknown,Failed to retrieve Property '[BlockDirectAccess]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'. Error code:[-2147017783]
  361. 04/21/2020 17:34:41,Server,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: BlockDirectAccess with result: 80071bc9
  362. 04/21/2020 17:34:41,Server,Unknown,Querying Property Manager for Property '[BlockDirectAccess]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  363. 04/21/2020 17:34:41,Server,Unknown,Retrieved Property '[LogicalDatabaseName]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' successfully. Size:[8]
  364. 04/21/2020 17:34:41,Server,Unknown,Querying Property Manager for Property '[LogicalDatabaseName]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  365. 04/21/2020 17:34:41,Server,Unknown,[ReplicaController] Database Type for DB [c26ec868-5d64-4773-b627-dc346663bd2b] is [3].
  366. 04/21/2020 17:34:41,Server,Unknown,ParseRgDeflatedSloSettings failed in CFabricReplicaController::Init with HRESULT = 80071bc9
  367. 04/21/2020 17:34:41,Server,Unknown,No Deflation Settings DEFAULT property found or failed for this SQL instance with hr: [80071bc9]. Returning error.
  368. 04/21/2020 17:34:41,Server,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: DeflationSettings-Default with result: 80071bc9
  369. 04/21/2020 17:34:41,Server,Unknown,No Deflation Settings property found or failed for this SQL instance with hr: [80071bc9]<c/> using defaults.
  370. 04/21/2020 17:34:41,Server,Unknown,[CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: DeflationSettings-MIGP8G5smallvmtight with result: 80071bc9
  371. 04/21/2020 17:34:41,Server,Unknown,[XDB_DATABASE_SETTINGS_PROPERTY_APPLEVEL]: value is '<Database><MaxDbMaxSizeinMB>4194304</MaxDbMaxSizeinMB><InitialDbFileSizeinMB>16</InitialDbFileSizeinMB><DbFileGrowthinMB>16</DbFileGrowthinMB><RecoveryIntervalMin>1</RecoveryIntervalMin><DbLimitForDbScopedXeBufferKB>131072</DbLimitForDbScopedXeBufferKB><MinDbMaxSizeinMB>100</MinDbMaxSizeinMB><DefaultDbMaxSizeinMB>1048576</DefaultDbMaxSizeinMB><LogSizeinMB>1048576</LogSizeinMB><CheckpointRateIO>0</CheckpointRateIO><CheckpointRateMBps>14</CheckpointRateMBps></Database>'
  372. 04/21/2020 17:34:41,Server,Unknown,[XDB_DATABASE_SETTINGS_PROPERTY]: DatabaseSettings property name for database [c26ec868-5d64-4773-b627-dc346663bd2b] is 'DatabaseSettings-MIGP8G5smallvmtight'
  373. 04/21/2020 17:34:41,Server,Unknown,Retrieved Property '[DatabaseSettings]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' successfully. Size:[72]
  374. 04/21/2020 17:34:41,Server,Unknown,Querying Property Manager for Property '[DatabaseSettings]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  375. 04/21/2020 17:34:41,Server,Unknown,SloRgPropertyBag property for database [c26ec868-5d64-4773-b627-dc346663bd2b]<nl/> <SloRgMapping><primary><name>MIGP8G5SMALLVMTIGHT_SQLG5_NP8</name><degree_of_parallelism>8</degree_of_parallelism><cpu_max>100</cpu_max><cpu_limit /><pool_workers_max>840</pool_workers_max><group_workers_max>800</group_workers_max><db_memory_max>36263117</db_memory_max><hk_memory_max>26345472</hk_memory_max><hk_user_memory_max>6586368</hk_user_memory_max><memory_grant_max>25</memory_grant_max><group_alternate_io_factor>1</group_alternate_io_factor><group_log_threshold_for_throttle>0.75</group_log_threshold_for_throttle><slo_violation_detection_threshold>15</slo_violation_detection_threshold><pool_slo_violation_detection_threshold>15</pool_slo_violation_detection_threshold><shared>false</shared><cpu_affinity>8</cpu_affinity><group_cpu_min>0</group_cpu_min><group_cpu_max>100</group_cpu_max><transaction_max_size>0</transaction_max_size><group_log_temp_db_byte_factor>0.25</group_log_temp_db_byte_factor><slo_violation_cpu_min>0</slo_vio
  376. 04/21/2020 17:34:41,Server,Unknown,SloRgPropertyBag property len for database [c26ec868-5d64-4773-b627-dc346663bd2b] is 4452<c/> property is<nl/> <SloRgMapping><primary><name>MIGP8G5SMALLVMTIGHT_SQLG5_NP8</name><degree_of_parallelism>8</degree_of_parallelism><cpu_max>100</cpu_max><cpu_limit /><pool_workers_max>840</pool_workers_max><group_workers_max>800</group_workers_max><db_memory_max>36263117</db_memory_max><hk_memory_max>26345472</hk_memory_max><hk_user_memory_max>6586368</hk_user_memory_max><memory_grant_max>25</memory_grant_max><group_alternate_io_factor>1</group_alternate_io_factor><group_log_threshold_for_throttle>0.75</group_log_threshold_for_throttle><slo_violation_detection_threshold>15</slo_violation_detection_threshold><pool_slo_violation_detection_threshold>15</pool_slo_violation_detection_threshold><shared>false</shared><cpu_affinity>8</cpu_affinity><group_cpu_min>0</group_cpu_min><group_cpu_max>100</group_cpu_max><transaction_max_size>0</transaction_max_size><group_log_temp_db_byte_factor>0.25</group_log_temp_db_byte_factor><slo_vio
  377. 04/21/2020 17:34:41,Server,Unknown,Retrieved Property '[SloPropertyBag]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' successfully. Size:[4452]
  378. 04/21/2020 17:34:41,Server,Unknown,Querying Property Manager for Property '[SloPropertyBag]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  379. 04/21/2020 17:34:41,Server,Unknown,Retrieved Property '[ServiceObjectiveName]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' successfully. Size:[38]
  380. 04/21/2020 17:34:41,Server,Unknown,Querying Property Manager for Property '[ServiceObjectiveName]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  381. 04/21/2020 17:34:41,Server,Unknown,Retrieved Property '[ServiceObjectiveId]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' successfully. Size:[72]
  382. 04/21/2020 17:34:41,Server,Unknown,Querying Property Manager for Property '[ServiceObjectiveId]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  383. 04/21/2020 17:34:41,Server,Unknown,IsInCreate Fabric property is set to [true]. Fabric call succeeded was [true].
  384. 04/21/2020 17:34:41,Server,Unknown,Retrieved Property '[IsInCreate]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]' successfully. Size:[1]
  385. 04/21/2020 17:34:41,Server,Unknown,Querying Property Manager for Property '[IsInCreate]' under Namespace '[fabric:/Worker.CL/c3808dc2b821/SQL.ManagedUserDb/c26ec868-5d64-4773-b627-dc346663bd2b]'
  386. 04/21/2020 17:34:37,spid90,Unknown,Calls Management Service to create a managed database Test on a managed server: dbmssql. Action: CreateManagedDatabaseNativeRestoreRequestV2. Payload: { "managedServerName": "dbmssql"<c/> "managedDatabaseName": "Test"<c/> "files": [ "Test<c/>D<c/>1"<c/>"Test_log<c/>L<c/>2" ]<c/> "ownerSid": "0xAFCCC5DEF25B3247819AB38F23DE81F8"<c/> "expectedSizeBytes": "16777216" }
  387. 04/21/2020 17:34:37,spid90,Unknown,Restore(Test): Processing the leading metadata
  388. 04/21/2020 17:34:37,spid90,Unknown,Restore(Test): Opening the backup set
  389. 04/21/2020 17:34:37,spid90,Unknown,Restore(Test): RESTORE DATABASE started
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!