Thursday, May 23, 2013

[MS SQL Server] Service SQLExpress does not start oall of the sudden.

[MS SQL Server] Service SQLExpress does not start oall of the sudden.

Service SQLExpress does not start oall of the sudden.

Posted: 23 May 2013 04:25 AM PDT

c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Binn\SQLAGENT.EXE" -i SQLEXPRESS2013-05-23 11:07:28.95 Server Microsoft SQL Server 2008 R2 (SP1) - 10.50.2550.0 (X64) Jun 11 2012 16:41:53 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)2013-05-23 11:07:29.18 Server (c) Microsoft Corporation.2013-05-23 11:07:29.18 Server All rights reserved.2013-05-23 11:07:29.18 Server Server process ID is 1048.2013-05-23 11:07:29.18 Server System Manufacturer: 'TOSHIBA', System Model: 'Satellite L675'.2013-05-23 11:07:29.23 Server Authentication mode is WINDOWS-ONLY.2013-05-23 11:07:29.23 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.2013-05-23 11:07:29.45 Server This instance of SQL Server last reported using a process ID of 3564 at 5/23/2013 11:04:04 AM (local) 5/23/2013 4:04:04 PM (UTC). This is an informational message only; no user action is required.2013-05-23 11:07:29.45 Server Registry startup parameters: -d C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf -e C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG -l C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf2013-05-23 11:07:29.97 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.2013-05-23 11:07:29.97 Server Detected 4 CPUs. This is an informational message; no user action is required.2013-05-23 11:07:33.76 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.2013-05-23 11:07:40.90 Server Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.2013-05-23 11:07:45.81 spid7s Starting up database 'master'.2013-05-23 11:07:47.44 spid7s The tail of the log for database master is being rewritten to match the new sector size of 4096 bytes. 3584 bytes at offset 619008 in file C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf will be written.2013-05-23 11:07:48.95 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.2013-05-23 11:07:49.04 spid7s Recovery completed for database master (database ID 1) in 1 second(s) (analysis 118 ms, redo 547 ms, undo 778 ms.) This is an informational message only. No user action is required.2013-05-23 11:07:52.39 spid7s Resource governor reconfiguration succeeded.2013-05-23 11:07:52.51 spid7s SQL Server Audit is starting the audits. This is an informational message. No user action is required.2013-05-23 11:07:52.63 spid7s SQL Server Audit has started the audits. This is an informational message. No user action is required.2013-05-23 11:07:52.89 spid7s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.2013-05-23 11:07:59.56 spid7s SQL Trace ID 1 was started by login "sa".2013-05-23 11:08:00.91 spid7s Starting up database 'mssqlsystemresource'.2013-05-23 11:08:02.27 spid7s The resource database build version is 10.50.2500. This is an informational message only. No user action is required.2013-05-23 11:08:07.34 spid11s Starting up database 'model'.2013-05-23 11:08:07.51 spid7s Server name is 'OWNER-PC'. This is an informational message only. No user action is required.2013-05-23 11:08:09.47 spid11s Clearing tempdb database.2013-05-23 11:08:12.27 Server A self-generated certificate was successfully loaded for encryption.2013-05-23 11:08:12.76 spid11s Starting up database 'tempdb'.2013-05-23 11:08:13.06 Server Server is listening on [ 'any' <ipv6> 1433].2013-05-23 11:08:13.06 Server Server is listening on [ 'any' <ipv4> 1433].2013-05-23 11:08:13.06 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].2013-05-23 11:08:13.06 Server Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].2013-05-23 11:08:13.07 Server Server is listening on [ ::1 <ipv6> 1434].2013-05-23 11:08:13.07 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].2013-05-23 11:08:13.08 Server Dedicated admin connection support was established for listening locally on port 1434.2013-05-23 11:08:13.47 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.2013-05-23 11:08:13.47 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.2013-05-23 11:08:14.37 Logon Error: 17187, Severity: 16, State: 1.2013-05-23 11:08:14.37 Logon SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: fe80::5efe:192.168.0.101%19]2013-05-23 11:08:14.87 spid10s The Service Broker protocol transport is disabled or not configured.2013-05-23 11:08:14.87 spid10s The Database Mirroring protocol transport is disabled or not configured.2013-05-23 11:08:15.17 spid10s Service Broker manager has started.2013-05-23 11:08:16.23 Logon Error: 18456, Severity: 14, State: 38.2013-05-23 11:08:16.23 Logon Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.0.101]2013-05-23 11:08:24.22 Logon Error: 18456, Severity: 14, State: 38.2013-05-23 11:08:24.22 Logon Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.0.101]2013-05-23 11:08:30.14 Logon Error: 18456, Severity: 14, State: 38.2013-05-23 11:08:30.14 Logon Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.0.101]2013-05-23 11:08:37.49 spid19s A new instance of the full-text filter daemon host process has been successfully started.2013-05-23 11:08:38.43 spid16s Starting up database 'msdb'.2013-05-23 11:08:38.44 spid18s Starting up database 'ReportServerTempDB'.2013-05-23 11:08:38.44 spid19s Starting up database 'NOP1'.2013-05-23 11:08:38.44 spid20s Starting up database 'websoldating'.2013-05-23 11:08:38.44 spid21s Starting up database 'dating'.2013-05-23 11:08:38.44 spid17s Starting up database 'ReportServer'.2013-05-23 11:08:38.44 spid22s Starting up database 'omegalovetemp'.2013-05-23 11:08:38.44 spid23s Starting up database 'nop'.2013-05-23 11:08:38.44 spid24s Starting up database 'BlogEngine'.2013-05-23 11:08:38.44 spid25s Starting up database 'dbaspnet'.2013-05-23 11:08:38.44 spid26s Starting up database 'DatingSiteLite'.2013-05-23 11:08:38.44 spid27s Starting up database 'KenticoCMS'.2013-05-23 11:08:38.44 spid28s Starting up database 'mojo'.2013-05-23 11:08:38.44 spid29s Starting up database 'mojoportal'.2013-05-23 11:08:38.44 spid30s Starting up database 'popforums8'.2013-05-23 11:08:38.44 spid31s Starting up database 'Cuyahoga'.2013-05-23 11:08:39.22 spid18s Starting up database 'SchoolData'.2013-05-23 11:08:40.38 spid31s 1 transactions rolled forward in database 'Cuyahoga' (19). This is an informational message only. No user action is required.2013-05-23 11:08:41.01 spid7s 0 transactions rolled back in database 'Cuyahoga' (19). This is an informational message only. No user action is required.2013-05-23 11:08:41.01 spid7s Recovery is writing a checkpoint in database 'Cuyahoga' (19). This is an informational message only. No user action is required.2013-05-23 11:08:41.01 spid7s Recovery completed for database Cuyahoga (database ID 19) in 1 second(s) (analysis 531 ms, redo 75 ms, undo 402 ms.) This is an informational message only. No user action is required.2013-05-23 11:08:42.15 Logon Error: 18456, Severity: 14, State: 38.2013-05-23 11:08:42.15 Logon Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.0.101]2013-05-23 11:08:42.38 spid18s 1 transactions rolled forward in database 'SchoolData' (20). This is an informational message only. No user action is required.2013-05-23 11:08:42.60 spid7s 0 transactions rolled back in database 'SchoolData' (20). This is an informational message only. No user action is required.2013-05-23 11:08:42.60 spid7s Recovery is writing a checkpoint in database 'SchoolData' (20). This is an informational message only. No user action is required.2013-05-23 11:08:42.91 spid30s 1 transactions rolled forward in database 'popforums8' (18). This is an informational message only. No user action is required.2013-05-23 11:08:43.05 spid27s 1 transactions rolled forward in database 'KenticoCMS' (15). This is an informational message only. No user action is required.2013-05-23 11:08:43.08 spid20s Starting up database 'HMS_Org_1'.2013-05-23 11:08:43.10 spid31s Starting up database 'CommunityServerDesk'.2013-05-23 11:08:43.23 spid18s 0 transactions rolled back in database 'popforums8' (18). This is an informational message only. No user action is required.2013-05-23 11:08:43.23 spid18s Recovery is writing a checkpoint in database 'popforums8' (18). This is an informational message only. No user action is required.2013-05-23 11:08:43.23 spid18s Starting up database 'CommunityServerTemp'.2013-05-23 11:08:43.25 spid21s Starting up database 'CommunityServerMatt'.2013-05-23 11:08:43.46 spid23s Recovery completed for database dbaspnet (database ID 13) in 1 second(s) (analysis 1 ms, redo 0 ms, undo 1048 ms.) This is an informational message only. No user action is required.2013-05-23 11:08:43.46 spid23s Starting up database 'CommunityServer'.2013-05-23 11:08:43.60 spid25s Starting up database 'Community'.2013-05-23 11:08:43.60 spid24s Starting up database 'itmanager'.2013-05-23 11:08:43.74 spid30s Starting up database 'ITWebBackup'.2013-05-23 11:08:43.75 spid26s Starting up database 'CommunityServerTC'.2013-05-23 11:08:43.91 spid7s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.2013-05-23 11:08:43.91 spid7s Recovery completed for database msdb (database ID 4) in 2 second(s) (analysis 623 ms, redo 1501 ms, undo 107 ms.) This is an informational message only. No user action is required.2013-05-23 11:08:44.02 spid7s Recovery completed for database omegalovetemp (database ID 10) in 1 second(s) (analysis 2 ms, redo 0 ms, undo 246 ms.) This is an informational message only. No user action is required.2013-05-23 11:08:44.13 spid7s 0 transactions rolled back in database 'KenticoCMS' (15). This is an informational message only. No user action is required.2013-05-23 11:08:44.13 spid7s Recovery is writing a checkpoint in database 'KenticoCMS' (15). This is an informational message only. No user action is required.2013-05-23 11:08:44.13 spid7s Recovery completed for database KenticoCMS (database ID 15) in 1 second(s) (analysis 2 ms, redo 0 ms, undo 329 ms.) This is an informational message only. No user action is required.2013-05-23 11:08:45.10 spid16s Starting up database 'CommunityTemp2'.2013-05-23 11:08:45.20 spid22s Starting up database 'CommunityServer1'.2013-05-23 11:08:46.04 spid28s 1 transactions rolled forward in database 'mojo' (16). This is an informational message only. No user action is required.2013-05-23 11:08:46.35 spid27s 0 transactions rolled back in database 'mojo' (16). This is an informational message only. No user action is required.2013-05-23 11:08:46.35 spid27s Recovery is writing a checkpoint in database 'mojo' (16). This is an informational message only. No user action is required.2013-05-23 11:08:46.35 spid27s Starting up database 'TelligentCommunity'.2013-05-23 11:08:46.70 spid19s Starting up database 'CCS2'.2013-05-23 11:08:48.37 spid28s Starting up database 'omegalove'.2013-05-23 11:08:48.37 spid17s Starting up database 'netfocus'.2013-05-23 11:08:49.20 spid29s 1 transactions rolled forward in database 'mojoportal' (17). This is an informational message only. No user action is required.2013-05-23 11:08:49.57 spid7s 0 transactions rolled back in database 'mojoportal' (17). This is an informational message only. No user action is required.2013-05-23 11:08:49.64 spid7s Recovery is writing a checkpoint in database 'mojoportal' (17). This is an informational message only. No user action is required.2013-05-23 11:08:50.65 spid29s Starting up database 'CommunityServerTelligent'.2013-05-23 11:08:51.57 spid27s 1 transactions rolled forward in database 'TelligentCommunity' (32). This is an informational message only. No user action is required.2013-05-23 11:08:51.83 spid25s 1 transactions rolled forward in database 'Community' (26). This is an informational message only. No user action is required.2013-05-23 11:08:52.05 spid21s 1 transactions rolled forward in database 'CommunityServerMatt' (24). This is an informational message only. No user action is required.2013-05-23 11:08:52.10 spid23s 1 transactions rolled forward in database 'CommunityServer' (25). This is an informational message only. No user action is required.2013-05-23 11:08:52.47 spid26s 1 transactions rolled forward in database 'CommunityServerTC' (29). This is an informational message only. No user action is required.2013-05-23 11:08:52.51 spid22s 1 transactions rolled forward in database 'CommunityServer1' (31). This is an informational message only. No user action is required.2013-05-23 11:08:52.67 spid16s 1 transactions rolled forward in database 'CommunityTemp2' (30). This is an informational message only. No user action is required.2013-05-23 11:08:52.94 spid7s 0 transactions rolled back in database 'TelligentCommunity' (32). This is an informational message only. No user action is required.2013-05-23 11:08:53.03 spid27s 0 transactions rolled back in database 'Community' (26). This is an informational message only. No user action is required.2013-05-23 11:08:53.03 spid27s Recovery is writing a checkpoint in database 'Community' (26). This is an informational message only. No user action is required.2013-05-23 11:08:53.03 spid27s Recovery completed for database Community (database ID 26) in 1 second(s) (analysis 1 ms, redo 0 ms, undo 1044 ms.) This is an informational message only. No user action is required.2013-05-23 11:08:53.03 spid27s 0 transactions rolled back in database 'CommunityServerMatt' (24). This is an informational message only. No user action is required.2013-05-23 11:08:53.03 spid27s Recovery is writing a checkpoint in database 'CommunityServerMatt' (24). This is an informational message only. No user action is required.2013-05-23 11:08:53.07 spid17s 1 transactions rolled forward in database 'netfocus' (35). This is an informational message only. No user action is required.2013-05-23 11:08:53.25 spid7s Recovery is writing a checkpoint in database 'TelligentCommunity' (32). This is an informational message only. No user action is required.2013-05-23 11:08:53.45 spid27s Recovery completed for database CommunityServerMatt (database ID 24) in 1 second(s) (analysis 15 ms, redo 0 ms, undo 967 ms.) This is an informational message only. No user action is required.2013-05-23 11:08:53.45 spid21s 0 transactions rolled back in database 'CommunityServerTC' (29). This is an informational message only. No user action is required.2013-05-23 11:08:53.45 spid27s 0 transactions rolled back in database 'CommunityTemp2' (30). This is an informational message only. No user action is required.2013-05-23 11:08:53.45 spid21s Recovery is writing a checkpoint in database 'CommunityServerTC' (29). This is an informational message only. No user action is required.2013-05-23 11:08:53.45 spid27s Recovery is writing a checkpoint in database 'CommunityTemp2' (30). This is an informational message only. No user action is required.2013-05-23 11:08:53.57 spid24s 1 transactions rolled forward in database 'itmanager' (27). This is an informational message only. No user action is required.2013-05-23 11:08:53.69 spid17s 0 transactions rolled back in database 'CommunityServer1' (31). This is an informational message only. No user action is required.2013-05-23 11:08:53.69 spid17s Recovery is writing a checkpoint in database 'CommunityServer1' (31). This is an informational message only. No user action is required.2013-05-23 11:08:53.80 spid20s 1 transactions rolled forward in database 'HMS_Org_1' (21). This is an informational message only. No user action is required.2013-05-23 11:08:53.88 spid21s Recovery completed for database CommunityServerTC (database ID 29) in 1 second(s) (analysis 87 ms, redo 0 ms, undo 961 ms.) This is an informational message only. No user action is required.2013-05-23 11:08:53.88 spid21s 0 transactions rolled back in database 'netfocus' (35). This is an informational message only. No user action is required.2013-05-23 11:08:53.88 spid21s Recovery is writing a checkpoint in database 'netfocus' (35). This is an informational message only. No user action is required.2013-05-23 11:08:53.92 spid26s 0 transactions rolled back in database 'CommunityServer' (25). This is an informational message only. No user action is required.2013-05-23 11:08:53.92 spid26s Recovery is writing a checkpoint in database 'CommunityServer' (25). This is an informational message only. No user action is required.2013-05-23 11:08:53.92 spid26s Recovery completed for database CommunityServer (database ID 25) in 1 second(s) (analysis 2 ms, redo 0 ms, undo 1234 ms.) This is an informational message only. No user action is required.2013-05-23 11:08:53.92 spid26s 0 transactions rolled back in database 'itmanager' (27). This is an informational message only. No user action is required.2013-05-23 11:08:53.92 spid26s Recovery is writing a checkpoint in database 'itmanager' (27). This is an informational message only. No user action is required.2013-05-23 11:08:53.92 spid26s Recovery completed for database itmanager (database ID 27) in 1 second(s) (analysis 1306 ms, redo 0 ms, undo 188 ms.) This is an informational message only. No user action is required.2013-05-23 11:08:53.92 spid26s Starting up database 'Forum1'.2013-05-23 11:08:54.03 spid7s Recovery completed for database TelligentCommunity (database ID 32) in 2 second(s) (analysis 1 ms, redo 0 ms, undo 1151 ms.) This is an informational message only. No user action is required.2013-05-23 11:08:54.14 spid7s 0 transactions rolled back in database 'HMS_Org_1' (21). This is an informational message only. No user action is required.2013-05-23 11:08:54.14 spid7s Recovery is writing a checkpoint in database 'HMS_Org_1' (21). This is an informational message only. No user action is required.2013-05-23 11:08:54.17 spid18s 1 transactions rolled forward in database 'CommunityServerTemp' (23). This is an informational message only. No user action is required.2013-05-23 11:08:54.36 spid25s Starting up database 'InfoDB'.2013-05-23 11:08:54.38 spid27s Recovery completed for database CommunityTemp2 (database ID 30) in 1 second(s) (analysis 36 ms, redo 0 ms, undo 753 ms.) This is an informational message only. No user action is required.2013-05-23 11:08:54.38 spid27s Starting up database 'News'.2013-05-23 11:08:54.38 spid16s Starting up database 'AccountsAtAGlance'.2013-05-23 11:08:54.46 spid7s 0 transactions rolled back in database 'CommunityServerTemp' (23). This is an informational message only. No user action is required.2013-05-23 11:08:54.46 spid7s Recovery is writing a checkpoint in database 'CommunityServerTemp' (23). This is an informational message only. No user action is required.2013-05-23 11:08:54.76 spid30s 1 transactions rolled forward in database 'ITWebBackup' (28). This is an informational message only. No user action is required.2013-05-23 11:08:54.83 spid17s Recovery completed for database CommunityServer1 (database ID 31) in 2 second(s) (analysis 30 ms, redo 0 ms, undo 771 ms.) This is an informational message only. No user action is required.2013-05-23 11:08:54.83 spid17s Starting up database 'IFNuke'.2013-05-23 11:08:54.83 spid22s Starting up database 'CarrotwareCMS'.2013-05-23 11:08:55.07 spid24s Starting up database 'payroll'.2013-05-23 11:08:55.17 spid31s 1 transactions rolled forward in database 'CommunityServerDesk' (22). This is an informational message only. No user action is required.2013-05-23 11:08:55.33 spid7s 0 transactions rolled back in database 'ITWebBackup' (28). This is an informational message only. No user action is required.2013-05-23 11:08:55.33 spid7s Recovery is writing a checkpoint in database 'ITWebBackup' (28). This is an informational message only. No user action is required.2013-05-23 11:08:55.44 spid7s 0 transactions rolled back in database 'CommunityServerDesk' (22). This is an informational message only. No user action is required.2013-05-23 11:08:55.44 spid7s Recovery is writing a checkpoint in database 'CommunityServerDesk' (22). This is an informational message only. No user action is required.2013-05-23 11:08:55.44 spid7s Recovery completed for database CommunityServerDesk (database ID 22) in 1 second(s) (analysis 1313 ms, redo 5 ms, undo 55 ms.) This is an informational message only. No user action is required.2013-05-23 11:08:55.51 spid18s Starting up database 'nopcommerce'.2013-05-23 11:08:55.56 spid21s Recovery completed for database netfocus (database ID 35) in 3 second(s) (analysis 638 ms, redo 0 ms, undo 746 ms.) This is an informational message only. No user action is required.2013-05-23 11:08:55.56 spid21s Starting up database 'EmployeeInfo_SK_5_0'.2013-05-23 11:08:55.64 spid29s 1 transactions rolled forward in database 'CommunityServerTelligent' (36). This is an informational message only. No user action is required.2013-05-23 11:08:55.81 spid20s Starting up database 'C:\OWNER\WWWROOT\WEBMAIL\APP_DATA\HELPDESK.MDF'.2013-05-23 11:08:56.05 spid24s 1 transactions rolled forward in database 'payroll' (43). This is an informational message only. No user action is required.2013-05-23 11:08:56.10 spid7s 0 transactions rolled back in database 'payroll' (43). This is an informational message only. No user action is required.2013-05-23 11:08:56.11 spid7s Recovery is writing a checkpoint in database 'payroll' (43). This is an informational message only. No user action is required.2013-05-23 11:08:56.29 spid30s Starting up database 'C:\OWNER\WWWROOT\TBH_WEB\APP_DATA\ASPNETDB.MDF'.2013-05-23 11:08:56.43 spid7s 0 transactions rolled back in database 'CommunityServerTelligent' (36). This is an informational message only. No user action is required.2013-05-23 11:08:56.43 spid7s Recovery is writing a checkpoint in database 'CommunityServerTelligent' (36). This is an informational message only. No user action is required.2013-05-23 11:08:56.58 spid23s Starting up database 'TheBeerHouseVB'.2013-05-23 11:08:56.79 spid24s Starting up database 'C:\INETPUB\WWWROOT\BEER\TBH_WEB\APP_DATA\ASPNETDB.MDF'.2013-05-23 11:08:56.84 spid31s Starting up database 'RTAFleet'.2013-05-23 11:08:56.96 spid28s 1 transactions rolled forward in database 'omegalove' (34). This is an informational message only. No user action is required.2013-05-23 11:08:57.24 spid25s 1 transactions rolled forward in database 'InfoDB' (38). This is an informational message only. No user action is required.2013-05-23 11:08:57.29 spid27s 1 transactions rolled forward in database 'News' (39). This is an informational message only. No user action is required.2013-05-23 11:08:57.34 spid21s 1 transactions rolled forward in database 'EmployeeInfo_SK_5_0' (45). This is an informational message only. No user action is required.2013-05-23 11:08:57.39 spid29s Starting up database 'Phoenix'.2013-05-23 11:08:57.70 spid26s 1 transactions rolled forward in database 'Forum1' (37). This is an informational message only. No user action is required.2013-05-23 11:08:57.77 spid17s 1 transactions rolled forward in database 'IFNuke' (41). This is an informational message only. No user action is required.2013-05-23 11:08:57.85 spid7s 0 transactions rolled back in database 'omegalove' (34). This is an informational message only. No user action is required.2013-05-23 11:08:57.95 spid22s 1 transactions rolled forward in database 'CarrotwareCMS' (42). This is an informational message only. No user action is required.2013-05-23 11:08:57.95 spid7s Recovery is writing a checkpoint in database 'omegalove' (34). This is an informational message only. No user action is required.2013-05-23 11:08:57.99 spid7s Recovery completed for database omegalove (database ID 34) in 1 second(s) (analysis 84 ms, redo 0 ms, undo 795 ms.) This is an informational message only. No user action is required.2013-05-23 11:08:58.10 spid22s 0 transactions rolled back in database 'News' (39). This is an informational message only. No user action is required.2013-05-23 11:08:58.10 spid22s Recovery is writing a checkpoint in database 'News' (39). This is an informational message only. No user action is required.2013-05-23 11:08:58.10 spid22s 0 transactions rolled back in database 'Forum1' (37). This is an informational message only. No user action is required.2013-05-23 11:08:58.10 spid22s Recovery is writing a checkpoint in database 'Forum1' (37). This is an informational message only. No user action is required.2013-05-23 11:08:58.10 spid22s 0 transactions rolled back in database 'IFNuke' (41). This is an informational message only. No user action is required.2013-05-23 11:08:58.10 spid22s Recovery is writing a checkpoint in database 'IFNuke' (41). This is an informational message only. No user action is required.2013-05-23 11:08:58.10 spid22s 0 transactions rolled back in database 'EmployeeInfo_SK_5_0' (45). This is an informational message only. No user action is required.2013-05-23 11:08:58.10 spid22s Recovery is writing a checkpoint in database 'EmployeeInfo_SK_5_0' (45). This is an informational message only. No user action is required.2013-05-23 11:08:58.10 spid22s 0 transactions rolled back in database 'CarrotwareCMS' (42). This is an informational message only. No user action is required.2013-05-23 11:08:58.10 spid22s Recovery is writing a checkpoint in database 'CarrotwareCMS' (42). This is an informational message only. No user action is required.2013-05-23 11:08:58.25 spid21s 0 transactions rolled back in database 'InfoDB' (38). This is an informational message only. No user action is required.2013-05-23 11:08:58.25 spid21s Recovery is writing a checkpoint in database 'InfoDB' (38). This is an informational message only. No user action is required.2013-05-23 11:08:58.25 spid21s Recovery completed for database InfoDB (database ID 38) in 1 second(s) (analysis 2 ms, redo 0 ms, undo 174 ms.) This is an informational message only. No user action is required.2013-05-23 11:08:58.25 spid21s Starting up database 'ReplacementSchedule'.2013-05-23 11:08:58.27 spid22s Starting up database 'GreyHound'.2013-05-23 11:08:58.90 spid20s 1 transactions rolled forward in database 'C:\OWNER\WWWROOT\WEBMAIL\APP_DATA\HELPDESK.MDF' (46). This is an informational message only. No user action is required.2013-05-23 11:08:58.99 spid16s 1 transactions rolled forward in database 'AccountsAtAGlance' (40). This is an informational message only. No user action is required.2013-05-23 11:08:59.07 spid30s 1 transactions rolled forward in database 'C:\OWNER\WWWROOT\TBH_WEB\APP_DATA\ASPNETDB.MDF' (47). This is an informational message only. No user action is required.2013-05-23 11:08:59.12 spid7s 0 transactions rolled back in database 'C:\OWNER\WWWROOT\WEBMAIL\APP_DATA\HELPDESK.MDF' (46). This is an informational message only. No user action is required.2013-05-23 11:08:59.12 spid7s Recovery is writing a checkpoint in database 'C:\OWNER\WWWROOT\WEBMAIL\APP_DATA\HELPDESK.MDF' (46). This is an informational message only. No user action is required.2013-05-23 11:08:59.23 spid7s 0 transactions rolled back in database 'C:\OWNER\WWWROOT\TBH_WEB\APP_DATA\ASPNETDB.MDF' (47). This is an informational message only. No user action is required.2013-05-23 11:08:59.23 spid7s Recovery is writing a checkpoint in database 'C:\OWNER\WWWROOT\TBH_WEB\APP_DATA\ASPNETDB.MDF' (47). This is an informational message only. No user action is required.2013-05-23 11:08:59.36 spid17s Starting up database 'ADefHelpDeskStandAlone'.2013-05-23 11:08:59.44 spid25s Starting up database 'Northwind'.2013-05-23 11:08:59.65 spid26s Starting up database 'AdventureWorks'.2013-05-23 11:08:59.77 spid18s 1 transactions rolled forward in database 'nopcommerce' (44). This is an informational message only. No user action is required.2013-05-23 11:08:59.77 spid7s 0 transactions rolled back in database 'AccountsAtAGlance' (40). This is an informational message only. No user action is required.2013-05-23 11:08:59.77 spid7s Recovery is writing a checkpoint in database 'AccountsAtAGlance' (40). This is an informational message only. No user action is required.2013-05-23 11:08:59.77 spid7s Recovery completed for database AccountsAtAGlance (database ID 40) in 1 second(s) (analysis 330 ms, redo 0 ms, undo 699 ms.) This is an informational message only. No user action is required.2013-05-23 11:08:59.93 spid27s Starting up database 'AdventureWorksLT2008'.2013-05-23 11:09:00.01 spid16s Starting up database 'C:\PROGRAM FILES (X86)\TELERIK\RADCONTROLS FOR ASP.NET AJAX Q1 2012\LIVE DEMOS\APP_DATA\NORTHWIND.MDF'.2013-05-23 11:09:00.62 spid7s 0 transactions rolled back in database 'nopcommerce' (44). This is an informational message only. No user action is required.2013-05-23 11:09:00.84 spid22s 1 transactions rolled forward in database 'GreyHound' (53). This is an informational message only. No user action is required.2013-05-23 11:09:00.85 spid23s 5 transactions rolled forward in database 'TheBeerHouseVB' (48). This is an informational message only. No user action is required.2013-05-23 11:09:01.00 spid30s 0 transactions rolled back in database 'TheBeerHouseVB' (48). This is an informational message only. No user action is required.2013-05-23 11:09:01.00 spid30s Recovery is writing a checkpoint in database 'TheBeerHouseVB' (48). This is an informational message only. No user action is required.2013-05-23 11:09:01.00 spid30s 0 transactions rolled back in database 'GreyHound' (53). This is an informational message only. No user action is required.2013-05-23 11:09:01.00 spid30s Recovery is writing a checkpoint in database 'GreyHound' (53). This is an informational message only. No user action is required.2013-05-23 11:09:01.00 spid30s Starting up database 'C:\PROGRAM FILES (X86)\TELERIK\RADCONTROLS FOR ASP.NET AJAX Q1 2012\LIVE DEMOS\APP_DATA\TELERIK.MDF'.2013-05-23 11:09:01.05 spid27s 1 transactions rolled forward in database 'AdventureWorksLT2008' (57). This is an informational message only. No user action is required.2013-05-23 11:09:01.12 spid7s Recovery is writing a checkpoint in database 'nopcommerce' (44). This is an informational message only. No user action is required.2013-05-23 11:09:01.12 spid7s Recovery completed for database nopcommerce (database ID 44) in 2 second(s) (analysis 219 ms, redo 53 ms, undo 761 ms.) This is an informational message only. No user action is required.2013-05-23 11:09:01.28 spid22s Starting up database 'sitefinity'.2013-05-23 11:09:01.30 spid17s 1 transactions rolled forward in database 'ADefHelpDeskStandAlone' (54). This is an informational message only. No user action is required.2013-05-23 11:09:01.32 spid28s Starting up database 'sitefinitytest'.2013-05-23 11:09:01.43 spid24s 1 transactions rolled forward in database 'C:\INETPUB\WWWROOT\BEER\TBH_WEB\APP_DATA\ASPNETDB.MDF' (49). This is an informational message only. No user action is required.2013-05-23 11:09:01.69 spid7s 0 transactions rolled back in database 'ADefHelpDeskStandAlone' (54). This is an informational message only. No user action is required.2013-05-23 11:09:01.71 spid7s Recovery is writing a checkpoint in database 'ADefHelpDeskStandAlone' (54). This is an informational message only. No user action is required.2013-05-23 11:09:01.90 spid19s 1 transactions rolled forward in database 'CCS2' (33). This is an informational message only. No user action is required.2013-05-23 11:09:01.93 spid25s 1 transactions rolled forward in database 'Northwind' (55). This is an informational message only. No user action is required.2013-05-23 11:09:01.93 spid27s 0 transactions rolled back in database 'AdventureWorksLT2008' (57). This is an informational message only. No user action is required.2013-05-23 11:09:01.93 spid27s Recovery is writing a checkpoint in database 'AdventureWorksLT2008' (57). This is an informational message only. No user action is required.2013-05-23 11:09:02.09 spid20s 0 transactions rolled back in database 'C:\INETPUB\WWWROOT\BEER\TBH_WEB\APP_DATA\ASPNETDB.MDF' (49). This is an informational message only. No user action is required.2013-05-23 11:09:02.09 spid20s Recovery is writing a checkpoint in database 'C:\INETPUB\WWWROOT\BEER\TBH_WEB\APP_DATA\ASPNETDB.MDF' (49). This is an informational message only. No user action is required.2013-05-23 11:09:02.09 spid20s Starting up database 'projectsite'.2013-05-23 11:09:02.15 spid29s 1 transactions rolled forward in database 'Phoenix' (51). This is an informational message only. No user action is required.2013-05-23 11:09:02.30 spid27s Recovery completed for database AdventureWorksLT2008 (database ID 57) in 1 second(s) (analysis 1 ms, redo 0 ms, undo 596 ms.) This is an informational message only. No user action is required.2013-05-23 11:09:02.30 spid27s Starting up database 'Fisharoo'.2013-05-23 11:09:02.42 spid18s 0 transactions rolled back in database 'CCS2' (33). This is an informational message only. No user action is required.2013-05-23 11:09:02.42 spid18s Recovery is writing a checkpoint in database 'CCS2' (33). This is an informational message only. No user action is required.2013-05-23 11:09:02.42 spid18s Recovery completed for database CCS2 (database ID 33) in 1 second(s) (analysis 40 ms, redo 180 ms, undo 98 ms.) This is an informational message only. No user action is required.2013-05-23 11:09:02.42 spid18s 0 transactions rolled back in database 'Northwind' (55). This is an informational message only. No user action is required.2013-05-23 11:09:02.42 spid18s Recovery is writing a checkpoint in database 'Northwind' (55). This is an informational message only. No user action is required.2013-05-23 11:09:02.42 spid18s Starting up database 'Geo'.2013-05-23 11:09:02.60 spid24s Starting up database 'C:\INETPUB\WWWROOT\SALESDASHBOARD\TELERIK.SALESDASHBOARD.WEB\APP_DATA\NORTHWIND.MDF'.2013-05-23 11:09:02.81 spid7s Recovery completed for database ADefHelpDeskStandAlone (database ID 54) in 1 second(s) (analysis 4 ms, redo 0 ms, undo 377 ms.) This is an informational message only. No user action is required.2013-05-23 11:09:02.81 spid17s Starting up database 'WI_FFFCSK'.2013-05-23 11:09:02.89 spid25s Starting up database 'C:\INETPUB\WWWROOT\CRMEXAMPLE\APP_DATA\NORTHWIND.MDF'.2013-05-23 11:09:03.24 spid7s 0 transactions rolled back in database 'Phoenix' (51). This is an informational message only. No user action is required.2013-05-23 11:09:03.24 spid7s Recovery is writing a checkpoint in database 'Phoenix' (51). This is an informational message only. No user action is required.2013-05-23 11:09:03.24 spid7s Recovery completed for database Phoenix (database ID 51) in 1 second(s) (analysis 452 ms, redo 0 ms, undo 1040 ms.) This is an informational message only. No user action is required.2013-05-23 11:09:03.31 spid28s 1 transactions rolled forward in database 'sitefinitytest' (61). This is an informational message only. No user action is required.2013-05-23 11:09:03.46 spid7s 0 transactions rolled back in database 'sitefinitytest' (61). This is an informational message only. No user action is required.2013-05-23 11:09:03.46 spid7s Recovery is writing a checkpoint in database 'sitefinitytest' (61). This is an informational message only. No user action is required.2013-05-23 11:09:04.14 spid19s Starting up database 'Minotaur'.2013-05-23 11:09:04.39 spid26s 9 transactions rolled forward in database 'AdventureWorks' (56). This is an informational message only. No user action is required.2013-05-23 11:09:04.51 spid28s Starting up database 'Kentico'.2013-05-23 11:09:04.94 spid7s 0 transactions rolled back in database 'AdventureWorks' (56). This is an informational message only. No user action is required.2013-05-23 11:09:04.94 spid7s Recovery is writing a checkpoint in database 'AdventureWorks' (56). This is an informational message only. No user action is required.2013-05-23 11:09:05.02 spid25s 1 transactions rolled forward in database 'C:\INETPUB\WWWROOT\CRMEXAMPLE\APP_DATA\NORTHWIND.MDF' (68). This is an informational message only. No user action is required.2013-05-23 11:09:05.09 spid23s Starting up database 'C:\INETPUB\WWWROOT\SCHEDULEBUILDER\SCHEDULEBUILDER.WEB\APP_DATA\SCHEDULERDATA.MDF'.2013-05-23 11:09:05.09 spid17s 1 transactions rolled forward in database 'WI_FFFCSK' (67). This is an informational message only. No user action is required.2013-05-23 11:09:05.18 spid22s 1 transactions rolled forward in database 'sitefinity' (60). This is an informational message only. No user action is required.2013-05-23 11:09:05.27 spid7s 0 transactions rolled back in database 'WI_FFFCSK' (67). This is an informational message only. No user action is required.2013-05-23 11:09:05.27 spid7s Recovery is writing a checkpoint in database 'WI_FFFCSK' (67). This is an informational message only. No user action is required.2013-05-23 11:09:05.43 spid7s 0 transactions rolled back in database 'C:\INETPUB\WWWROOT\CRMEXAMPLE\APP_DATA\NORTHWIND.MDF' (68). This is an informational message only. No user action is required.2013-05-23 11:09:05.43 spid7s Recovery is writing a checkpoint in database 'C:\INETPUB\WWWROOT\CRMEXAMPLE\APP_DATA\NORTHWIND.MDF' (68). This is an informational message only. No user action is required.2013-05-23 11:09:05.48 spid17s Starting up database 'Site'.2013-05-23 11:09:05.76 spid7s 0 transactions rolled back in database 'sitefinity' (60). This is an informational message only. No user action is required.2013-05-23 11:09:05.76 spid7s Recovery is writing a checkpoint in database 'sitefinity' (60). This is an informational message only. No user action is required.2013-05-23 11:09:05.80 spid25s Starting up database 'F:\NEW FOLDER\WEBMAIL\APP_DATA\HELPDESK.MDF'.2013-05-23 11:09:05.80 spid25s Error: 17204, Severity: 16, State: 1.2013-05-23 11:09:05.80 spid25s FCB::Open failed: Could not open file F:\New folder\WebMail\App_Data\HelpDesk.mdf for file number 1. OS error: 3(The system cannot find the path specified.).2013-05-23 11:09:05.87 spid29s Starting up database 'C:\INETPUB\WWWROOT\RTA\APP_DATA\SITEFINITY.MDF'.2013-05-23 11:09:05.90 spid25s Error: 5120, Severity: 16, State: 101.2013-05-23 11:09:05.90 spid25s Unable to open the physical file "F:\New folder\WebMail\App_Data\HelpDesk.mdf". Operating system error 3: "3(The system cannot find the path specified.)".2013-05-23 11:09:06.16 spid25s Error: 17207, Severity: 16, State: 1.2013-05-23 11:09:06.16 spid25s FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'F:\New folder\WebMail\App_Data\HelpDesk_log.ldf'. Diagnose and correct the operating system error, and retry the operation.2013-05-23 11:09:06.18 spid25s File activation failure. The physical file name "F:\New folder\WebMail\App_Data\HelpDesk_log.ldf" may be incorrect.2013-05-23 11:09:06.21 spid25s Starting up database 'MattTest'.2013-05-23 11:09:06.27 spid30s 1 transactions rolled forward in database 'C:\PROGRAM FILES (X86)\TELERIK\RADCONTROLS FOR ASP.NET AJAX Q1 2012\LIVE DEMOS\APP_DATA\TELERIK.MDF' (59). This is an informational message only. No user action is required.2013-05-23 11:09:06.30 spid7s 0 transactions rolled back in database 'C:\PROGRAM FILES (X86)\TELERIK\RADCONTROLS FOR ASP.NET AJAX Q1 2012\LIVE DEMOS\APP_DATA\TELERIK.MDF' (59). This is an informational message only. No user action is required.2013-05-23 11:09:06.30 spid7s Recovery is writing a checkpoint in database 'C:\PROGRAM FILES (X86)\TELERIK\RADCONTROLS FOR ASP.NET AJAX Q1 2012\LIVE DEMOS\APP_DATA\TELERIK.MDF' (59). This is an informational message only. No user action is required.2013-05-23 11:09:07.03 spid20s 1 transactions rolled forward in database 'projectsite' (62). This is an informational message only. No user action is required.2013-05-23 11:09:07.17 spid7s 0 transactions rolled back in database 'projectsite' (62). This is an informational message only. No user action is required.2013-05-23 11:09:07.17 spid7s Recovery is writing a checkpoint in database 'projectsite' (62). This is an informational message only. No user action is required.2013-05-23 11:09:07.23 spid16s 1 transactions rolled forward in database 'C:\PROGRAM FILES (X86)\TELERIK\RADCONTROLS FOR ASP.NET AJAX Q1 2012\LIVE DEMOS\APP_DATA\NORTHWIND.MDF' (58). This is an informational message only. No user action is required.2013-05-23 11:09:07.41 spid27s 1 transactions rolled forward in database 'Fisharoo' (64). This is an informational message only. No user action is required.2013-05-23 11:09:07.59 spid51 Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.2013-05-23 11:09:07.86 spid7s 0 transactions rolled back in database 'Fisharoo' (64). This is an informational message only. No user action is required.2013-05-23 11:09:07.86 spid7s Recovery is writing a checkpoint in database 'Fisharoo' (64). This is an informational message only. No user action is required.2013-05-23 11:09:08.01 spid18s 1 transactions rolled forward in database 'Geo' (65). This is an informational message only. No user action is required.2013-05-23 11:09:08.17 spid51 Using 'xpsqlbot.dll' version '2009.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.2013-05-23 11:09:08.33 spid19s 1 transactions rolled forward in database 'Minotaur' (69). This is an informational message only. No user action is required.2013-05-23 11:09:08.52 spid28s 1 transactions rolled forward in database 'Kentico' (70). This is an informational message only. No user action is required.2013-05-23 11:09:08.54 spid17s 1 transactions rolled forward in database 'Site' (72). This is an informational message only. No user action is required.2013-05-23 11:09:08.62 spid7s 0 transactions rolled back in database 'C:\PROGRAM FILES (X86)\TELERIK\RADCONTROLS FOR ASP.NET AJAX Q1 2012\LIVE DEMOS\APP_DATA\NORTHWIND.MDF' (58). This is an informational message only. No user action is required.2013-05-23 11:09:08.62 spid7s Recovery is writing a checkpoint in database 'C:\PROGRAM FILES (X86)\TELERIK\RADCONTROLS FOR ASP.NET AJAX Q1 2012\LIVE DEMOS\APP_DATA\NORTHWIND.MDF' (58). This is an informational message only. No user action is required.2013-05-23 11:09:08.62 spid7s Recovery completed for database C:\PROGRAM FILES (X86)\TELERIK\RADCONTROLS FOR ASP.NET AJAX Q1 2012\LIVE DEMOS\APP_DATA\NORTHWIND.MDF (database ID 58) in 1 second(s) (analysis 2 ms, redo 0 ms, undo 772 ms.) This is an informational message only. No user action is required.2013-05-23 11:09:08.82 spid25s 1 transactions rolled forward in database 'MattTest' (76). This is an informational message only. No user action is required.2013-05-23 11:09:08.98 spid24s 1 transactions rolled forward in database 'C:\INETPUB\WWWROOT\SALESDASHBOARD\TELERIK.SALESDASHBOARD.WEB\APP_DATA\NORTHWIND.MDF' (66). This is an informational message only. No user action is required.2013-05-23 11:09:09.02 spid27s 0 transactions rolled back in database 'MattTest' (76). This is an informational message only. No user action is required.2013-05-23 11:09:09.02 spid27s Recovery is writing a checkpoint in database 'MattTest' (76). This is an informational message only. No user action is required.2013-05-23 11:09:09.02 spid27s Starting up database 'Cses'.2013-05-23 11:09:09.28 spid23s 1 transactions rolled forward in database 'C:\INETPUB\WWWROOT\SCHEDULEBUILDER\SCHEDULEBUILDER.WEB\APP_DATA\SCHEDULERDATA.MDF' (71). This is an informational message only. No user action is required.2013-05-23 11:09:09.29 spid30s 0 transactions rolled back in database 'Kentico' (70). This is an informational message only. No user action is required.2013-05-23 11:09:09.29 spid30s Recovery is writing a checkpoint in database 'Kentico' (70). This is an informational message only. No user action is required.2013-05-23 11:09:09.29 spid30s 0 transactions rolled back in database 'C:\INETPUB\WWWROOT\SALESDASHBOARD\TELERIK.SALESDASHBOARD.WEB\APP_DATA\NORTHWIND.MDF' (66). This is an informational message only. No user action is required.2013-05-23 11:09:09.30 spid30s Recovery is writing a checkpoint in database 'C:\INETPUB\WWWROOT\SALESDASHBOARD\TELERIK.SALESDASHBOARD.WEB\APP_DATA\NORTHWIND.MDF' (66). This is an informational message only. No user action is required.2013-05-23 11:09:09.30 spid30s 0 transactions rolled back in database 'Minotaur' (69). This is an informational message only. No user action is required.2013-05-23 11:09:09.30 spid30s Recovery is writing a checkpoint in database 'Minotaur' (69). This is an informational message only. No user action is required.2013-05-23 11:09:09.30 spid30s 0 transactions rolled back in database 'Site' (72). This is an informational message only. No user action is required.2013-05-23 11:09:09.30 spid30s Recovery is writing a checkpoint in database 'Site' (72). This is an informational message only. No user action is required.2013-05-23 11:09:09.30 spid30s Starting up database 'KenticoCMSMat'.2013-05-23 11:09:09.51 spid22s 0 transactions rolled back in database 'C:\INETPUB\WWWROOT\SCHEDULEBUILDER\SCHEDULEBUILDER.WEB\APP_DATA\SCHEDULERDATA.MDF' (71). This is an informational message only. No user action is required.2013-05-23 11:09:09.51 spid22s Recovery is writing a checkpoint in database 'C:\INETPUB\WWWROOT\SCHEDULEBUILDER\SCHEDULEBUILDER.WEB\APP_DATA\SCHEDULERDATA.MDF' (71). This is an informational message only. No user action is required.2013-05-23 11:09:09.51 spid22s Starting up database 'KenticoCMSMat1'.2013-05-23 11:09:09.80 spid19s Starting up database 'KenticoCMSSite'.2013-05-23 11:09:10.24 spid7s 0 transactions rolled back in database 'Geo' (65). This is an informational message only. No user action is required.2013-05-23 11:09:10.24 spid16s Starting up database 'FloodControl'.2013-05-23 11:09:10.29 spid7s Recovery is writing a checkpoint in database 'Geo' (65). This is an informational message only. No user action is required.2013-05-23 11:09:10.61 spid25s Starting up database 'briqs'.2013-05-23 11:09:10.75 spid7s Recovery completed for database Geo (database ID 65) in 2 second(s) (analysis 2 ms, redo 0 ms, undo 1849 ms.) This is an informational message only. No user action is required.2013-05-23 11:09:10.85 spid28s Starting up database 'JoeTest'.2013-05-23 11:09:10.96 spid24s Starting up database 'JSN'.2013-05-23 11:09:10.97 spid20s Starting up database 'jobbing'.2013-05-23 11:09:11.22 spid29s 1 transactions rolled forward in database 'C:\INETPUB\WWWROOT\RTA\APP_DATA\SITEFINITY.MDF' (75). This is an informational message only. No user action is required.2013-05-23 11:09:11.23 spid17s Starting up database 'CareerPath'.2013-05-23 11:09:11.37 spid7s 0 transactions rolled back in database 'C:\INETPUB\WWWROOT\RTA\APP_DATA\SITEFINITY.MDF' (75). This is an informational message only. No user action is required.2013-05-23 11:09:11.37 spid7s Recovery is writing a checkpoint in database 'C:\INETPUB\WWWROOT\RTA\APP_DATA\SITEFINITY.MDF' (75). This is an informational message only. No user action is required.2013-05-23 11:09:11.48 spid23s Starting up database 'H3WebDB'.2013-05-23 11:09:12.49 spid30s 1 transactions rolled forward in database 'KenticoCMSMat' (80). This is an informational message only. No user action is required.2013-05-23 11:09:12.65 spid29s Starting up database 'C:\INETPUB\WWWROOT\JOBCS\JSSKCS\APP_DATA\JSSKDB.MDF'.2013-05-23 11:09:12.76 spid7s 0 transactions rolled back in database 'KenticoCMSMat' (80). This is an informational message only. No user action is required.2013-05-23 11:09:12.76 spid7s Recovery is writing a checkpoint in database 'KenticoCMSMat' (80). This is an informational message only. No user action is required.2013-05-23 11:09:12.93 spid27s 1 transactions rolled forward in database 'Cses' (78). This is an informational message only. No user action is required.2013-05-23 11:09:13.14 spid22s 1 transactions rolled forward in database 'KenticoCMSMat1' (81). This is an informational message only. No user action is required.2013-05-23 11:09:13.31 spid7s 0 transactions rolled back in database 'Cses' (78). This is an informational message only. No user action is required.2013-05-23 11:09:13.31 spid7s Recovery is writing a checkpoint in database 'Cses' (78). This is an informational message only. No user action is required.2013-05-23 11:09:13.42 spid7s 0 transactions rolled back in database 'KenticoCMSMat1' (81). This is an informational message only. No user action is required.2013-05-23 11:09:13.42 spid7s Recovery is writing a checkpoint in database 'KenticoCMSMat1' (81). This is an informational message only. No user action is required.2013-05-23 11:09:13.50 spid20s 1 transactions rolled forward in database 'jobbing' (87). This is an informational message only. No user action is required.2013-05-23 11:09:13.52 spid7s 0 transactions rolled back in database 'jobbing' (87). This is an informational message only. No user action is required.2013-05-23 11:09:13.52 spid7s Recovery is writing a checkpoint in database 'jobbing' (87). This is an informational message only. No user action is required.2013-05-23 11:09:14.07 spid24s 1 transactions rolled forward in database 'JSN' (86). This is an informational message only. No user action is required.2013-05-23 11:09:14.15 spid25s 1 transactions rolled forward in database 'briqs' (84). This is an informational message only. No user action is required.2013-05-23 11:09:14.47 spid29s 1 transactions rolled forward in database 'C:\INETPUB\WWWROOT\JOBCS\JSSKCS\APP_DATA\JSSKDB.MDF' (90). This is an informational message only. No user action is required.2013-05-23 11:09:14.49 spid7s 0 transactions rolled back in database 'JSN' (86). This is an informational message only. No user action is required.2013-05-23 11:09:14.49 spid7s Recovery is writing a checkpoint in database 'JSN' (86). This is an informational message only. No user action is required.2013-05-23 11:09:14.59 spid7s 0 transactions rolled back in database 'C:\INETPUB\WWWROOT\JOBCS\JSSKCS\APP_DATA\JSSKDB.MDF' (90). This is an informational message only. No user action is required.2013-05-23 11:09:14.59 spid7s Recovery is writing a checkpoint in database 'C:\INETPUB\WWWROOT\JOBCS\JSSKCS\APP_DATA\JSSKDB.MDF' (90). This is an informational message only. No user action is required.2013-05-23 11:09:14.64 spid28s 1 transactions rolled forward in database 'JoeTest' (85). This is an informational message only. No user action is required.2013-05-23 11:09:14.72 spid16s 1 transactions rolled forward in database 'FloodControl' (83). This is an informational message only. No user action is required.2013-05-23 11:09:14.80 spid51 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.2013-05-23 11:09:14.98 spid19s 1 transactions rolled forward in database 'KenticoCMSSite' (82). This is an informational message only. No user action is required.2013-05-23 11:09:15.03 spid7s 0 transactions rolled back in database 'briqs' (84). This is an informational message only. No user action is required.2013-05-23 11:09:15.03 spid7s Recovery is writing a checkpoint in database 'briqs' (84). This is an informational message only. No user action is required.2013-05-23 11:09:15.12 spid51 Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.2013-05-23 11:09:15.27 spid23s 1 transactions rolled forward in database 'H3WebDB' (89). This is an informational message only. No user action is required.2013-05-23 11:09:15.27 spid29s 0 transactions rolled back in database 'FloodControl' (83). This is an informational message only. No user action is required.2013-05-23 11:09:15.27 spid29s Recovery is writing a checkpoint in database 'FloodControl' (83). This is an informational message only. No user action is required.2013-05-23 11:09:15.27 spid29s 0 transactions rolled back in database 'JoeTest' (85). This is an informational message only. No user action is required.2013-05-23 11:09:15.27 spid29s Recovery is writing a checkpoint in database 'JoeTest' (85). This is an informational message only. No user action is required.2013-05-23 11:09:15.92 spid17s 1 transactions rolled forward in database 'CareerPath' (88). This is an informational message only. No user action is required.2013-05-23 11:09:16.06 spid24s 0 transactions rolled back in database 'H3WebDB' (89). This is an informational message only. No user action is required.2013-05-23 11:09:16.06 spid24s Recovery is writing a checkpoint in database 'H3WebDB' (89). This is an informational message only. No user action is required.2013-05-23 11:09:16.06 spid24s 0 transactions rolled back in database 'CareerPath' (88). This is an informational message only. No user action is required.2013-05-23 11:09:16.06 spid24s Recovery is writing a checkpoint in database 'CareerPath' (88). This is an informational message only. No user action is required.2013-05-23 11:09:16.18 spid16s 0 transactions rolled back in database 'KenticoCMSSite' (82). This is an informational message only. No user action is required.2013-05-23 11:09:16.18 spid16s Recovery is writing a checkpoint in database 'KenticoCMSSite' (82). This is an informational message only. No user action is required.2013-05-23 11:09:16.18 spid16s Recovery completed for database KenticoCMSSite (database ID 82) in 2 second(s) (analysis 697 ms, redo 0 ms, undo 362 ms.) This is an informational message only. No user action is required.2013-05-23 11:09:16.19 spid7s Recovery completed for database briqs (database ID 84) in 2 second(s) (analysis 199 ms, redo 98 ms, undo 447 ms.) This is an informational message only. No user action is required.2013-05-23 11:09:18.83 spid51 Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.2013-05-23 11:09:19.06 spid51 Using 'xplog70.dll' version '2009.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.2013-05-23 11:09:19.34 spid31s 1 transactions rolled forward in database 'RTAFleet' (50). This is an informational message only. No user action is required.2013-05-23 11:09:19.52 spid7s 0 transactions rolled back in database 'RTAFleet' (50). This is an informational message only. No user action is required.2013-05-23 11:09:19.52 spid7s Recovery is writing a checkpoint in database 'RTAFleet' (50). This is an informational message only. No user action is required.2013-05-23 11:09:20.04 spid21s 1 transactions rolled forward in database 'ReplacementSchedule' (52). This is an informational message only. No user action is required.2013-05-23 11:09:21.09 spid21s 0 transactions rolled back in database 'ReplacementSchedule' (52). This is an informational message only. No user action is required.2013-05-23 11:09:21.09 spid21s Recovery is writing a checkpoint in database 'ReplacementSchedule' (52). This is an informational message only. No user action is required.2013-05-23 11:09:21.15 spid7s Recovery completed for database RTAFleet (database ID 50) in 2 second(s) (analysis 116 ms, redo 100 ms, undo 94 ms.) This is an informational message only. No user action is required.2013-05-23 11:09:21.28 spid21s Recovery completed for database ReplacementSchedule (database ID 52) in 1 second(s) (analysis 23 ms, redo 0 ms, undo 987 ms.) This is an informational message only. No user action is required.2013-05-23 11:09:21.29 spid7s Recovery is complete. This is an informational message only. No user action is required.2013-05-23 11:09:27.97 spid22s Common language runtime (CLR) functionality initialized using CLR version v2.0.50727 from C:\Windows\Microsoft.NET\Framework64\v2.0.50727\.2013-05-23 11:09:37.28 spid22s AppDomain 2 (mssqlsystemresource.sys[runtime].1) created.2013-05-23 11:24:35.87 Logon Error: 18456, Severity: 14, State: 58.2013-05-23 11:24:35.87 Logon Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: <local machine>]2013-05-23 11:26:40.70 Logon Error: 18456, Severity: 14, State: 58.2013-05-23 11:26:40.70 Logon Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: <local machine>]2013-05-23 11:26:45.95 Logon Error: 18456, Severity: 14, State: 58.2013-05-23 11:26:45.95 Logon Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: <local machine>]2013-05-23 11:30:04.29 Logon Error: 18456, Severity: 14, State: 58.2013-05-23 11:30:04.29 Logon Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: <local machine>]2013-05-23 11:30:06.91 Logon Error: 18456, Severity: 14, State: 58.2013-05-23 11:30:06.91 Logon Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: <local machine>]2013-05-23 11:36:03.18 spid51 Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.2013-05-23 11:36:03.21 spid51 FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.2013-05-23 11:36:04.82 spid51 Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.2013-05-23 11:36:04.83 spid51 FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.

