November 11, 2009 at 5:13 pm
My sql server re starts every 4 hours, how can i fix this problem where do i go to check or configure the issue
November 11, 2009 at 10:23 pm
What does the Error Log Files show? Any information in them?
Do you see any peculiar activity that caused this. Since when did this restarting issue begin, did you change anything on the Server like any configurations or updates to the System etc...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 12, 2009 at 6:40 am
Is it just the SQL Server service that is restarting or is the entire server rebooting?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 12, 2009 at 9:43 am
The entire server reboots and then instance of sql server restarts
November 12, 2009 at 9:44 am
i dont know how to get to the error log files to see the problem could you tell me how to get to the error log files.
November 12, 2009 at 9:51 am
Well, the windows error log is available using the event viewer. Start -> All Programs -> Administrative Tools -> Event Viewer.
The SQL Server error logs can be found in SSMS/Enterpirse Manager under Server Name -> Management -> SQL Server Logs.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 12, 2009 at 11:50 am
If the entire Windows Machine reboots, have your System Engineers/ Admins not been able to find what's wrong with it, rather than a SQL guy trying to figure it out.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 12, 2009 at 2:40 pm
I agree, have your system admins look at the issue. It almost sounds like an issue where the system is running out of memory or is getting a critical error causing it to reboot. If you are certain that it is rebooting every four hours, then that should not be that hard to determine when to monitor the server for failures.
Joie Andrew
"Since 1982"
November 15, 2009 at 8:59 am
This looks like spam. An near exact copy-paste of part of the previous post, with advertising junk at the bottom.
In case it's not. Get your windows admins to look into the problem. A rebooting server is not a SQL Server problem.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply