API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 8th, 2025
17
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.84 KB | None | 0 0
raw download clone embed print report
  1. 2025-04-08 16:27:14.495 Microsoft SQL Server Log Reader Agent 16.0.1000.6
  2. 2025-04-08 16:27:14.495 Copyright (c) 2016 Microsoft Corporation
  3. 2025-04-08 16:27:14.495
  4. 2025-04-08 16:27:14.495 The timestamps prepended to the output lines are expressed in terms of UTC time.
  5. 2025-04-08 16:27:14.495 User-specified agent parameter values:
  6. -Publisher mssqlsource
  7. -PublisherDB sourceDB
  8. -PublisherLogin sa
  9. -PublisherPassword **********
  10. -PublisherSecurityMode 0
  11. -Distributor mssqlsource
  12. -DistributorLogin sa
  13. -DistributorPassword **********
  14. -DistributorSecurityMode 0
  15. -EncryptionLevel 0
  16. 2025-04-08 16:27:14.620 Parameter values obtained from agent profile:
  17. -outputverboselevel 2
  18. -pollinginterval 5000
  19. -historyverboselevel 1
  20. -logintimeout 15
  21. -querytimeout 1800
  22. -readbatchsize 500
  23. -logscanthreshold 500000
  24. 2025-04-08 16:27:14.620 Status: 32768, code: 53044, text: 'Validating publisher'.
  25. 2025-04-08 16:27:14.636 Connecting to OLE DB mssqlsource at datasource: 'mssqlsource', location: '', catalog: 'sourceDB', providerstring: '' using provider 'MSOLEDBSQL'
  26. 2025-04-08 16:27:14.636 OLE DB mssqlsource: mssqlsource
  27. DBMS: Microsoft SQL Server
  28. Version: 16.00.1000
  29. catalog name: sourceDB
  30. user name: dbo
  31. API conformance: 0
  32. SQL conformance: 0
  33. transaction capable: 1
  34. read only: F
  35. identifier quote char: "
  36. non_nullable_columns: 0
  37. owner usage: 15
  38. max table name len: 128
  39. max column name len: 128
  40. need long data len:
  41. max columns in table: 1000
  42. max columns in index: 16
  43. max char literal len: 131072
  44. max statement len: 131072
  45. max row size: 131072
  46. 2025-04-08 16:27:14.636 OLE DB mssqlsource 'mssqlsource': select is_srvrolemember('sysadmin'), is_member ('db_owner')
  47. 2025-04-08 16:27:14.652 OLE DB mssqlsource 'mssqlsource': select db_id()
  48. 2025-04-08 16:27:14.652 Disconnecting from OLE DB mssqlsource 'mssqlsource'
  49. 2025-04-08 16:27:14.652 Connecting to OLE DB at datasource: 'mssqlsource', location: '', catalog: 'distribution', providerstring: '' using provider 'MSOLEDBSQL'
  50. 2025-04-08 16:27:14.667 OLE DB : mssqlsource
  51. DBMS: Microsoft SQL Server
  52. Version: 16.00.1000
  53. catalog name:
  54. user name: dbo
  55. API conformance: 0
  56. SQL conformance: 0
  57. transaction capable: 1
  58. read only: F
  59. identifier quote char: "
  60. non_nullable_columns: 0
  61. owner usage: 15
  62. max table name len: 128
  63. max column name len: 128
  64. need long data len:
  65. max columns in table: 1000
  66. max columns in index: 16
  67. max char literal len: 131072
  68. max statement len: 131072
  69. max row size: 131072
  70. 2025-04-08 16:27:14.667 OLE DB 'mssqlsource': {call sp_MSensure_single_instance(N'Repl-LogReader-0-sourceDB-7', 2)}
  71. 2025-04-08 16:27:14.667 Connecting to OLE DB Publisher at datasource: 'mssqlsource', location: '', catalog: 'sourceDB', providerstring: '' using provider 'MSOLEDBSQL'
  72. 2025-04-08 16:27:14.683 OLE DB Publisher: mssqlsource
  73. DBMS: Microsoft SQL Server
  74. Version: 16.00.1000
  75. catalog name: sourceDB
  76. user name: dbo
  77. API conformance: 0
  78. SQL conformance: 0
  79. transaction capable: 1
  80. read only: F
  81. identifier quote char: "
  82. non_nullable_columns: 0
  83. owner usage: 15
  84. max table name len: 128
  85. max column name len: 128
  86. need long data len:
  87. max columns in table: 1000
  88. max columns in index: 16
  89. max char literal len: 131072
  90. max statement len: 131072
  91. max row size: 131072
  92. 2025-04-08 16:27:14.683 OLE DB Publisher: mssqlsource
  93. DBMS: Microsoft SQL Server
  94. Version: 16.00.1000
  95. catalog name: sourceDB
  96. user name: dbo
  97. API conformance: 0
  98. SQL conformance: 0
  99. transaction capable: 1
  100. read only: F
  101. identifier quote char: "
  102. non_nullable_columns: 0
  103. owner usage: 15
  104. max table name len: 128
  105. max column name len: 128
  106. need long data len:
  107. max columns in table: 1000
  108. max columns in index: 16
  109. max char literal len: 131072
  110. max statement len: 131072
  111. max row size: 131072
  112. 2025-04-08 16:27:14.683 OLE DB Publisher 'mssqlsource': select @@SERVERNAME
  113. 2025-04-08 16:27:14.683 Connecting to OLE DB DISTOLE at datasource: 'mssqlsource', location: '', catalog: 'distribution', providerstring: '' using provider 'MSOLEDBSQL'
  114. 2025-04-08 16:27:14.699 OLE DB DISTOLE: mssqlsource
  115. DBMS: Microsoft SQL Server
  116. Version: 16.00.1000
  117. catalog name: distribution
  118. user name: dbo
  119. API conformance: 0
  120. SQL conformance: 0
  121. transaction capable: 1
  122. read only: F
  123. identifier quote char: "
  124. non_nullable_columns: 0
  125. owner usage: 15
  126. max table name len: 128
  127. max column name len: 128
  128. need long data len:
  129. max columns in table: 1000
  130. max columns in index: 16
  131. max char literal len: 131072
  132. max statement len: 131072
  133. max row size: 131072
  134. 2025-04-08 16:27:14.699 OLE DB DISTOLE: mssqlsource
  135. DBMS: Microsoft SQL Server
  136. Version: 16.00.1000
  137. catalog name: distribution
  138. user name: dbo
  139. API conformance: 0
  140. SQL conformance: 0
  141. transaction capable: 1
  142. read only: F
  143. identifier quote char: "
  144. non_nullable_columns: 0
  145. owner usage: 15
  146. max table name len: 128
  147. max column name len: 128
  148. need long data len:
  149. max columns in table: 1000
  150. max columns in index: 16
  151. max char literal len: 131072
  152. max statement len: 131072
  153. max row size: 131072
  154. 2025-04-08 16:27:14.699 OLE DB DISTOLE 'mssqlsource': select datasource, srvid from master..sysservers where ltrim(substring(reverse(ltrim(substring(reverse(srvname),charindex(',',reverse(srvname))+1,len(srvname)))),charindex(':',srvname)+1,len(srvname))) = N'mssqlsource' collate Latin1_General_CI_AI
  155. 2025-04-08 16:27:14.714 Status: 4096, code: 20024, text: 'Initializing'.
  156. 2025-04-08 16:27:14.714 The agent is running. Use Replication Monitor to view the details of this agent session.
  157. 2025-04-08 16:27:14.714 OLE DB DISTOLE 'mssqlsource': sp_MSget_last_transaction @publisher_id = 0, @publisher_db = N'sourceDB', @for_truncate = 0x0
  158. 2025-04-08 16:27:14.714 OLE DB DISTOLE 'mssqlsource': sp_MSquery_syncstates 0, N'sourceDB'
  159. 2025-04-08 16:27:14.714 OLE DB DISTOLE 'mssqlsource': sp_MSget_last_transaction @publisher_id = 0, @publisher_db = N'sourceDB', @for_truncate = 0x1
  160. 2025-04-08 16:27:14.714 Publisher: {call sp_repldone ( 0x00000000000000000000, 0x00000000000000000000, 0, 0)}
  161. 2025-04-08 16:27:14.745 Publisher: {call sp_replcmds (500, 0, 0, , 16, 500000)}
  162. 2025-04-08 16:27:14.761 OLE DB DISTOLE 'mssqlsource': sp_MSget_last_transaction @publisher_id = 0, @publisher_db = N'sourceDB', @for_truncate = 0x1
  163. 2025-04-08 16:27:14.761 Publisher: exec sp_replcounters N'sourceDB'
  164. 2025-04-08 16:27:14.761 OLE DB Publisher 'mssqlsource': exec sp_replcounters N'sourceDB'
  165. 2025-04-08 16:27:14.761 Status: 16384, code: 20007, text: 'No replicated transactions are available.'.
  166. 2025-04-08 16:27:14.777 Status: 1, code: 22037, text: 'No replicated transactions are available.'.
  167. 2025-04-08 16:27:14.777 No replicated transactions are available.
  168. 2025-04-08 16:27:14.777 Disconnecting from OLE DB DISTOLE 'mssqlsource'
  169. 2025-04-08 16:27:15.120 Disconnecting from OLE DB DistLog 'mssqlsource'
  170. 2025-04-08 16:27:15.120 Disconnecting from OLE DB Publisher 'mssqlsource'
  171. 2025-04-08 16:27:15.136 Disconnecting from OLE DB 'mssqlsource'
  172.  
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!