Skip to main content
Rollback to Revision 9
Source Link

I have a Server level Audit running and informational messages are continuously placed in the SQL Error log (every hour):

02/06/2020 22:05:43,spid96,Unknown,Audit: Server Audit: 66026 Session has been closed 02/06/2020 22:05:43,spid96,Unknown,Audit: Server Audit: 66026 State changed from: STARTED to: SHUTTING_DOWN 02/06/2020 21:17:55,spid72,Unknown65976,Audit: Server Audit: 66026 Initialized and Assigned State: STARTED 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 6602665976, Initialized and Assigned State: START_FAILED 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 6602565975 Session has been closed 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 6602565975, State changed from: STARTED to: SHUTTING_DOWN My

My question is, why does this happen and more important can this be prevented (while continuing the audit)?

I have a Server level Audit running and informational messages are continuously placed in the SQL Error log (every hour):

02/06/2020 22:05:43,spid96,Unknown,Audit: Server Audit: 66026 Session has been closed 02/06/2020 22:05:43,spid96,Unknown,Audit: Server Audit: 66026 State changed from: STARTED to: SHUTTING_DOWN 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 66026 Initialized and Assigned State: STARTED 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 66026 Initialized and Assigned State: START_FAILED 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 66025 Session has been closed 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 66025 State changed from: STARTED to: SHUTTING_DOWN My question is, why does this happen and more important can this be prevented (while continuing the audit)?

I have a Server level Audit running and informational messages are continuously placed in the SQL Error log (every hour):

Audit: Server Audit: 65976, Initialized and Assigned State: STARTED Audit: Server Audit: 65976, Initialized and Assigned State: START_FAILED Audit: Server Audit: 65975 Session has been closed Audit: Server Audit: 65975, State changed from: STARTED to: SHUTTING_DOWN

My question is, why does this happen and more important can this be prevented (while continuing the audit)?

Rollback to Revision 8
Source Link

I have a Server level Audit running and informational messages are continuously placed in the SQL Error log (every hour):

02/06/2020 22:05:43,spid96,Unknown,Audit: Server Audit: 66026 Session has been closed 02/06/2020 22:05:43,spid96,Unknown,Audit: Server Audit: 6597666026 State changed from: STARTED to: SHUTTING_DOWN 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 66026 Initialized and Assigned State: STARTED 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 65976,66026 Initialized and Assigned State: START_FAILED 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 6597566025 Session has been closed 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 65975,66025 State changed from: STARTED to: SHUTTING_DOWN

My My question is, why does this happen and more important can this be prevented (while continuing the audit)?

I have a Server level Audit running and informational messages are continuously placed in the SQL Error log (every hour):

Audit: Server Audit: 65976, Initialized and Assigned State: STARTED Audit: Server Audit: 65976, Initialized and Assigned State: START_FAILED Audit: Server Audit: 65975 Session has been closed Audit: Server Audit: 65975, State changed from: STARTED to: SHUTTING_DOWN

My question is, why does this happen and more important can this be prevented (while continuing the audit)?

I have a Server level Audit running and informational messages are continuously placed in the SQL Error log (every hour):

02/06/2020 22:05:43,spid96,Unknown,Audit: Server Audit: 66026 Session has been closed 02/06/2020 22:05:43,spid96,Unknown,Audit: Server Audit: 66026 State changed from: STARTED to: SHUTTING_DOWN 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 66026 Initialized and Assigned State: STARTED 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 66026 Initialized and Assigned State: START_FAILED 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 66025 Session has been closed 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 66025 State changed from: STARTED to: SHUTTING_DOWN My question is, why does this happen and more important can this be prevented (while continuing the audit)?

Rollback to Revision 7
Source Link

I have a Server level Audit running and informational messages are continuously placed in the SQL Error log (every hour):

02/06/2020 22:05:43,spid96,Unknown,Audit: Server Audit: 66026 Session has been closed 02/06/2020 22:05:43,spid96,Unknown,Audit: Server Audit: 66026 State changed from: STARTED to: SHUTTING_DOWN 02/06/2020 21:17:55,spid72,Unknown65976,Audit: Server Audit: 66026 Initialized and Assigned State: STARTED 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 6602665976, Initialized and Assigned State: START_FAILED 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 6602565975 Session has been closed 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 6602565975, State changed from: STARTED to: SHUTTING_DOWN My

My question is, why does this happen and more important can this be prevented (while continuing the audit)?

I have a Server level Audit running and informational messages are continuously placed in the SQL Error log (every hour):

02/06/2020 22:05:43,spid96,Unknown,Audit: Server Audit: 66026 Session has been closed 02/06/2020 22:05:43,spid96,Unknown,Audit: Server Audit: 66026 State changed from: STARTED to: SHUTTING_DOWN 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 66026 Initialized and Assigned State: STARTED 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 66026 Initialized and Assigned State: START_FAILED 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 66025 Session has been closed 02/06/2020 21:17:55,spid72,Unknown,Audit: Server Audit: 66025 State changed from: STARTED to: SHUTTING_DOWN My question is, why does this happen and more important can this be prevented (while continuing the audit)?

I have a Server level Audit running and informational messages are continuously placed in the SQL Error log (every hour):

Audit: Server Audit: 65976, Initialized and Assigned State: STARTED Audit: Server Audit: 65976, Initialized and Assigned State: START_FAILED Audit: Server Audit: 65975 Session has been closed Audit: Server Audit: 65975, State changed from: STARTED to: SHUTTING_DOWN

My question is, why does this happen and more important can this be prevented (while continuing the audit)?

Rollback to Revision 6
Source Link
Loading
Rollback to Revision 5
Source Link
Loading
Rollback to Revision 3
Source Link
Loading
Rollback to Revision 1
Source Link
Loading
added 3 characters in body
Source Link
Loading
added 361 characters in body
Source Link
Loading
added 16 characters in body
Source Link
Randolph West
  • 3.7k
  • 13
  • 27
Loading
Source Link
Loading