Asrar Azmi
asked on
SQL Server 2008 Database some time down
Hi, Expert can you tell me why our sql server 2008 some time down, then need to restart it again , again ?
Please ensure that the services of Sql server are automatically started. You need to go to
services.msc
to check these.
services.msc
to check these.
Hi
For SQL 2008, use SQL Configuration Manager instead of services app, especially when changing the account SQL and Agent run under. Config Manager also changes some permission necessary for SQL - services doesn't do that.
Regards
David
For SQL 2008, use SQL Configuration Manager instead of services app, especially when changing the account SQL and Agent run under. Config Manager also changes some permission necessary for SQL - services doesn't do that.
Regards
David
You might have an application running in your environment that stops the server.
Personally, because I use my development computer for other purposes and need a lot of resources for these, I sometimes open and close the server through the application as needed during development. If that code goes into production, it can end up doing the same on the production server.
Personally, because I use my development computer for other purposes and need a lot of resources for these, I sometimes open and close the server through the application as needed during development. If that code goes into production, it can end up doing the same on the production server.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Okay, if you have restarted SQL, can you look for the log file called ErrorLog.1 It is in the log folder in the instance directory.
The last few lines should show the shutdown. What is above that.
HTH
David
PS It is fairly hard to understand what you are trying to say about what SQL does that you then need to restart it.
Do check that databases are on autoclose.