The output of running "sp_readerrorlog", the log is too large.

The last hang service on 24/06/2015, so i put log in here from  23/06/2015.

1. SQL Server 2008 instance

====================

2015-06-23 00:00:16.200    spid27s    This instance of SQL Server has been using a process ID of 5196 since 6/2/2015 3:47:20 PM (local) 6/2/2015 8:47:20 AM (UTC). This is an informational message only; no user action is required.
2015-06-23 08:21:02.010    spid61    Starting up database 'LIVE'.
2015-06-23 08:21:02.420    spid61    Starting up database 'TrainingCMM'.
2015-06-23 08:21:02.960    spid61    Starting up database 'TrainingCMM1'.
2015-06-23 09:32:14.560    spid70    Starting up database 'LIVE'.
2015-06-23 09:32:14.920    spid70    Starting up database 'TrainingCMM'.
2015-06-23 09:32:15.460    spid70    Starting up database 'TrainingCMM1'.
2015-06-23 09:32:16.690    spid70    Starting up database 'LIVE'.
2015-06-23 09:32:17.240    spid70    Starting up database 'TrainingCMM'.
2015-06-23 09:32:17.380    spid70    Starting up database 'TrainingCMM1'.
2015-06-23 09:32:19.530    spid70    Starting up database 'TrainingCMM'.
2015-06-23 09:32:20.430    spid70    Starting up database 'LIVE'.
2015-06-23 10:03:36.550    spid162    Starting up database 'LIVE'.
2015-06-23 10:03:36.610    spid162    Starting up database 'TrainingCMM'.
2015-06-23 10:03:36.690    spid162    Starting up database 'TrainingCMM1'.
2015-06-23 10:03:38.560    spid162    Starting up database 'LIVE'.
2015-06-23 10:03:38.620    spid162    Starting up database 'TrainingCMM'.
2015-06-23 10:03:38.720    spid162    Starting up database 'TrainingCMM1'.
2015-06-23 10:03:40.520    spid162    Starting up database 'LIVE'.
2015-06-23 10:03:40.840    spid162    Starting up database 'TrainingCMM'.
2015-06-23 10:03:41.030    spid162    Starting up database 'TrainingCMM1'.
2015-06-23 10:03:43.210    spid162    Starting up database 'TrainingCMM'.
2015-06-23 10:03:44.340    spid162    Starting up database 'LIVE'.
2015-06-23 10:06:13.930    spid66    Starting up database 'LIVE'.
2015-06-23 10:06:14.020    spid66    Starting up database 'TrainingCMM'.
2015-06-23 10:06:14.150    spid66    Starting up database 'TrainingCMM1'.
2015-06-23 10:06:15.900    spid66    Starting up database 'LIVE'.
2015-06-23 10:33:11.690    spid129    Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
2015-06-23 10:33:11.690    spid129    FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'CRD'.
2015-06-23 10:33:11.720    spid129    Configuration option 'xp_cmdshell' changed from 1 to 1. Run the RECONFIGURE statement to install.
2015-06-23 10:33:11.720    spid129    FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'CRD'.
2015-06-23 10:48:08.650    spid135    Starting up database 'LIVE'.
2015-06-23 10:48:09.070    spid135    Starting up database 'TrainingCMM'.
2015-06-23 10:48:09.640    spid135    Starting up database 'TrainingCMM1'.
2015-06-23 10:48:11.250    spid135    Starting up database 'LIVE'.
2015-06-23 10:48:11.760    spid135    Starting up database 'TrainingCMM'.
2015-06-23 10:48:11.900    spid135    Starting up database 'TrainingCMM1'.
2015-06-23 10:48:14.690    spid135    Starting up database 'LIVE'.
2015-06-23 10:48:15.070    spid135    Starting up database 'TrainingCMM'.
2015-06-23 10:48:15.240    spid135    Starting up database 'TrainingCMM1'.
2015-06-23 10:48:17.930    spid135    Starting up database 'TrainingCMM'.
2015-06-23 10:48:18.730    spid135    Starting up database 'LIVE'.
2015-06-23 10:48:20.860    spid135    Starting up database 'TrainingCMM1'.
2015-06-23 10:49:29.920    spid122    Starting up database 'LIVE'.
2015-06-23 10:49:30.260    spid122    Starting up database 'TrainingCMM'.
2015-06-23 10:49:30.710    spid122    Starting up database 'TrainingCMM1'.
2015-06-23 10:51:05.190    spid125    Starting up database 'LIVE'.
2015-06-23 10:51:05.590    spid125    Starting up database 'TrainingCMM'.
2015-06-23 10:51:06.650    spid125    Starting up database 'TrainingCMM1'.
2015-06-23 10:59:54.490    spid122    Starting up database 'LIVE'.
2015-06-23 10:59:54.910    spid122    Starting up database 'TrainingCMM'.
2015-06-23 10:59:56.010    spid122    Starting up database 'TrainingCMM1'.
2015-06-23 10:59:57.100    spid108    Starting up database 'LIVE'.
2015-06-23 11:05:36.060    spid53    Starting up database 'TrainingCMM'.
2015-06-23 11:05:42.650    spid53    Starting up database 'TrainingCMM'.
2015-06-23 11:06:09.720    spid105    Starting up database 'TrainingCMM'.
2015-06-23 11:06:14.440    spid118    Starting up database 'LIVE'.
2015-06-23 11:06:14.830    spid118    Starting up database 'TrainingCMM1'.
2015-06-23 11:06:16.810    spid118    Starting up database 'LIVE'.
2015-06-23 11:06:17.220    spid118    Starting up database 'TrainingCMM1'.
2015-06-23 11:06:19.180    spid118    Starting up database 'LIVE'.
2015-06-23 11:06:19.510    spid118    Starting up database 'TrainingCMM1'.
2015-06-23 11:06:22.610    spid118    Starting up database 'LIVE'.
2015-06-23 11:07:53.040    spid132    Starting up database 'LIVE'.
2015-06-23 11:07:53.400    spid132    Starting up database 'TrainingCMM1'.
2015-06-23 11:07:55.220    spid132    Starting up database 'LIVE'.
2015-06-23 11:09:55.000    spid114    Starting up database 'LIVE'.
2015-06-23 11:09:55.390    spid114    Starting up database 'TrainingCMM1'.
2015-06-23 11:11:35.710    spid57    Starting up database 'LIVE'.
2015-06-23 11:11:36.090    spid57    Starting up database 'TrainingCMM1'.
2015-06-23 11:13:47.990    spid94    Starting up database 'LIVE'.
2015-06-23 11:13:48.430    spid94    Starting up database 'TrainingCMM1'.
2015-06-23 11:18:58.750    spid79    Starting up database 'LIVE'.
2015-06-23 11:18:59.180    spid79    Starting up database 'TrainingCMM1'.
2015-06-23 11:20:32.400    spid113    Starting up database 'LIVE'.
2015-06-23 11:20:32.790    spid113    Starting up database 'TrainingCMM1'.
2015-06-23 11:31:18.710    spid66    Starting up database 'LIVE'.
2015-06-23 11:31:19.100    spid66    Starting up database 'TrainingCMM1'.
2015-06-23 11:32:21.550    spid102    Starting up database 'LIVE'.
2015-06-23 11:32:21.680    spid102    Starting up database 'TrainingCMM1'.
2015-06-23 11:33:23.800    spid124    Starting up database 'LIVE'.
2015-06-23 11:33:24.260    spid124    Starting up database 'TrainingCMM1'.
2015-06-23 11:34:39.750    spid76    Starting up database 'LIVE'.
2015-06-23 11:34:39.850    spid76    Starting up database 'TrainingCMM1'.
2015-06-23 11:36:44.170    spid94    Starting up database 'LIVE'.
2015-06-23 11:36:44.250    spid94    Starting up database 'TrainingCMM1'.
2015-06-23 11:37:47.110    spid55    Starting up database 'LIVE'.
2015-06-23 11:37:47.220    spid55    Starting up database 'TrainingCMM1'.
2015-06-23 11:39:08.120    spid126    Starting up database 'LIVE'.
2015-06-23 11:39:08.570    spid126    Starting up database 'TrainingCMM1'.
2015-06-23 11:41:55.620    spid66    Starting up database 'LIVE'.
2015-06-23 11:41:57.400    spid66    Starting up database 'TrainingCMM1'.
2015-06-23 11:44:33.670    spid118    Starting up database 'LIVE'.
2015-06-23 11:44:34.050    spid118    Starting up database 'TrainingCMM1'.
2015-06-23 11:46:53.020    spid109    Starting up database 'LIVE'.
2015-06-23 11:46:53.420    spid109    Starting up database 'TrainingCMM1'.
2015-06-23 11:48:03.330    spid118    Starting up database 'LIVE'.
2015-06-23 11:48:03.410    spid118    Starting up database 'TrainingCMM1'.
2015-06-23 11:49:24.000    spid72    Starting up database 'LIVE'.
2015-06-23 11:49:24.080    spid72    Starting up database 'TrainingCMM1'.
2015-06-23 13:12:13.680    spid119    Starting up database 'LIVE'.
2015-06-23 13:12:14.110    spid119    Starting up database 'TrainingCMM1'.
2015-06-23 13:13:38.650    spid64    Starting up database 'LIVE'.
2015-06-23 13:13:38.720    spid64    Starting up database 'TrainingCMM1'.
2015-06-23 13:14:39.540    spid75    Starting up database 'LIVE'.
2015-06-23 13:14:39.620    spid75    Starting up database 'TrainingCMM1'.
2015-06-23 13:15:54.190    spid123    Starting up database 'LIVE'.
2015-06-23 13:15:54.280    spid123    Starting up database 'TrainingCMM1'.
2015-06-23 13:17:01.150    spid136    Starting up database 'LIVE'.
2015-06-23 13:17:01.240    spid136    Starting up database 'TrainingCMM1'.
2015-06-23 13:17:36.550    spid145    Starting up database 'LIVE'.
2015-06-23 13:17:36.630    spid145    Starting up database 'TrainingCMM1'.
2015-06-23 13:17:38.500    spid145    Starting up database 'LIVE'.
2015-06-23 13:17:38.840    spid145    Starting up database 'TrainingCMM1'.
2015-06-23 13:17:41.300    spid145    Starting up database 'LIVE'.
2015-06-23 13:18:12.450    spid153    Starting up database 'LIVE'.
2015-06-23 13:18:12.850    spid153    Starting up database 'TrainingCMM1'.
2015-06-23 13:19:14.330    spid101    Starting up database 'LIVE'.
2015-06-23 13:19:14.720    spid101    Starting up database 'TrainingCMM1'.
2015-06-23 13:19:22.380    spid157    Starting up database 'LIVE'.
2015-06-23 13:19:22.440    spid157    Starting up database 'TrainingCMM1'.
2015-06-23 13:20:27.970    spid57    Starting up database 'LIVE'.
2015-06-23 13:20:28.040    spid57    Starting up database 'TrainingCMM1'.
2015-06-23 13:20:39.920    spid119    Starting up database 'LIVE'.
2015-06-23 13:20:39.950    spid119    Starting up database 'TrainingCMM1'.
2015-06-23 13:21:48.550    spid93    Starting up database 'LIVE'.
2015-06-23 13:21:48.630    spid93    Starting up database 'TrainingCMM1'.
2015-06-23 13:22:57.200    spid99    Starting up database 'LIVE'.
2015-06-23 13:22:57.280    spid99    Starting up database 'TrainingCMM1'.
2015-06-23 13:24:02.070    spid99    Starting up database 'LIVE'.
2015-06-23 13:24:02.150    spid99    Starting up database 'TrainingCMM1'.
2015-06-23 13:25:46.210    spid125    Starting up database 'LIVE'.
2015-06-23 13:25:46.580    spid125    Starting up database 'TrainingCMM1'.
2015-06-23 13:27:56.220    spid144    Starting up database 'LIVE'.
2015-06-23 13:27:56.300    spid144    Starting up database 'TrainingCMM1'.
2015-06-23 13:28:56.260    spid147    Starting up database 'LIVE'.
2015-06-23 13:28:56.400    spid147    Starting up database 'TrainingCMM1'.
2015-06-23 13:30:14.360    spid114    Starting up database 'LIVE'.
2015-06-23 13:30:14.470    spid114    Starting up database 'TrainingCMM1'.
2015-06-23 13:31:28.500    spid67    Starting up database 'LIVE'.
2015-06-23 13:31:28.600    spid67    Starting up database 'TrainingCMM1'.
2015-06-23 13:32:47.430    spid111    Starting up database 'LIVE'.
2015-06-23 13:32:47.530    spid111    Starting up database 'TrainingCMM1'.
2015-06-23 14:25:25.980    spid169    Starting up database 'LIVE'.
2015-06-23 14:25:26.370    spid169    Starting up database 'TrainingCMM1'.
2015-06-23 14:31:34.240    spid147    Starting up database 'LIVE'.
2015-06-23 14:31:34.630    spid147    Starting up database 'TrainingCMM1'.
2015-06-23 14:38:55.240    spid185    Starting up database 'LIVE'.
2015-06-23 14:38:55.610    spid185    Starting up database 'TrainingCMM1'.
2015-06-23 14:38:57.470    spid185    Starting up database 'LIVE'.
2015-06-23 14:45:50.780    spid176    Starting up database 'LIVE'.
2015-06-23 14:45:51.130    spid176    Starting up database 'TrainingCMM1'.
2015-06-23 14:47:02.440    spid195    Starting up database 'LIVE'.
2015-06-23 14:47:02.540    spid195    Starting up database 'TrainingCMM1'.
2015-06-23 14:49:06.470    spid200    Starting up database 'LIVE'.
2015-06-23 14:49:06.550    spid200    Starting up database 'TrainingCMM1'.
2015-06-23 15:08:22.390    spid122    Starting up database 'LIVE'.
2015-06-23 15:08:22.870    spid122    Starting up database 'TrainingCMM1'.
2015-06-23 15:10:40.930    spid189    Starting up database 'LIVE'.
2015-06-23 15:10:41.270    spid189    Starting up database 'TrainingCMM1'.
2015-06-23 15:47:19.910    Logon    Error: 18456, Severity: 14, State: 5.
2015-06-23 15:47:19.910    Logon    Login failed for user 'acleda'. Reason: Could not find a login matching the name provided. [CLIENT: X.X.96.241]
2015-06-23 15:48:09.050    Logon    Error: 18456, Severity: 14, State: 5.
2015-06-23 15:48:09.050    Logon    Login failed for user 'acleda'. Reason: Could not find a login matching the name provided. [CLIENT: X.X.96.241]
2015-06-23 15:48:09.750    Logon    Error: 18456, Severity: 14, State: 5.
2015-06-23 15:48:09.750    Logon    Login failed for user 'acleda'. Reason: Could not find a login matching the name provided. [CLIENT: X.X.96.241]
2015-06-23 15:48:17.070    Logon    Error: 18456, Severity: 14, State: 5.
2015-06-23 15:48:17.070    Logon    Login failed for user 'acleda'. Reason: Could not find a login matching the name provided. [CLIENT: X.X.96.241]
2015-06-23 15:48:17.480    Logon    Error: 18456, Severity: 14, State: 5.
2015-06-23 15:48:17.480    Logon    Login failed for user 'acleda'. Reason: Could not find a login matching the name provided. [CLIENT: X.X.96.241]
2015-06-23 15:49:29.750    Logon    Error: 18456, Severity: 14, State: 5.
2015-06-23 15:49:29.750    Logon    Login failed for user 'acleda'. Reason: Could not find a login matching the name provided. [CLIENT: X.X.96.241]
2015-06-23 15:49:30.140    Logon    Error: 18456, Severity: 14, State: 5.
2015-06-23 15:49:30.140    Logon    Login failed for user 'acleda'. Reason: Could not find a login matching the name provided. [CLIENT: X.X.96.241]
2015-06-23 15:50:59.690    spid170    Starting up database 'LIVE'.
2015-06-23 15:51:00.120    spid170    Starting up database 'TrainingCMM1'.
2015-06-23 15:51:01.920    spid170    Starting up database 'LIVE'.
2015-06-23 15:51:02.040    spid170    Starting up database 'TrainingCMM1'.
2015-06-23 15:51:04.030    spid170    Starting up database 'LIVE'.
2015-06-23 15:51:04.370    spid170    Starting up database 'TrainingCMM1'.
2015-06-23 15:51:07.460    spid170    Starting up database 'LIVE'.
2015-06-23 15:51:32.180    Logon    Error: 18456, Severity: 14, State: 5.
2015-06-23 15:51:32.180    Logon    Login failed for user 'acleda'. Reason: Could not find a login matching the name provided. [CLIENT: X.X.96.241]
2015-06-23 15:51:32.550    Logon    Error: 18456, Severity: 14, State: 5.
2015-06-23 15:51:32.550    Logon    Login failed for user 'acleda'. Reason: Could not find a login matching the name provided. [CLIENT: X.X.96.241]
2015-06-23 15:51:48.130    Logon    Error: 18456, Severity: 14, State: 5.
2015-06-23 15:51:48.130    Logon    Login failed for user 'acleda'. Reason: Could not find a login matching the name provided. [CLIENT: X.X.96.241]
2015-06-23 15:54:02.080    Logon    Error: 18456, Severity: 14, State: 5.
2015-06-23 15:54:02.080    Logon    Login failed for user 'acleda'. Reason: Could not find a login matching the name provided. [CLIENT: X.X.96.241]
2015-06-23 15:54:02.510    Logon    Error: 18456, Severity: 14, State: 5.
2015-06-23 15:54:02.510    Logon    Login failed for user 'acleda'. Reason: Could not find a login matching the name provided. [CLIENT: X.X.96.241]
2015-06-23 15:56:21.350    Logon    Error: 18456, Severity: 14, State: 5.
2015-06-23 15:56:21.350    Logon    Login failed for user 'acleda'. Reason: Could not find a login matching the name provided. [CLIENT: X.X.96.241]
2015-06-23 15:56:21.790    Logon    Error: 18456, Severity: 14, State: 5.
2015-06-23 15:56:21.790    Logon    Login failed for user 'acleda'. Reason: Could not find a login matching the name provided. [CLIENT: X.X.96.241]
2015-06-23 15:58:39.000    Logon    Error: 18456, Severity: 14, State: 5.
2015-06-23 15:58:39.000    Logon    Login failed for user 'acleda'. Reason: Could not find a login matching the name provided. [CLIENT: X.X.96.241]
2015-06-23 15:58:39.490    Logon    Error: 18456, Severity: 14, State: 5.
2015-06-23 15:58:39.490    Logon    Login failed for user 'acleda'. Reason: Could not find a login matching the name provided. [CLIENT: X.X.96.241]
2015-06-23 15:59:53.560    spid106    Starting up database 'LIVE'.
2015-06-23 15:59:53.930    spid106    Starting up database 'TrainingCMM1'.
2015-06-23 16:14:47.060    Backup    Database backed up. Database: CMM, creation date(time): 2015/03/19(11:23:52), pages dumped: 287778, first LSN: 2051:12017:216, last LSN: 2051:12129:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'F:\Oum Pisith\CMM-live-20150623_ALL_1_1614.bak'}). This is an informational message only. No user action is required.
2015-06-23 16:18:57.300    Backup    Database backed up. Database: TrainingCMM, creation date(time): 2015/05/23(13:37:54), pages dumped: 284576, first LSN: 2040:21204:205, last LSN: 2040:21291:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'F:\CMMDATA\MAP_CMM_4_CHECK_23062015_1.bak'}). This is an informational message only. No user action is required.
2015-06-23 16:21:37.810    spid96    Starting up database 'TrainingCMM1'.
2015-06-23 16:22:46.200    spid68    Starting up database 'TrainingCMM1'.
2015-06-23 16:22:47.410    Backup    Error: 18272, Severity: 16, State: 1.
2015-06-23 16:22:47.410    Backup    During restore restart, an I/O error occurred on checkpoint file 'C:\Program Files\Microsoft SQL Server\MSSQL10.CRD\MSSQL\Backup\RestoreCheckpointDB13.CKP' (operating system error 5(Access is denied.)). The statement is proceeding but cannot be restarted. Ensure that a valid storage location exists for the checkpoint file.
2015-06-23 16:23:08.840    spid68    Starting up database 'TrainingCMM1'.
2015-06-23 16:23:08.890    spid68    The database 'TrainingCMM1' is marked RESTORING and is in a state that does not allow recovery to be run.
2015-06-23 16:23:13.240    spid68    Starting up database 'TrainingCMM1'.
2015-06-23 16:23:15.480    Backup    Restore is complete on database 'TrainingCMM1'.  The database is now available.
2015-06-23 16:23:15.480    Backup    Database was restored: Database: TrainingCMM1, creation date(time): 2015/05/23(13:37:54), first LSN: 2040:21204:205, last LSN: 2040:21291:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'F:\CMMDATA\MAP_CMM_4_CHECK_23062015_1.bak'}). Informational message. No user action required.
2015-06-23 16:23:56.660    spid53    Starting up database 'TrainingCMM1'.
2015-06-23 16:23:59.250    Backup    Error: 18272, Severity: 16, State: 1.
2015-06-23 16:23:59.250    Backup    During restore restart, an I/O error occurred on checkpoint file 'C:\Program Files\Microsoft SQL Server\MSSQL10.CRD\MSSQL\Backup\RestoreCheckpointDB13.CKP' (operating system error 5(Access is denied.)). The statement is proceeding but cannot be restarted. Ensure that a valid storage location exists for the checkpoint file.
2015-06-23 16:24:21.180    spid53    Starting up database 'TrainingCMM1'.
2015-06-23 16:24:21.230    spid53    The database 'TrainingCMM1' is marked RESTORING and is in a state that does not allow recovery to be run.
2015-06-23 16:24:25.540    spid53    Starting up database 'TrainingCMM1'.
2015-06-23 16:24:27.100    Backup    Restore is complete on database 'TrainingCMM1'.  The database is now available.
2015-06-23 16:24:27.100    Backup    Database was restored: Database: TrainingCMM1, creation date(time): 2015/05/23(13:37:54), first LSN: 2040:21204:205, last LSN: 2040:21291:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'F:\CMMDATA\MAP_CMM_4_CHECK_23062015_1.bak'}). Informational message. No user action required.
2015-06-23 16:30:16.560    spid99    Process ID 119 was killed by hostname ITD-PISITH, host process ID 5188.
2015-06-23 16:30:21.610    spid99    Process ID 116 was killed by hostname ITD-PISITH, host process ID 5188.
2015-06-23 16:30:29.430    spid127    Starting up database 'TrainingCMM'.
2015-06-23 16:30:31.250    Backup    Error: 18272, Severity: 16, State: 1.
2015-06-23 16:30:31.250    Backup    During restore restart, an I/O error occurred on checkpoint file 'C:\Program Files\Microsoft SQL Server\MSSQL10.CRD\MSSQL\Backup\RestoreCheckpointDB14.CKP' (operating system error 5(Access is denied.)). The statement is proceeding but cannot be restarted. Ensure that a valid storage location exists for the checkpoint file.
2015-06-23 16:30:53.240    spid127    Starting up database 'TrainingCMM'.
2015-06-23 16:30:53.270    spid127    The database 'TrainingCMM' is marked RESTORING and is in a state that does not allow recovery to be run.
2015-06-23 16:30:56.830    spid127    Starting up database 'TrainingCMM'.
2015-06-23 16:30:56.940    spid127    Recovery is writing a checkpoint in database 'TrainingCMM' (14). This is an informational message only. No user action is required.
2015-06-23 16:30:59.210    Backup    Restore is complete on database 'TrainingCMM'.  The database is now available.
2015-06-23 16:30:59.210    Backup    Database was restored: Database: TrainingCMM, creation date(time): 2015/03/19(11:23:52), first LSN: 2051:12017:216, last LSN: 2051:12129:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'F:\Oum Pisith\CMM-live-20150623_ALL_1_1614.bak'}). Informational message. No user action required.
2015-06-23 18:00:43.630    Backup    Database backed up. Database: CMM, creation date(time): 2015/03/19(11:23:52), pages dumped: 287778, first LSN: 2051:13687:289, last LSN: 2051:13808:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\Backup\CMM\CMM_backup_2015_06_23_180002_7284972.bak'}). This is an informational message only. No user action is required.