[sys].[dm_os_volume_stats]

Posted: 23 May 2013 03:36 AM PDT

I'm working on collecting stats on my sql servers to better keep an eye on them, and there's a table that I'd like to have access to the information, however, when I run the script to do this I get an error:Script:SELECT DISTINCT ( [vs].[logical_volume_name] ) AS 'Drive' , [vs].[available_bytes] / 1048576 AS 'MBFree'FROM [sys].[master_files] AS f CROSS APPLY [sys].[dm_os_volume_stats]([f].[database_id], [f].[file_id]) AS vsORDER BY [vs].[logical_volume_name];Error:Invalid object name 'sys.dm_os_volume_stats'.This script works on some sql servers but not on others, I believe is the different version. I'd really like to run this on all my server. Is there a replacement on the RTM version that I can use?The version in which it works: Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)The version in which it doesn't work:Microsoft SQL Server 2008 R2 (RTM) - 10.50.1790.0 (X64) Apr 22 2011 11:55:34 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) (Hypervisor)Thank you.

MAXDOP settings for OLAP

Posted: 14 May 2013 12:27 AM PDT

Hello, Does anyone have any idea what is the better way to set MAXOP settings for OLAP system. Here is my environment info:SQLServer: 2008 R2LOGICAL CPU Count: 40Hyperthread ration : 10Physical CPU Count : 4Physical memory : 260 GBI have seen one of the forumale and not so sure is this right setting:--MAX DEGREE OF PARALLELISM FORUMLAE--'4' NUMBER OF PROCESSESSORS- 4/2 = 2select case when cpu_count / hyperthread_ratio > 2 then 2 else cpu_count / hyperthread_ratio end as optimal_maxdop_settingfrom sys.dm_os_sys_info;O/P: 2--Another formulae:declare @hyperthreadingRatio bitdeclare @logicalCPUs intdeclare @HTEnabled intdeclare @physicalCPU intdeclare @SOCKET intdeclare @logicalCPUPerNuma intdeclare @NoOfNUMA intselect @logicalCPUs = cpu_count -- [Logical CPU Count] ,@hyperthreadingRatio = hyperthread_ratio -- [Hyperthread Ratio] ,@physicalCPU = cpu_count / hyperthread_ratio -- [Physical CPU Count] ,@HTEnabled = case when cpu_count > hyperthread_ratio then 1 else 0 end -- HTEnabledfrom sys.dm_os_sys_infooption (recompile);select @logicalCPUPerNuma = COUNT(parent_node_id) -- [NumberOfLogicalProcessorsPerNuma]from sys.dm_os_schedulerswhere [status] = 'VISIBLE ONLINE' and parent_node_id < 64group by parent_node_idoption (recompile);select @NoOfNUMA = count(distinct parent_node_id)from sys.dm_os_schedulers -- find NO OF NUMA Nodes where [status] = 'VISIBLE ONLINE' and parent_node_id < 64-- Report the recommendations ....select --- 8 or less processors and NO HT enabled case when @logicalCPUs < 8 and @HTEnabled = 0 then 'MAXDOP setting should be : ' + CAST(@logicalCPUs as varchar(3)) --- 8 or more processors and NO HT enabled when @logicalCPUs >= 8 and @HTEnabled = 0 then 'MAXDOP setting should be : 8' --- 8 or more processors and HT enabled and NO NUMA when @logicalCPUs >= 8 and @HTEnabled = 1 and @NoofNUMA = 1 then 'MaxDop setting should be : ' + CAST(@logicalCPUPerNuma / @physicalCPU as varchar(3)) --- 8 or more processors and HT enabled and NUMA when @logicalCPUs >= 8 and @HTEnabled = 1 and @NoofNUMA > 1 then 'MaxDop setting should be : ' + CAST(@logicalCPUPerNuma / @physicalCPU as varchar(3)) else '' end as RecommendationsO/P: 2Not so sure, are these correct or not. Need suggestions please. Thanks

