Posts

Showing posts from November, 2019

When the SQL Server Services Started and Stopped in Windows server

<# Events that occur after stopping services. #19032:SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required. #6527.NET Framework runtime has been stopped. 17148.NET Framework runtime has been stopped. 17148SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required. 102SQLServerAgent service successfully stopped. 15457Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install. #> clear Get-EventLog -LogName Application | Where-Object { $_ . EventID -in ( 19032 , 6527 , 17148 , 102 , 15457 )} | Format-Table -AutoSize Sort-Object Time -Descending <# 3408:Recovery is complete. This is an informational message only. No user action is required. 9688:Service Broker manager has started. 17137:Starting up database 

Backup preferences in Always on AG

Image

Accessing out side folder from VM

Image
If we want to access folder outside of VM, we can access it by using the below check box.