October 11, 2011 at 5:53 am
Hello,
i'm new in this forum.
I have a question about the SQL Server 2008. Since 4 weeks my SQL Server 2008 is restarting hisself every 10minutes without an error.
Did someone have this problem too? I didn't find messages or informations in the log. So, the log tells me only, that the SQL Server service end the server and starts the server, but the log tells my why
can someone help me
October 11, 2011 at 5:55 am
I'd check for viruses (need to be directly logged in to see that). There was one with a similar "feature" a few years ago in xp.
I'd also check for a job or 3rd party app that might be connecting to the server.
Worst comes to worse you can always unplug the network cable so you know only the machine can affect itself into a shutdown.
October 11, 2011 at 6:35 am
Just checking that it's the entire SQL Server restarting, not just the database(s)... as that could be fairly easy to explain away (probably)
Are you able to post the informational messages you are receiving?
October 11, 2011 at 6:42 am
i have a log but the log is in german 😉
so i dont know if u can read this logfile.
October 11, 2011 at 7:10 am
have you checked the Windows event logs?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 7:16 am
ok, here is the logfile
Datum,Quelle,Schweregrad,Meldung
10/11/2011 15:12:21,spid51,Unbekannt,Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_enumerrorlogs'. This is an informational message only; no user action is required.
10/11/2011 15:12:21,spid51,Unbekannt,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
10/11/2011 15:09:47,spid7s,Unbekannt,Recovery is complete. This is an informational message only. No user action is required.
10/11/2011 15:09:47,spid13s,Unbekannt,Service Broker manager has started.
10/11/2011 15:09:47,spid13s,Unbekannt,The Database Mirroring protocol transport is disabled or not configured.
10/11/2011 15:09:47,spid13s,Unbekannt,The Service Broker protocol transport is disabled or not configured.
10/11/2011 15:09:47,spid10s,Unbekannt,Starting up database 'tempdb'.
10/11/2011 15:09:46,spid16s,Unbekannt,CHECKDB for database 'GData_Antivirus' finished without errors on 2011-02-12 10:00:02.673 (local time). This is an informational message only; no user action is required.
10/11/2011 15:09:46,spid15s,Unbekannt,CHECKDB for database 'DATABASE_X1' finished without errors on 2011-02-16 10:16:55.127 (local time). This is an informational message only; no user action is required.
10/11/2011 15:09:44,spid14s,Unbekannt,CHECKDB for database 'DATABASE_X2' finished without errors on 2011-02-16 10:16:51.853 (local time). This is an informational message only; no user action is required.
10/11/2011 15:09:32,spid10s,Unbekannt,Clearing tempdb database.
10/11/2011 15:09:30,spid16s,Unbekannt,Starting up database 'GData_Antivirus'.
10/11/2011 15:09:30,spid15s,Unbekannt,Starting up database 'DATABASE_X1'.
10/11/2011 15:09:30,spid13s,Unbekannt,Starting up database 'msdb'.
10/11/2011 15:09:30,spid14s,Unbekannt,Starting up database 'DATABASE_X2'.
10/11/2011 15:09:30,spid13s,Unbekannt,A new instance of the full-text filter daemon host process has been successfully started.
10/11/2011 15:09:30,Server,Unbekannt,SQL Server is now ready for client connections. This is an informational message; no user action is required.
10/11/2011 15:09:30,Server,Unbekannt,The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b<c/> 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.
10/11/2011 15:09:30,Server,Unbekannt,Dedicated admin connection support was established for listening locally on port 49322.
10/11/2011 15:09:30,Server,Unbekannt,Server is listening on [ 127.0.0.1 <ipv4> 49322].
10/11/2011 15:09:30,Server,Unbekannt,Server is listening on [ ::1 <ipv6> 49322].
10/11/2011 15:09:30,Server,Unbekannt,Server named pipe provider is ready to accept connection on [ \\.\pipe\MSSQL$MSSQL\sql\query ].
10/11/2011 15:09:30,Server,Unbekannt,Server is listening on [ 'any' <ipv4> 49321].
10/11/2011 15:09:30,Server,Unbekannt,Server is listening on [ 'any' <ipv6> 49321].
10/11/2011 15:09:30,Server,Unbekannt,A self-generated certificate was successfully loaded for encryption.
10/11/2011 15:09:29,spid7s,Unbekannt,Server name is 'SERVER\MSSQL'. This is an informational message only. No user action is required.
10/11/2011 15:09:29,spid10s,Unbekannt,Starting up database 'model'.
10/11/2011 15:09:29,spid7s,Unbekannt,The resource database build version is 10.50.1600. This is an informational message only. No user action is required.
10/11/2011 15:09:29,spid7s,Unbekannt,Starting up database 'mssqlsystemresource'.
10/11/2011 15:09:29,spid7s,Unbekannt,SQL Trace ID 1 was started by login "sa".
10/11/2011 15:09:29,spid7s,Unbekannt,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQL'.
10/11/2011 15:09:29,spid7s,Unbekannt,SQL Server Audit has started the audits. This is an informational message. No user action is required.
10/11/2011 15:09:29,spid7s,Unbekannt,SQL Server Audit is starting the audits. This is an informational message. No user action is required.
10/11/2011 15:09:29,spid7s,Unbekannt,Resource governor reconfiguration succeeded.
10/11/2011 15:09:28,spid7s,Unbekannt,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
10/11/2011 15:09:28,spid7s,Unbekannt,Starting up database 'master'.
10/11/2011 15:09:28,Server,Unbekannt,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.
10/11/2011 15:09:27,Server,Unbekannt,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.
10/11/2011 15:09:27,Server,Unbekannt,Using locked pages for buffer pool.
10/11/2011 15:09:27,Server,Unbekannt,Detected 4 CPUs. This is an informational message; no user action is required.
10/11/2011 15:09:27,Server,Unbekannt,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
10/11/2011 15:09:25,Server,Unbekannt,Registry startup parameters: <nl/> -d E:\Microsoft SQL Server\MSSQL10_50.MSSQL\MSSQL\DATA\master.mdf<nl/> -e E:\Microsoft SQL Server\MSSQL10_50.MSSQL\MSSQL\Log\ERRORLOG<nl/> -l E:\Microsoft SQL Server\MSSQL10_50.MSSQL\MSSQL\DATA\mastlog.ldf
10/11/2011 15:09:25,Server,Unbekannt,This instance of SQL Server last reported using a process ID of 3760 at 11.10.2011 15:09:24 (local) 11.10.2011 13:09:24 (UTC). This is an informational message only; no user action is required.
10/11/2011 15:09:25,Server,Unbekannt,Logging SQL Server messages in file 'E:\Microsoft SQL Server\MSSQL10_50.MSSQL\MSSQL\Log\ERRORLOG'.
10/11/2011 15:09:25,Server,Unbekannt,Authentication mode is MIXED.
10/11/2011 15:09:25,Server,Unbekannt,System Manufacturer: 'HP'<c/> System Model: 'ProLiant DL160 G5'.
10/11/2011 15:09:25,Server,Unbekannt,Server process ID is 2984.
10/11/2011 15:09:25,Server,Unbekannt,All rights reserved.
10/11/2011 15:09:25,Server,Unbekannt,(c) Microsoft Corporation.
10/11/2011 15:09:25,Server,Unbekannt,Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) <nl/>Apr 2 2010 15:48:46 <nl/>Copyright (c) Microsoft Corporation<nl/>Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6001: Service Pack 1)
10/11/2011 15:09:23,spid6s,Unbekannt,SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
10/11/2011 15:09:23,spid6s,Unbekannt,SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.
10/11/2011 15:09:15,spid11s,Unbekannt,Service Broker manager has shut down.
10/11/2011 15:02:25,spid53,Unbekannt,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.
10/11/2011 15:02:24,spid53,Unbekannt,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
10/11/2011 14:59:02,spid6s,Unbekannt,Recovery is complete. This is an informational message only. No user action is required.
10/11/2011 14:59:02,spid11s,Unbekannt,Service Broker manager has started.
10/11/2011 14:59:01,spid11s,Unbekannt,The Database Mirroring protocol transport is disabled or not configured.
10/11/2011 14:59:01,spid11s,Unbekannt,The Service Broker protocol transport is disabled or not configured.
10/11/2011 14:59:01,spid10s,Unbekannt,Starting up database 'tempdb'.
10/11/2011 14:59:01,spid16s,Unbekannt,CHECKDB for database 'GData_Antivirus' finished without errors on 2011-02-12 10:00:02.673 (local time). This is an informational message only; no user action is required.
10/11/2011 14:58:57,spid15s,Unbekannt,CHECKDB for database 'DATABASE_X1' finished without errors on 2011-02-16 10:16:55.127 (local time). This is an informational message only; no user action is required.
10/11/2011 14:58:55,spid14s,Unbekannt,CHECKDB for database 'DATABASE_X2' finished without errors on 2011-02-16 10:16:51.853 (local time). This is an informational message only; no user action is required.
10/11/2011 14:58:39,Server,Unbekannt,SQL Server is now ready for client connections. This is an informational message; no user action is required.
10/11/2011 14:58:39,Server,Unbekannt,The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b<c/> 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.
10/11/2011 14:58:39,Server,Unbekannt,Dedicated admin connection support was established for listening locally on port 49322.
10/11/2011 14:58:39,Server,Unbekannt,Server is listening on [ 127.0.0.1 <ipv4> 49322].
10/11/2011 14:58:39,Server,Unbekannt,Server is listening on [ ::1 <ipv6> 49322].
10/11/2011 14:58:39,Server,Unbekannt,Server named pipe provider is ready to accept connection on [ \\.\pipe\MSSQL$MSSQL\sql\query ].
10/11/2011 14:58:39,Server,Unbekannt,Server is listening on [ 'any' <ipv4> 49321].
10/11/2011 14:58:39,Server,Unbekannt,Server is listening on [ 'any' <ipv6> 49321].
10/11/2011 14:58:39,Server,Unbekannt,A self-generated certificate was successfully loaded for encryption.
10/11/2011 14:58:38,spid15s,Unbekannt,Starting up database 'DATABASE_X1'.
10/11/2011 14:58:38,spid16s,Unbekannt,Starting up database 'GData_Antivirus'.
10/11/2011 14:58:38,spid14s,Unbekannt,Starting up database 'DATABASE_X2'.
10/11/2011 14:58:38,spid11s,Unbekannt,Starting up database 'msdb'.
10/11/2011 14:58:37,spid11s,Unbekannt,A new instance of the full-text filter daemon host process has been successfully started.
10/11/2011 14:58:36,spid10s,Unbekannt,Clearing tempdb database.
10/11/2011 14:58:34,spid6s,Unbekannt,Server name is 'SERVER\MSSQL'. This is an informational message only. No user action is required.
10/11/2011 14:58:34,spid10s,Unbekannt,Starting up database 'model'.
10/11/2011 14:58:33,spid6s,Unbekannt,The resource database build version is 10.50.1600. This is an informational message only. No user action is required.
10/11/2011 14:58:33,spid6s,Unbekannt,Starting up database 'mssqlsystemresource'.
10/11/2011 14:58:33,spid6s,Unbekannt,SQL Trace ID 1 was started by login "sa".
10/11/2011 14:58:33,spid6s,Unbekannt,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQL'.
10/11/2011 14:58:33,spid6s,Unbekannt,SQL Server Audit has started the audits. This is an informational message. No user action is required.
10/11/2011 14:58:33,spid6s,Unbekannt,SQL Server Audit is starting the audits. This is an informational message. No user action is required.
10/11/2011 14:58:33,spid6s,Unbekannt,Resource governor reconfiguration succeeded.
10/11/2011 14:58:33,spid6s,Unbekannt,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
10/11/2011 14:58:31,spid6s,Unbekannt,Starting up database 'master'.
10/11/2011 14:58:30,Server,Unbekannt,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.
10/11/2011 14:58:29,Server,Unbekannt,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.
10/11/2011 14:58:29,Server,Unbekannt,Using locked pages for buffer pool.
10/11/2011 14:58:29,Server,Unbekannt,Detected 4 CPUs. This is an informational message; no user action is required.
10/11/2011 14:58:29,Server,Unbekannt,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
10/11/2011 14:58:29,Server,Unbekannt,Registry startup parameters: <nl/> -d E:\Microsoft SQL Server\MSSQL10_50.MSSQL\MSSQL\DATA\master.mdf<nl/> -e E:\Microsoft SQL Server\MSSQL10_50.MSSQL\MSSQL\Log\ERRORLOG<nl/> -l E:\Microsoft SQL Server\MSSQL10_50.MSSQL\MSSQL\DATA\mastlog.ldf
10/11/2011 14:58:29,Server,Unbekannt,This instance of SQL Server last reported using a process ID of 6376 at 05.10.2011 13:50:07 (local) 05.10.2011 11:50:07 (UTC). This is an informational message only; no user action is required.
10/11/2011 14:58:29,Server,Unbekannt,Logging SQL Server messages in file 'E:\Microsoft SQL Server\MSSQL10_50.MSSQL\MSSQL\Log\ERRORLOG'.
10/11/2011 14:58:29,Server,Unbekannt,Authentication mode is MIXED.
10/11/2011 14:58:29,Server,Unbekannt,System Manufacturer: 'HP'<c/> System Model: 'ProLiant DL160 G5'.
10/11/2011 14:58:29,Server,Unbekannt,Server process ID is 3760.
10/11/2011 14:58:29,Server,Unbekannt,All rights reserved.
10/11/2011 14:58:29,Server,Unbekannt,(c) Microsoft Corporation.
10/11/2011 14:58:29,Server,Unbekannt,Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) <nl/>Apr 2 2010 15:48:46 <nl/>Copyright (c) Microsoft Corporation<nl/>Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6001: Service Pack 1)
u can see that i started the server at 14:58:29 and then at 15:02:25 was the last activity. At 15:09:15 ended the sql server with "Service Broker shutdown"
What happend? and how can i solve the problem
October 11, 2011 at 7:20 am
I don't know about the shutdown, but I can say for sure that you're way overdue to run checkdb!
'GData_Antivirus' finished without errors on 2011-02-12 10:00:02.673 (local time).
That's before last valentines' day!
October 11, 2011 at 8:20 am
Perry Whittle (10/11/2011)
have you checked the Windows event logs?
?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 8:21 am
of course in the eventlog stays nothing about the sql server
October 11, 2011 at 8:27 am
in the windows eventlog stays only that the sql service browser was finished and a secon later the sql service browser started
October 11, 2011 at 8:43 am
So nothing at all then. No stop errors or application errors, etc.
Almost sounds like some ones pulling the plug out!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 8:46 am
no erros or warnings. only the information that the sql service browser has been finishe. and a second later starts the sql service browser
October 11, 2011 at 8:57 am
do you have antivirus software on the server, if so have you perfomed a system scan?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 8:59 am
of course. i have antivirus software and i did a system scan too
October 12, 2011 at 12:22 am
any ideas why my sql server restarts every time?
Viewing 15 posts - 1 through 15 (of 29 total)
You must be logged in to reply to this topic. Login to reply