2015-06-24 00:00:37.230    spid28s    This instance of SQL Server has been using a process ID of 5196 since 6/2/2015 3:47:20 PM (local) 6/2/2015 8:47:20 AM (UTC). This is an informational message only; no user action is required.
2015-06-24 07:36:24.340    spid51    Starting up database 'TrainingCMM1'.
2015-06-24 07:36:28.500    spid67    Starting up database 'TrainingCMM1'.
2015-06-24 07:36:29.720    spid68    Starting up database 'LIVE'.
2015-06-24 07:36:30.130    spid68    Starting up database 'TrainingCMM'.
2015-06-24 07:36:32.170    spid68    Starting up database 'LIVE'.
2015-06-24 07:36:32.660    spid68    Starting up database 'TrainingCMM'.
2015-06-24 07:36:34.790    spid68    Starting up database 'LIVE'.
2015-06-24 07:36:35.320    spid68    Starting up database 'TrainingCMM'.
2015-06-24 07:36:39.820    spid68    Starting up database 'LIVE'.
2015-06-24 07:36:39.900    spid68    Starting up database 'TrainingCMM'.
2015-06-24 07:43:50.490    spid81    Starting up database 'LIVE'.
2015-06-24 07:43:50.880    spid81    Starting up database 'TrainingCMM'.
2015-06-24 07:49:40.380    spid58    Starting up database 'LIVE'.
2015-06-24 07:49:40.450    spid58    Starting up database 'TrainingCMM'.
2015-06-24 07:50:57.950    spid70    Starting up database 'LIVE'.
2015-06-24 07:50:58.010    spid70    Starting up database 'TrainingCMM'.
2015-06-24 07:52:00.560    spid82    Starting up database 'LIVE'.
2015-06-24 07:52:00.670    spid82    Starting up database 'TrainingCMM'.
2015-06-24 07:53:09.920    spid86    Starting up database 'LIVE'.
2015-06-24 07:53:10.010    spid86    Starting up database 'TrainingCMM'.
2015-06-24 07:55:35.920    spid66    Starting up database 'LIVE'.
2015-06-24 07:55:35.950    spid66    Starting up database 'TrainingCMM'.
2015-06-24 07:56:58.060    spid71    Starting up database 'LIVE'.
2015-06-24 07:56:58.130    spid71    Starting up database 'TrainingCMM'.
2015-06-24 08:17:47.950    spid88    Starting up database 'LIVE'.
2015-06-24 08:17:48.030    spid88    Starting up database 'TrainingCMM'.
2015-06-24 08:27:36.420    spid124    Starting up database 'LIVE'.
2015-06-24 08:27:36.470    spid124    Starting up database 'TrainingCMM'.
2015-06-24 08:27:38.510    spid124    Starting up database 'LIVE'.
2015-06-24 08:27:38.650    spid124    Starting up database 'TrainingCMM'.
2015-06-24 08:27:40.640    spid124    Starting up database 'LIVE'.
2015-06-24 08:27:41.300    spid124    Starting up database 'TrainingCMM'.
2015-06-24 08:27:44.040    spid124    Starting up database 'TrainingCMM'.
2015-06-24 08:27:44.770    spid124    Starting up database 'LIVE'.
2015-06-24 08:32:00.150    spid141    Starting up database 'LIVE'.
2015-06-24 08:32:00.240    spid141    Starting up database 'TrainingCMM'.
2015-06-24 08:32:02.510    spid141    Starting up database 'LIVE'.
2015-06-24 08:32:02.590    spid141    Starting up database 'TrainingCMM'.
2015-06-24 08:32:04.630    spid141    Starting up database 'LIVE'.
2015-06-24 08:32:04.880    spid141    Starting up database 'TrainingCMM'.
2015-06-24 08:32:07.020    spid141    Starting up database 'TrainingCMM'.
2015-06-24 08:32:08.030    spid141    Starting up database 'LIVE'.
2015-06-24 08:33:10.200    spid137    Starting up database 'LIVE'.
2015-06-24 08:33:10.280    spid137    Starting up database 'TrainingCMM'.
2015-06-24 08:34:31.000    spid79    Starting up database 'LIVE'.
2015-06-24 08:34:31.070    spid79    Starting up database 'TrainingCMM'.
2015-06-24 08:35:55.980    spid79    Starting up database 'LIVE'.
2015-06-24 08:35:56.010    spid79    Starting up database 'TrainingCMM'.
2015-06-24 08:38:49.730    Backup    Database backed up. Database: CHECK, creation date(time): 2015/05/02(15:30:52), pages dumped: 3493, first LSN: 451:8079:249, last LSN: 451:8181:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'F:\Oum Pisith\CHECK_20150624.bak'}). This is an informational message only. No user action is required.
2015-06-24 08:43:01.200    spid146    Starting up database 'LIVE'.
2015-06-24 08:43:01.570    spid146    Starting up database 'TrainingCMM'.
2015-06-24 09:00:11.630    spid99    Starting up database 'LIVE'.
2015-06-24 09:00:11.750    spid99    Starting up database 'TrainingCMM'.
2015-06-24 09:01:19.560    spid146    Starting up database 'LIVE'.
2015-06-24 09:01:19.640    spid146    Starting up database 'TrainingCMM'.
2015-06-24 09:02:48.900    spid157    Starting up database 'LIVE'.
2015-06-24 09:02:48.930    spid157    Starting up database 'TrainingCMM'.
2015-06-24 09:03:59.780    spid83    Starting up database 'LIVE'.
2015-06-24 09:03:59.870    spid83    Starting up database 'TrainingCMM'.
2015-06-24 09:05:14.910    spid89    Starting up database 'LIVE'.
2015-06-24 09:05:15.010    spid89    Starting up database 'TrainingCMM'.
2015-06-24 09:07:43.110    spid129    Starting up database 'LIVE'.
2015-06-24 09:07:43.210    spid129    Starting up database 'TrainingCMM'.
2015-06-24 09:08:45.270    spid126    Starting up database 'LIVE'.
2015-06-24 09:08:45.350    spid126    Starting up database 'TrainingCMM'.
2015-06-24 09:11:25.020    spid63    Starting up database 'LIVE'.
2015-06-24 09:11:25.080    spid63    Starting up database 'TrainingCMM'.
2015-06-24 09:12:47.170    spid152    Starting up database 'LIVE'.
2015-06-24 09:12:47.270    spid152    Starting up database 'TrainingCMM'.
2015-06-24 09:13:51.260    spid159    Starting up database 'LIVE'.
2015-06-24 09:13:51.350    spid159    Starting up database 'TrainingCMM'.
2015-06-24 09:15:40.750    spid162    Starting up database 'LIVE'.
2015-06-24 09:15:40.840    spid162    Starting up database 'TrainingCMM'.
2015-06-24 09:17:42.570    spid150    Starting up database 'LIVE'.
2015-06-24 09:17:42.650    spid150    Starting up database 'TrainingCMM'.
2015-06-24 09:18:42.750    spid170    Starting up database 'LIVE'.
2015-06-24 09:18:42.820    spid170    Starting up database 'TrainingCMM'.
2015-06-24 09:19:50.400    spid177    Starting up database 'LIVE'.
2015-06-24 09:19:50.480    spid177    Starting up database 'TrainingCMM'.
2015-06-24 09:21:57.480    spid65    Starting up database 'LIVE'.
2015-06-24 09:21:57.590    spid65    Starting up database 'TrainingCMM'.
2015-06-24 09:22:57.680    spid135    Starting up database 'LIVE'.
2015-06-24 09:22:57.750    spid135    Starting up database 'TrainingCMM'.
2015-06-24 09:25:41.990    spid182    Starting up database 'LIVE'.
2015-06-24 09:25:42.100    spid182    Starting up database 'TrainingCMM'.
2015-06-24 09:27:15.750    spid96    Starting up database 'LIVE'.
2015-06-24 09:27:15.880    spid96    Starting up database 'TrainingCMM'.
2015-06-24 09:28:42.160    spid106    Starting up database 'LIVE'.
2015-06-24 09:28:42.190    spid106    Starting up database 'TrainingCMM'.
2015-06-24 09:43:30.580    spid182    Starting up database 'LIVE'.
2015-06-24 09:43:30.660    spid182    Starting up database 'TrainingCMM'.
2015-06-24 09:44:31.050    spid129    Starting up database 'LIVE'.
2015-06-24 09:44:31.160    spid129    Starting up database 'TrainingCMM'.
2015-06-24 09:45:32.950    spid146    Starting up database 'LIVE'.
2015-06-24 09:45:33.040    spid146    Starting up database 'TrainingCMM'.
2015-06-24 09:47:20.200    spid201    Starting up database 'LIVE'.
2015-06-24 09:47:20.320    spid201    Starting up database 'TrainingCMM'.
2015-06-24 09:49:19.420    spid154    Starting up database 'LIVE'.
2015-06-24 09:49:19.500    spid154    Starting up database 'TrainingCMM'.
2015-06-24 09:50:55.620    spid152    Starting up database 'LIVE'.
2015-06-24 09:50:55.710    spid152    Starting up database 'TrainingCMM'.
2015-06-24 09:58:36.860    spid145    Starting up database 'LIVE'.
2015-06-24 09:58:36.940    spid145    Starting up database 'TrainingCMM'.
2015-06-24 09:59:49.280    spid178    Starting up database 'LIVE'.
2015-06-24 09:59:49.340    spid178    Starting up database 'TrainingCMM'.
2015-06-24 10:00:53.230    spid153    Starting up database 'LIVE'.
2015-06-24 10:00:53.310    spid153    Starting up database 'TrainingCMM'.
2015-06-24 10:02:00.770    spid56    Starting up database 'LIVE'.
2015-06-24 10:02:00.870    spid56    Starting up database 'TrainingCMM'.
2015-06-24 10:04:43.270    spid110    Starting up database 'LIVE'.
2015-06-24 10:04:43.310    spid110    Starting up database 'TrainingCMM'.
2015-06-24 10:05:41.510    spid171    Starting up database 'LIVE'.
2015-06-24 10:05:41.710    spid171    Starting up database 'TrainingCMM'.
2015-06-24 10:05:44.620    spid171    Starting up database 'LIVE'.
2015-06-24 10:05:45.010    spid171    Starting up database 'TrainingCMM'.
2015-06-24 10:05:47.500    spid171    Starting up database 'TrainingCMM'.
2015-06-24 10:05:48.220    spid171    Starting up database 'LIVE'.
2015-06-24 10:09:22.140    spid56    Starting up database 'LIVE'.
2015-06-24 10:09:22.280    spid56    Starting up database 'TrainingCMM'.
2015-06-24 10:11:36.840    spid83    Starting up database 'LIVE'.
2015-06-24 10:11:37.200    spid83    Starting up database 'TrainingCMM'.
2015-06-24 10:12:43.050    spid122    Starting up database 'LIVE'.
2015-06-24 10:12:43.090    spid122    Starting up database 'TrainingCMM'.
2015-06-24 10:14:43.500    spid131    Starting up database 'LIVE'.
2015-06-24 10:14:43.620    spid131    Starting up database 'TrainingCMM'.
2015-06-24 10:15:50.590    spid171    Starting up database 'LIVE'.
2015-06-24 10:15:50.660    spid171    Starting up database 'TrainingCMM'.
2015-06-24 10:17:57.360    spid119    Starting up database 'LIVE'.
2015-06-24 10:17:57.410    spid119    Starting up database 'TrainingCMM'.
2015-06-24 10:19:34.390    spid97    Starting up database 'LIVE'.
2015-06-24 10:19:34.470    spid97    Starting up database 'TrainingCMM'.
2015-06-24 10:22:24.350    spid180    Starting up database 'LIVE'.
2015-06-24 10:22:24.430    spid180    Starting up database 'TrainingCMM'.
2015-06-24 10:34:53.650    spid173    Starting up database 'LIVE'.
2015-06-24 10:34:53.710    spid173    Starting up database 'TrainingCMM'.
2015-06-24 10:34:55.970    spid173    Starting up database 'LIVE'.
2015-06-24 10:34:56.290    spid173    Starting up database 'TrainingCMM'.
2015-06-24 10:34:58.720    spid173    Starting up database 'TrainingCMM'.
2015-06-24 10:34:59.700    spid173    Starting up database 'LIVE'.
2015-06-24 10:35:01.970    spid173    Starting up database 'LIVE'.
2015-06-24 10:35:02.900    spid173    Starting up database 'TrainingCMM'.
2015-06-24 10:35:05.420    spid173    Starting up database 'TrainingCMM'.
2015-06-24 10:36:23.970    spid84    Starting up database 'LIVE'.
2015-06-24 10:36:24.070    spid84    Starting up database 'TrainingCMM'.
2015-06-24 10:42:07.740    spid137    Starting up database 'LIVE'.
2015-06-24 10:42:07.800    spid137    Starting up database 'TrainingCMM'.
2015-06-24 10:43:19.740    spid83    Starting up database 'LIVE'.
2015-06-24 10:43:19.900    spid83    Starting up database 'TrainingCMM'.
2015-06-24 10:45:27.790    spid144    Starting up database 'LIVE'.
2015-06-24 10:45:27.870    spid144    Starting up database 'TrainingCMM'.
2015-06-24 10:46:39.630    spid151    Starting up database 'LIVE'.
2015-06-24 10:46:39.740    spid151    Starting up database 'TrainingCMM'.
2015-06-24 10:47:57.660    spid154    Starting up database 'LIVE'.
2015-06-24 10:47:57.690    spid154    Starting up database 'TrainingCMM'.
2015-06-24 10:50:19.590    spid131    Starting up database 'LIVE'.
2015-06-24 10:50:19.660    spid131    Starting up database 'TrainingCMM'.
2015-06-24 10:51:22.350    spid71    Starting up database 'LIVE'.
2015-06-24 10:51:22.410    spid71    Starting up database 'TrainingCMM'.
2015-06-24 10:53:19.150    spid105    Starting up database 'LIVE'.
2015-06-24 10:53:19.230    spid105    Starting up database 'TrainingCMM'.
2015-06-24 10:54:19.910    spid115    Starting up database 'LIVE'.
2015-06-24 10:54:19.980    spid115    Starting up database 'TrainingCMM'.
2015-06-24 10:55:52.400    spid92    Starting up database 'LIVE'.
2015-06-24 10:55:52.450    spid92    Starting up database 'TrainingCMM'.
2015-06-24 10:58:57.320    spid143    Autogrow of file 'tempdev' in database 'tempdb' was cancelled by user or timed out after 4322 milliseconds.  Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.
2015-06-24 11:00:05.900    spid128    Starting up database 'LIVE'.
2015-06-24 11:00:06.010    spid128    Starting up database 'TrainingCMM'.
2015-06-24 11:02:47.760    spid83    Starting up database 'LIVE'.
2015-06-24 11:02:47.870    spid83    Starting up database 'TrainingCMM'.
2015-06-24 11:03:23.170    spid126    Starting up database 'LIVE'.
2015-06-24 11:03:23.260    spid126    Starting up database 'TrainingCMM'.
2015-06-24 11:03:26.410    spid126    Starting up database 'LIVE'.
2015-06-24 11:05:11.010    spid150    Starting up database 'LIVE'.
2015-06-24 11:05:11.110    spid150    Starting up database 'TrainingCMM'.
2015-06-24 11:05:26.160    spid150    Starting up database 'LIVE'.
2015-06-24 11:05:26.240    spid150    Starting up database 'TrainingCMM'.
2015-06-24 11:05:29.010    spid150    Starting up database 'LIVE'.
2015-06-24 11:05:29.110    spid150    Starting up database 'TrainingCMM'.
2015-06-24 11:06:55.420    spid131    Starting up database 'LIVE'.
2015-06-24 11:06:55.450    spid131    Starting up database 'TrainingCMM'.
2015-06-24 11:09:08.680    spid105    Starting up database 'LIVE'.
2015-06-24 11:09:08.760    spid105    Starting up database 'TrainingCMM'.
2015-06-24 11:10:28.300    spid85    Starting up database 'LIVE'.
2015-06-24 11:10:28.410    spid85    Starting up database 'TrainingCMM'.
2015-06-24 11:11:31.260    spid76    Starting up database 'LIVE'.
2015-06-24 11:11:31.310    spid76    Starting up database 'TrainingCMM'.
2015-06-24 11:12:32.610    spid78    Starting up database 'LIVE'.
2015-06-24 11:12:32.650    spid78    Starting up database 'TrainingCMM'.
2015-06-24 11:13:17.670    spid64    Starting up database 'LIVE'.
2015-06-24 11:13:17.700    spid64    Starting up database 'TrainingCMM'.
2015-06-24 11:15:33.440    spid118    Starting up database 'LIVE'.
2015-06-24 11:15:33.520    spid118    Starting up database 'TrainingCMM'.
2015-06-24 11:16:44.360    spid77    Starting up database 'LIVE'.
2015-06-24 11:16:44.440    spid77    Starting up database 'TrainingCMM'.
2015-06-24 11:18:33.510    spid115    Starting up database 'LIVE'.
2015-06-24 11:18:33.610    spid115    Starting up database 'TrainingCMM'.
2015-06-24 11:19:36.920    spid133    Starting up database 'LIVE'.
2015-06-24 11:19:36.950    spid133    Starting up database 'TrainingCMM'.
2015-06-24 11:21:55.220    spid105    Starting up database 'LIVE'.
2015-06-24 11:21:55.250    spid105    Starting up database 'TrainingCMM'.
2015-06-24 11:23:44.750    spid133    Starting up database 'LIVE'.
2015-06-24 11:23:44.860    spid133    Starting up database 'TrainingCMM'.
2015-06-24 11:24:46.520    spid121    Starting up database 'LIVE'.
2015-06-24 11:24:46.620    spid121    Starting up database 'TrainingCMM'.
2015-06-24 11:26:28.550    spid110    Starting up database 'LIVE'.
2015-06-24 11:26:28.640    spid110    Starting up database 'TrainingCMM'.
2015-06-24 11:27:18.300    spid78    Starting up database 'LIVE'.
2015-06-24 11:27:18.380    spid78    Starting up database 'TrainingCMM'.
2015-06-24 11:27:49.010    spid78    Starting up database 'LIVE'.
2015-06-24 11:27:49.100    spid78    Starting up database 'TrainingCMM'.
2015-06-24 11:30:23.490    spid72    Starting up database 'LIVE'.
2015-06-24 11:30:23.570    spid72    Starting up database 'TrainingCMM'.
2015-06-24 11:31:28.260    Backup    Error: 18272, Severity: 16, State: 1.
2015-06-24 11:31:28.260    Backup    During restore restart, an I/O error occurred on checkpoint file 'C:\Program Files\Microsoft SQL Server\MSSQL10.CRD\MSSQL\Backup\RestoreCheckpointDB11.CKP' (operating system error 5(Access is denied.)). The statement is proceeding but cannot be restarted. Ensure that a valid storage location exists for the checkpoint file.
2015-06-24 11:31:32.060    spid87    Starting up database 'TrainingCHECK'.
2015-06-24 11:31:32.080    spid87    The database 'TrainingCHECK' is marked RESTORING and is in a state that does not allow recovery to be run.
2015-06-24 11:31:36.050    spid87    Starting up database 'TrainingCHECK'.
2015-06-24 11:31:37.440    Backup    Restore is complete on database 'TrainingCHECK'.  The database is now available.
2015-06-24 11:31:37.440    Backup    Database was restored: Database: TrainingCHECK, creation date(time): 2015/05/02(15:30:52), first LSN: 451:8079:249, last LSN: 451:8181:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'F:\Oum Pisith\CHECK_20150624.bak'}). Informational message. No user action required.
2015-06-24 11:33:07.680    spid120    Starting up database 'LIVE'.
2015-06-24 11:33:08.100    spid120    Starting up database 'TrainingCMM'.
2015-06-24 11:34:32.710    spid139    Starting up database 'LIVE'.
2015-06-24 11:34:33.260    spid139    Starting up database 'TrainingCMM'.
2015-06-24 11:36:15.270    Backup    Database backed up. Database: CHECK, creation date(time): 2015/05/02(15:30:52), pages dumped: 3493, first LSN: 451:8853:272, last LSN: 451:8964:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'F:\Oum Pisith\CHECK_20150624_2.bak'}). This is an informational message only. No user action is required.
2015-06-24 11:38:38.340    spid72    Process ID 117 was killed by hostname ITD-PISITH, host process ID 9720.
2015-06-24 11:38:41.780    spid72    Process ID 111 was killed by hostname ITD-PISITH, host process ID 9720.
2015-06-24 11:38:58.040    Backup    Error: 18272, Severity: 16, State: 1.
2015-06-24 11:38:58.040    Backup    During restore restart, an I/O error occurred on checkpoint file 'C:\Program Files\Microsoft SQL Server\MSSQL10.CRD\MSSQL\Backup\RestoreCheckpointDB11.CKP' (operating system error 5(Access is denied.)). The statement is proceeding but cannot be restarted. Ensure that a valid storage location exists for the checkpoint file.
2015-06-24 11:39:01.860    spid87    Starting up database 'TrainingCHECK'.
2015-06-24 11:39:01.870    spid87    The database 'TrainingCHECK' is marked RESTORING and is in a state that does not allow recovery to be run.
2015-06-24 11:39:05.780    spid87    Starting up database 'TrainingCHECK'.
2015-06-24 11:39:07.000    Backup    Restore is complete on database 'TrainingCHECK'.  The database is now available.
2015-06-24 11:39:07.020    Backup    Database was restored: Database: TrainingCHECK, creation date(time): 2015/05/02(15:30:52), first LSN: 451:8853:272, last LSN: 451:8964:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'F:\Oum Pisith\CHECK_20150624_2.bak'}). Informational message. No user action required.
2015-06-24 11:39:46.560    spid131    Starting up database 'LIVE'.
2015-06-24 11:39:46.930    spid131    Starting up database 'TrainingCMM'.
2015-06-24 11:40:52.290    spid151    Starting up database 'LIVE'.
2015-06-24 11:40:52.360    spid151    Starting up database 'TrainingCMM'.
2015-06-24 11:42:02.630    spid78    Starting up database 'LIVE'.
2015-06-24 11:42:02.700    spid78    Starting up database 'TrainingCMM'.
2015-06-24 11:43:21.660    spid151    Starting up database 'LIVE'.
2015-06-24 11:43:21.780    spid151    Starting up database 'TrainingCMM'.
2015-06-24 11:44:05.650    spid154    Starting up database 'LIVE'.
2015-06-24 11:44:05.750    spid154    Starting up database 'TrainingCMM'.
2015-06-24 11:53:23.460    spid77    Starting up database 'LIVE'.
2015-06-24 11:53:23.870    spid77    Starting up database 'TrainingCMM'.
2015-06-24 11:54:34.050    spid69    Starting up database 'LIVE'.
2015-06-24 11:54:34.140    spid69    Starting up database 'TrainingCMM'.
2015-06-24 12:34:25.770    spid93    Starting up database 'LIVE'.
2015-06-24 12:34:26.200    spid93    Starting up database 'TrainingCMM'.
2015-06-24 12:54:26.440    spid122    Starting up database 'LIVE'.
2015-06-24 12:54:26.550    spid122    Starting up database 'TrainingCMM'.
2015-06-24 12:57:43.980    spid88    Starting up database 'LIVE'.
2015-06-24 12:57:44.090    spid88    Starting up database 'TrainingCMM'.
2015-06-24 13:02:45.090    spid85    Starting up database 'LIVE'.
2015-06-24 13:02:45.200    spid85    Starting up database 'TrainingCMM'.
2015-06-24 13:26:46.530    spid114    Starting up database 'LIVE'.
2015-06-24 13:26:46.670    spid114    Starting up database 'TrainingCMM'.
2015-06-24 13:26:56.910    spid118    Starting up database 'LIVE'.
2015-06-24 13:26:56.990    spid118    Starting up database 'TrainingCMM'.
2015-06-24 13:31:03.860    spid107    Starting up database 'LIVE'.
2015-06-24 13:31:03.970    spid107    Starting up database 'TrainingCMM'.
2015-06-24 13:31:57.740    Logon    Error: 18456, Severity: 14, State: 5.
2015-06-24 13:31:57.740    Logon    Login failed for user 'acleda'. Reason: Could not find a login matching the name provided. [CLIENT: X.X.148.147]
2015-06-24 13:32:06.040    spid55    Starting up database 'LIVE'.
2015-06-24 13:32:06.100    spid55    Starting up database 'TrainingCMM'.
2015-06-24 13:35:03.080    spid132    Starting up database 'LIVE'.
2015-06-24 13:35:03.160    spid132    Starting up database 'TrainingCMM'.
2015-06-24 13:35:14.670    spid149    Starting up database 'LIVE'.
2015-06-24 13:35:14.740    spid149    Starting up database 'TrainingCMM'.
2015-06-24 13:35:16.980    spid149    Starting up database 'LIVE'.
2015-06-24 13:35:17.090    spid149    Starting up database 'TrainingCMM'.
2015-06-24 13:35:19.200    spid149    Starting up database 'LIVE'.
2015-06-24 13:35:19.480    spid149    Starting up database 'TrainingCMM'.
2015-06-24 13:35:21.800    spid149    Starting up database 'TrainingCMM'.
2015-06-24 13:35:22.700    spid149    Starting up database 'LIVE'.
2015-06-24 13:37:43.590    spid85    Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
2015-06-24 13:37:43.590    spid85    FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'CRD'.
2015-06-24 13:37:43.640    spid85    Configuration option 'xp_cmdshell' changed from 1 to 1. Run the RECONFIGURE statement to install.
2015-06-24 13:37:43.640    spid85    FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'CRD'.
2015-06-24 13:54:01.490    spid159    Starting up database 'LIVE'.
2015-06-24 13:54:01.900    spid159    Starting up database 'TrainingCMM'.
2015-06-24 13:55:14.830    spid170    Starting up database 'LIVE'.
2015-06-24 13:55:14.890    spid170    Starting up database 'TrainingCMM'.
2015-06-24 13:55:40.760    spid173    Starting up database 'LIVE'.
2015-06-24 13:55:40.870    spid173    Starting up database 'TrainingCMM'.
2015-06-24 13:55:51.800    spid180    Starting up database 'LIVE'.
2015-06-24 13:55:51.880    spid180    Starting up database 'TrainingCMM'.
2015-06-24 13:56:19.940    spid182    Starting up database 'LIVE'.
2015-06-24 13:56:20.030    spid182    Starting up database 'TrainingCMM'.
2015-06-24 13:58:48.610    spid162    Starting up database 'LIVE'.
2015-06-24 13:58:48.690    spid162    Starting up database 'TrainingCMM'.
2015-06-24 14:01:27.670    spid155    Starting up database 'LIVE'.
2015-06-24 14:01:27.760    spid155    Starting up database 'TrainingCMM'.
2015-06-24 14:13:29.690    spid71    Starting up database 'LIVE'.
2015-06-24 14:13:29.810    spid71    Starting up database 'TrainingCMM'.
2015-06-24 14:16:09.060    spid205    Starting up database 'LIVE'.
2015-06-24 14:16:09.120    spid205    Starting up database 'TrainingCMM'.
2015-06-24 14:26:23.640    Logon    Error: 18456, Severity: 14, State: 5.
2015-06-24 14:26:23.640    Logon    Login failed for user 'itiunit'. Reason: Could not find a login matching the name provided. [CLIENT: X.X.63.181]
2015-06-24 14:26:38.030    Logon    Error: 18456, Severity: 14, State: 8.
2015-06-24 14:26:38.030    Logon    Login failed for user 'itunit'. Reason: Password did not match that for the login provided. [CLIENT: X.X.63.181]
2015-06-24 14:28:56.380    spid167    Starting up database 'LIVE'.
2015-06-24 14:28:56.500    spid167    Starting up database 'TrainingCMM'.
2015-06-24 14:37:31.920    spid155    Starting up database 'LIVE'.
2015-06-24 14:37:32.030    spid155    Starting up database 'TrainingCMM'.
2015-06-24 14:38:59.400    spid145    Starting up database 'LIVE'.
2015-06-24 14:38:59.500    spid145    Starting up database 'TrainingCMM'.
2015-06-24 14:46:47.230    spid83    Starting up database 'LIVE'.
2015-06-24 14:46:47.360    spid83    Starting up database 'TrainingCMM'.
2015-06-24 14:51:23.360    spid179    Starting up database 'LIVE'.
2015-06-24 14:51:23.450    spid179    Starting up database 'TrainingCMM'.
2015-06-24 14:52:37.120    spid154    Starting up database 'LIVE'.
2015-06-24 14:52:37.170    spid154    Starting up database 'TrainingCMM'.
2015-06-24 14:56:40.530    spid174    Starting up database 'LIVE'.
2015-06-24 14:56:40.640    spid174    Starting up database 'TrainingCMM'.
2015-06-24 14:57:57.540    spid77    Starting up database 'LIVE'.
2015-06-24 14:57:57.600    spid77    Starting up database 'TrainingCMM'.
2015-06-24 15:00:42.420    spid184    Starting up database 'LIVE'.
2015-06-24 15:00:42.480    spid184    Starting up database 'TrainingCMM'.
2015-06-24 15:01:59.870    spid213    Starting up database 'LIVE'.
2015-06-24 15:01:59.950    spid213    Starting up database 'TrainingCMM'.
2015-06-24 15:02:02.290    spid213    Starting up database 'LIVE'.
2015-06-24 15:02:02.370    spid213    Starting up database 'TrainingCMM'.
2015-06-24 15:02:25.970    spid218    Starting up database 'LIVE'.
2015-06-24 15:02:26.050    spid218    Starting up database 'TrainingCMM'.
2015-06-24 15:03:14.460    spid88    Starting up database 'LIVE'.
2015-06-24 15:03:14.530    spid88    Starting up database 'TrainingCMM'.
2015-06-24 15:04:32.080    spid133    Starting up database 'LIVE'.
2015-06-24 15:04:32.120    spid133    Starting up database 'TrainingCMM'.
2015-06-24 15:10:08.210    spid165    Starting up database 'LIVE'.
2015-06-24 15:10:08.710    spid165    Starting up database 'TrainingCMM'.
2015-06-24 15:12:57.740    spid161    Starting up database 'TrainingCMM'.
2015-06-24 15:13:25.560    spid203    Starting up database 'LIVE'.
2015-06-24 15:13:25.690    spid203    Starting up database 'TrainingCMM'.
2015-06-24 15:13:27.860    spid203    Starting up database 'LIVE'.
2015-06-24 15:13:27.970    spid203    Starting up database 'TrainingCMM'.
2015-06-24 15:18:05.060    spid51    Starting up database 'LIVE'.
2015-06-24 15:18:05.130    spid51    Starting up database 'TrainingCMM'.
2015-06-24 15:22:16.160    spid186    Starting up database 'LIVE'.
2015-06-24 15:22:16.220    spid186    Starting up database 'TrainingCMM'.
2015-06-24 15:22:55.800    spid91    Starting up database 'LIVE'.
2015-06-24 15:22:55.880    spid91    Starting up database 'TrainingCMM'.
2015-06-24 15:25:37.040    spid183    Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
2015-06-24 15:25:37.040    spid183    FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'CRD'.
2015-06-24 15:25:37.070    spid183    Configuration option 'xp_cmdshell' changed from 1 to 1. Run the RECONFIGURE statement to install.
2015-06-24 15:25:37.070    spid183    FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'CRD'.
2015-06-24 15:27:33.410    spid164    Starting up database 'LIVE'.
2015-06-24 15:27:33.520    spid164    Starting up database 'TrainingCMM'.
2015-06-24 15:28:47.740    spid104    Starting up database 'LIVE'.
2015-06-24 15:28:47.830    spid104    Starting up database 'TrainingCMM'.
2015-06-24 15:30:36.330    spid192    Starting up database 'LIVE'.
2015-06-24 15:30:36.450    spid192    Starting up database 'TrainingCMM'.
2015-06-24 15:31:48.160    spid181    Starting up database 'LIVE'.
2015-06-24 15:31:48.240    spid181    Starting up database 'TrainingCMM'.
2015-06-24 15:34:31.430    spid151    Starting up database 'LIVE'.
2015-06-24 15:34:31.490    spid151    Starting up database 'TrainingCMM'.
2015-06-24 15:34:33.950    spid151    Starting up database 'LIVE'.
2015-06-24 15:34:34.110    spid151    Starting up database 'TrainingCMM'.
2015-06-24 15:34:36.210    spid151    Starting up database 'LIVE'.
2015-06-24 15:34:36.590    spid151    Starting up database 'TrainingCMM'.
2015-06-24 15:34:38.900    spid151    Starting up database 'TrainingCMM'.
2015-06-24 15:34:39.810    spid151    Starting up database 'LIVE'.
2015-06-24 15:35:50.500    spid170    Starting up database 'LIVE'.
2015-06-24 15:35:50.550    spid170    Starting up database 'TrainingCMM'.
2015-06-24 15:37:15.750    spid115    Starting up database 'LIVE'.
2015-06-24 15:37:17.070    spid115    Starting up database 'TrainingCMM'.
2015-06-24 15:37:31.430    Logon    Error: 18456, Severity: 14, State: 38.
2015-06-24 15:37:31.430    Logon    Login failed for user 'itunit'. Reason: Failed to open the explicitly specified database. [CLIENT: X.X.32.168]
2015-06-24 15:38:16.380    Logon    Error: 18456, Severity: 14, State: 38.
2015-06-24 15:38:16.380    Logon    Login failed for user 'itunit'. Reason: Failed to open the explicitly specified database. [CLIENT: X.X.32.168]
2015-06-24 15:38:41.110    spid182    Starting up database 'LIVE'.
2015-06-24 15:38:42.710    spid182    Starting up database 'TrainingCMM'.
2015-06-24 15:39:40.180    Backup    Database backed up. Database: LD3, creation date(time): 2013/09/01(15:35:44), pages dumped: 2866915, first LSN: 125637:149068:18, last LSN: 125637:149078:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'G:\lddata\Backup LD1&2\LD_20150624.bak'}). This is an informational message only. No user action is required.
2015-06-24 15:39:41.410    spid162    Starting up database 'LIVE'.
2015-06-24 15:39:41.970    spid162    Starting up database 'TrainingCMM'.
2015-06-24 15:41:18.180    spid78    Starting up database 'LIVE'.
2015-06-24 15:41:18.260    spid78    Starting up database 'TrainingCMM'.
2015-06-24 15:57:52.140    spid114    Starting up database 'LIVE'.
2015-06-24 15:57:52.570    spid114    Starting up database 'TrainingCMM'.
2015-06-24 16:02:06.950    spid63    Starting up database 'LIVE'.
2015-06-24 16:02:07.100    spid63    Starting up database 'TrainingCMM'.
2015-06-24 16:03:07.330    spid97    Starting up database 'LIVE'.
2015-06-24 16:03:07.400    spid97    Starting up database 'TrainingCMM'.
2015-06-24 16:05:14.440    spid136    Starting up database 'LIVE'.
2015-06-24 16:05:14.520    spid136    Starting up database 'TrainingCMM'.
2015-06-24 16:11:23.150    spid97    Starting up database 'LIVE'.
2015-06-24 16:11:23.510    spid97    Starting up database 'TrainingCMM'.
2015-06-24 16:14:37.830    spid123    Starting up database 'LIVE'.
2015-06-24 16:14:37.940    spid123    Starting up database 'TrainingCMM'.
2015-06-24 16:15:46.160    spid123    Starting up database 'LIVE'.
2015-06-24 16:15:46.240    spid123    Starting up database 'TrainingCMM'.
2015-06-24 16:17:37.070    spid119    Starting up database 'LIVE'.
2015-06-24 16:17:37.100    spid119    Starting up database 'TrainingCMM'.
2015-06-24 16:23:01.260    Backup    Database backed up. Database: CMM, creation date(time): 2015/03/19(11:23:52), pages dumped: 288290, first LSN: 2053:11867:228, last LSN: 2053:11979:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'F:\Oum Pisith\CMM-live-20150624_ALL_1_1622.bak'}). This is an informational message only. No user action is required.
2015-06-24 17:02:18.640    spid54    Starting up database 'LIVE'.
2015-06-24 17:02:19.010    spid54    Starting up database 'TrainingCMM'.
2015-06-24 17:02:19.670    spid54    Starting up database 'TrainingCMM1'.
2015-06-24 17:03:38.630    spid60    Starting up database 'LIVE'.
2015-06-24 17:03:38.750    spid60    Starting up database 'TrainingCMM'.
2015-06-24 17:03:38.820    spid60    Starting up database 'TrainingCMM1'.
2015-06-24 17:05:39.770    spid64    Starting up database 'LIVE'.
2015-06-24 17:05:39.870    spid64    Starting up database 'TrainingCMM'.
2015-06-24 17:05:39.960    spid64    Starting up database 'TrainingCMM1'.
2015-06-24 17:23:59.540    spid64    Starting up database 'LIVE'.
2015-06-24 17:23:59.620    spid64    Starting up database 'TrainingCMM'.
2015-06-24 17:23:59.730    spid64    Starting up database 'TrainingCMM1'.
2015-06-24 17:25:32.330    spid63    Starting up database 'LIVE'.
2015-06-24 17:25:32.450    spid63    Starting up database 'TrainingCMM'.
2015-06-24 17:25:32.530    spid63    Starting up database 'TrainingCMM1'.
2015-06-24 17:27:47.040    spid63    Starting up database 'LIVE'.
2015-06-24 17:27:47.150    spid63    Starting up database 'TrainingCMM'.
2015-06-24 17:27:47.240    spid63    Starting up database 'TrainingCMM1'.
2015-06-24 17:30:08.700    spid63    Starting up database 'LIVE'.
2015-06-24 17:30:08.800    spid63    Starting up database 'TrainingCMM'.
2015-06-24 17:30:08.890    spid63    Starting up database 'TrainingCMM1'.
2015-06-24 17:32:23.140    spid60    Starting up database 'LIVE'.
2015-06-24 17:32:23.230    spid60    Starting up database 'TrainingCMM'.
2015-06-24 17:32:23.330    spid60    Starting up database 'TrainingCMM1'.
2015-06-24 17:41:00.710    spid59    Starting up database 'LIVE'.
2015-06-24 17:41:00.780    spid59    Starting up database 'TrainingCMM'.
2015-06-24 17:41:00.910    spid59    Starting up database 'TrainingCMM1'.
2015-06-24 17:44:22.110    spid60    Starting up database 'LIVE'.
2015-06-24 17:44:22.210    spid60    Starting up database 'TrainingCMM'.
2015-06-24 17:44:22.300    spid60    Starting up database 'TrainingCMM1'.
2015-06-24 17:45:23.960    spid53    Starting up database 'LIVE'.
2015-06-24 17:45:24.030    spid53    Starting up database 'TrainingCMM'.
2015-06-24 17:45:24.120    spid53    Starting up database 'TrainingCMM1'.
2015-06-24 17:51:08.690    Backup    Database backed up. Database: CHECK, creation date(time): 2015/05/02(15:30:52), pages dumped: 3493, first LSN: 451:9428:199, last LSN: 451:9510:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'F:\Oum Pisith\CHECK_20150624_3.bak'}). This is an informational message only. No user action is required.
2015-06-24 18:00:39.130    Backup    Database backed up. Database: CMM, creation date(time): 2015/03/19(11:23:52), pages dumped: 288290, first LSN: 2053:13196:87, last LSN: 2053:13233:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\Backup\CMM\CMM_backup_2015_06_24_180001_8792460.bak'}). This is an informational message only. No user action is required.
2015-06-25 00:00:08.040    spid27s    This instance of SQL Server has been using a process ID of 5196 since 6/2/2015 3:47:20 PM (local) 6/2/2015 8:47:20 AM (UTC). This is an informational message only; no user action is required.

================================================

There login failure errors.

Login failed for user 'acleda'. Reason: Could not find a login matching the name provided. [CLIENT: X.X.96.241]

Please check login exists and permissions on the database.

In my server has been installed SQL Server two different versions:
    - Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64)
    - Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
    
Users could not login all intances (SQL Server 2008 and SQL Server 2008 R2). There is no error message, and when i restart the SQL Server Browser service users could login success.
what is the problem?  Is there anything wrong with SQL Server Browser service ?


Best regards,
Phea

Ok so browser service is not resonsible for Logins. Browser listens for incoming requests for Microsoft SQL Server resources and provides information about SQL Server instances installed on the computer. SQL Server Browser contributes to the following actions:

• Browsing a list of available servers

• Connecting to the correct server instance

• Connecting to dedicated administrator connection (DAC) endpoints.

>Users could not login all intances (SQL Server 2008 and SQL Server 2008 R2).

Now login failed will definately be follwoed by error message. How are users connecting ?

Can you run sp_readerrorlog and post its output here. Or you yourself can see when users tried to connect and refer to log details at that time. Unless you show us error details it would be difficult to help you

I agree with Prady

>Error: 18456, Severity: 14, State: 5.
2015-06-23 15:48:17.480    Logon    Login failed for user 'acleda'. Reason: Could not find a login matching the name provided. [CLIENT: X.X.96.241]

can you log into SQl Server or ask SQl Server admin to log into SQl server and check whether the account you are using to login exists under logins as far as error is concerned it seems and says when it is trying to check login you provided into SQl server it cannot find it.

If you have SA password you can as well connect and check

if login is domain account make sure it is part of Login group which has access to SQl Server

All users could not login including SA user, it seemed SQL Server Browser service did not respond to incoming requests. After i restart the SQL Server Browser service all users could login success. why i just restart the SQL Server Browser service they could login success?  what is cause of the problem?

All users could not login including SA user, it seemed SQL Server Browser service did not respond to incoming requests. After i restart the SQL Server Browser service all users could login success. why i just restart the SQL Server Browser service they could login success?  what is cause of the problem?

This is something what would have happened

If the SQL Server Browser service is not running, you are still able to connect to SQL Server if you provide the correct port number or named pipe. For instance, you can connect to the default instance of SQL Server with TCP/IP if it is running on port 1433.

However, if the SQL Server Browser service is not running, the following connections do not work:

• Any component that tries to connect to a named instance without fully specifying all the parameters (such as the TCP/IP port or named pipe).

• Any component that generates or passes server\instance information that could later be used by other components to reconnect.

• Connecting to a named instance without providing the port number or pipe.

• DAC to a named instance or the default instance if not using TCP/IP port 1433.

• The OLAP redirector service.

• Enumerating servers in SQL Server Management Studio, Enterprise Manager, or Query Analyzer.

If you are using SQL Server in a client-server scenario (for example, when your application is accessing SQL Server across a network), if you stop or disable the SQL Server Browser service, you must assign a specific port number to each instance and write your client application code to always use that port number.

With the above verification as suggested from Shanky, can you please let us know the following:

1. Is browser service is running under any account and set to run under automatically.

2. Browser services not in disabled mode.

3. Please post us the errors message if its other than "Network Related Specific......."

while connecting to SQL Server.

Thanks,

Hi,

1.

2. Browser service in Automatic mode.

3. Here is error message

Hi,

3. Here is error message

Hi P.Phea,

The reason that you get this error message is the client stack could not receive SSRP response UDP packet from SQL Browser.

Could you please check the steps in the following blog and use the PortQry tool  to isolate the issue?
http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

Thanks,
Lydia Zhang