Databases shutting down

Every night my sql databases are shutting down. I can restart them and they function perfectly

One for Rightfax and one is Blackberry server
danhartkeAsked:
Who is Participating?
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Yes, then Windows Update should be the reason for that.
Applying Service pack manually should fix it.
0
 
Rob KnightConsultantCommented:
Hi,

Is your backup solution programatically shutting them down in order to back them up?

Regards,

RobMobility.
0
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Seems like Windows update is automatically trying to apply Service packs for SQL Server 2005. ( Hope you have SQL Server 2005).
Apply the SP4 manually for SQL Server 2005 or SP2 for SQL Server 2008 to fix the issue.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
danhartkeAuthor Commented:
no it is not
0
 
danhartkeAuthor Commented:
I know that windows update fails to install that service pack. I will download the service pack manually and try to install it.
0
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Kindly let me know the Service pack information of your existing instance by running this query:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

>> I can restart them and they function perfectly

Kindly let me know whether it is your Database or your SQL Server service.
If it is database, then make sure that Auto-Close property is set to False for those particular databases.( Right click your Database name  -> Choose Properties -> Options -> Check Auto Close property)
0
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> I know that windows update fails to install that service pack. I will download the service pack manually and try to install it.

Yes, this is what I asked you to check earlier.
And this would cause your services to shut down automatically.
0
 
danhartkeAuthor Commented:
it is the sequel server service that is shutting down
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.