tempdb filling up !!

Posted: 23 May 2013 03:21 AM PDT

DBCC checkDB is filling up the tempDB. Weird fact is we have a database around 1 TB and its taking 20 GB of tempdb but for a 160 GB database its filling up 40GB+ tempdb and the checks are failing.As we all know there is a bug in 2008R2 and I cant estimate how much tempdb gonna grow. Monitored memory counters using perfmon and the server doesnt has any memory pressure. Appreciate any replies.

SCOM and SQL - Set and forget?

Posted: 22 May 2013 09:00 AM PDT

For you that use SCOM in your environment.How do you treat the SQL management packs?Do you let SCOM administrator just install the management pack and go with default options?Do you still set up alerts or trust the management pack to raise the alarms?Are you satisfied with SQL agent jobs just logging errors to eventlog where SCOM picks it up?Do you sit down with SCOM administrator and configure alarms and thresh-holds? (if yes, maybe you have a link or list of suggestions)Before I dive in to 90 pages of SCOM SQL management pack details, I would love to hear from you guys and how you treat SCOM vs SQL. Any best practise out there?

SQL Server Setup failure

Posted: 22 May 2013 07:22 AM PDT

I'm trying to install SQL Server 2008 R2 on Windows Server 2003 R2. As soon as I run the setup.exe I get the message "The application failed to initialize properly (0xc0000135). Click on OK to terminate the application".I have researched the error and all I can find is that I need .Net Framework installed which I do and I am still getting the same error. I tried repairing the .Net Framework versions but no luck. Any ideas on what it causing this issue?Thanks in advance!

