| Author |
Topic |
|
jbezanson
Starting Member
35 Posts |
 Posted - 2005-12-10 : 16:05:19
|
| This is a problem I have never incountered before. It has happen 2 times this week.Our Sql Server 2000, on our live web server, keeps shutting itself off. The service is set to automatic. The server hasn't been rebooted this week, yet SQL Server has shut down 2 times this week.Any ideas on what this might be or how to fix it.We are running Windows Server 2003 (IIS6), dual xeon CPUs and 2Gb RAM.Other software running on the server is .Net Framework 1.1Other than that and virus protection(Symantec, I think) and LiveState to do backups there is nothing else installed.Thanks for the help.Justin Bezansonjbezanson@purplegorilla.com |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-12-10 : 16:12:52
|
| Make sure the Synamtec is excluding the file directories where you keep the data and log files. Are there any errors in the server app or system event logs? What about the SQL Server or SQL Server Agent logs?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
jbezanson
Starting Member
35 Posts |
Posted - 2005-12-11 : 07:47:51
|
| I am just the developer, but I will look at those logs Monday.Justin Bezansonjbezanson@purplegorilla.com |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-12-11 : 13:46:23
|
| Ok. Do you have a DBA or sysadmin? Mention the exclusions needed for the virus scan if you have one. That can really mess things up if it's not set correctly. Also, with LiveState, do you have it backing up the databases to backup files, is there a hook directly into SQL Server, or is it trying to actually backup the live database files?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-12-11 : 22:33:49
|
have you checked the sql logs and event logs?it's always better to start somewhere... hope this helps  --------------------keeping it simple... |
|
|
|
jbezanson
Starting Member
35 Posts |
Posted - 2005-12-12 : 09:25:45
|
| I have checked the logs. Nothing sems suspicous...I think I have tracked down the problem.Our sysadmin has changed the way our webserver does backups (right around the same time this problem arose) so I will be seeing what he has been doing and hopefully elimanate this problem.thanks for all your help.Justin Bezansonjbezanson@purplegorilla.com |
|
|
|
jbezanson
Starting Member
35 Posts |
Posted - 2005-12-12 : 09:35:26
|
| Found the problem...looking deeper in to the System Event Logs showed that LiveState was indeed the problem.We have it setup to shutoff the SQL Server service before a LiveState backup then when the backup is complete it is to turn the SQL Server service back on...both times that sql server didn't come back on was due to a LiveState error...liveState never got to finish so it couldn't turn SQl server back on.Justin Bezansonjbezanson@purplegorilla.com |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-12 : 14:33:12
|
Seems like a good reason not to use LiveState backup  Can't you just backup to files on disk, and let "LiveState backup" back those up?Kristen |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-12-12 : 17:02:28
|
| Yeah, that's a BAD backup program. lol It probably cannot read open files. At that point, it would have limited use backing anything. Have they actually tried restoring the entire environment from the backups it makes?Look at the recommendations I originally made on setting up your backups.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
Sql Server service shutting down