TempDB requests capture

Posted: 22 May 2013 08:52 AM PDT

I am trying to capture all the requests hitting tempdb for a period of 24 hours. I tried to do it in sql server profiler and filter by by the databaseid and exclude all other rows, but not able to see the records hitting. While this is running this task is in suspended state in activity monitor.It is sql server 2008 R2 enterprise edition. Please suggest how can i capture the requests hitting tempdb.

SQL Agent Stopped

Posted: 22 May 2013 09:17 PM PDT

if not exists (select * from [master].dbo.sysprocesses where left(program_name,8)='SQLAgent')Begin EXEC msdb.dbo.sp_send_dbmail @profile_name ='Database Mail', @recipients ='email@id.com', @body ='Please look into the issue; Scheduled Jobs will not run if the SQL Server Agent Service remains stopped.', @subject ='SQL Agent Stopped,Please Check' ;End I am using above script to find out whether SQL Agent Stopped is stoped or Running , I want to add IP address and Server name in subject line.And I also want to monitor it for 40+ servers please help me for how above script can be used for monitoring the same .

stored proc taking more time when executed thru a job

Posted: 22 May 2013 10:47 AM PDT

I have a stored proc which collects the primary key values into temp table and delletes the rows from the main table by joining the rows of temp and main table on primary key. This stored proc is taking 2 hrs to run when setup as a job, but taking less time when ran through ssms. We have almost same settings. I tried to change the run as user but no change. Any suggestions??

Activity Monitor Empty

Posted: 10 May 2011 01:42 AM PDT

I need help and I'm ready to pull my hair out. I'm running SQL Server 20008.Microsoft SQL Server Management Studio 10.0.4000.0Microsoft Analysis Services Client Tools 10.0.4000.0Microsoft Data Access Components (MDAC) 6.1.7600.16385Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 8.0.7600.16385Microsoft .NET Framework 2.0.50727.4952Operating System 6.1.7600I'm receiving a blank screen when I open activity monitor. I can see the graphs which never refresh and the processes, resource waits, data file i/o, and recent expensive queries never populate.I have run this from my machine and the server. I have run it as myself (sysadmin) with windows authentication and as sa with server authentication. Even though my login has sysadmin privileges, I have explicitly given myself view server state. My refresh rate is 3 seconds. I have logged off and back on multiple times. I have not used the activity monitor since we upgraded to 2008.Does anyone have any idea why this tool is not populating.Thanks for any help you can give, Derise

Error: 17066, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.

Posted: 22 May 2013 05:21 PM PDT

Dear Sir,We are using sql server 2005 standard edition.Ram is 4GB.Today we got this below error.Error: 17066, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.Is this critical error.Could you please let me know what will be the root cause.

Edition upgraded after Maintenance plan was failed?

Posted: 22 May 2013 03:03 PM PDT

Hi,Recently upgraded done from standard edition to enterprise edition and SP3, after that Backup maintenance plan was corrupted then it was working after restart server again get it failed automatically after 3 or 4 days..Please suggestion me, if any need to apply cumulative update patch on SQL Server 2008 enterprise edition SP3Error messageExecuted as user: Servername\ExpSQLAgtSvc. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:10:01 AM Error: 2013-05-23 00:10:01.69 Code: 0xC0010018 Source: Description: Error loading value "<DTS:ConnectionManager xmlns:DTS="www.microsoft.com/SqlServer/Dts"> <DTS:Property DTS:Name="DelayValidation">0</DTS:Property> <DTS:Property DTS:Name="ObjectName">Local server connection</DTS:Property> <DTS:Property DTS:Name="DTSID">{11A126D7-9C4A-417A-9" from node "DTS:ConnectionManager". End Error Could not load package "Maintenance Plans\DB_Backup" because of error 0xC0010014. Description: One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors. Source: Started: 12:10:01 AM Finished: 12:10:01 AM Elapsed: 0.686 seconds. The package could not be loaded. The step failed.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog