Sql Restarts
Apr 12, 2007
I am new to ms sql server, so here's my question...
A customer's server that has ms sql says that their sql database restarts several times a day, and they thought there was some setting that you can set to change this behavior. They prefer the database to never restart.
I tried to find information doing some google searches, but was unsuccessful.
This is a windows 2003 server running ms sql 2000. I believe the ms sql 2000 is up to date on any patches (but not 100% certain). The windows 2003 server is kept up to date on patches.
Any insights on this?
Scott
View 5 Replies
May 31, 2007
Hi, SQL Server restarted multiple times a few minutes ago because of an exception and a dump was produced... Its on SP3 (Build 760)
SqlDumpExceptionHandler: Process 5212 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 05/31/07 14:54:58 spid 88
*
* Exception Address = 0044D18D (CSQLStrings::CbGetChars + 000003C2 Line 0+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000A2C
I did not find any information in KBs regarding CSQLStrings::CbGetChars.
If anyone had come across this before, please let me know.
Thanks,
Siri.
View 1 Replies
View Related
Feb 3, 2003
Has anyone seen this kind of error message? I pulled it from the SQL Server Logs. In this occurance the error occurs at 1:18am, my jobs begin to fail thereafter, and then the SQL Server Services auto restarts at 3:14am.
2003-01-24 01:18:00.15 server Error: 17882, Severity: 18, State: 1
2003-01-24 01:18:00.15 server Error accepting connection request via Net-Library 'SSNETLIB'. Execution continuing..
2003-01-24 01:18:00.15 server Error: 17059, Severity: 18, State: 0
2003-01-24 01:18:00.15 server Operating system error 1: Incorrect function...
I presume that the SQL Service and/or Server Agent becomes disfunctional, then the SQL Server Service restarts itself and everything is fine again. Once the SQL Server Service comes back up I get notifications that jobs failed, between the time from the error to the restart, and then I can restart the any failed jobs just fine. Also, during that time NetIQ does not think the SQL Service is down so it does not send out any Service outage notifications.
Another tid bit of info is that this server is dedicated to SQL Server 2000 Enterprise and has 5GB of memory with AWE enabled.
I think it could possibly be a memory leak but am not sure. Any help would be greatly appreciated. Thanks.
View 5 Replies
View Related
Mar 14, 2013
If I close SSMS, it restarts itself as if it crashed and trying to restore itself. Even if I hit cancel as it's restarting, it will restart itself yet again. This happens twice. what's causing this?
View 12 Replies
View Related
Dec 11, 2014
I'm using ssms 2014, but got the same problem with 2012. I use ssms almost entirely on remote desktop sessions ( Windows 7, Server 2008R2, Server 2012 ). It may be related to having filtered job activity monitor windows open for hours, but about once per day ssms fails, and has to restart. Upon resuming usually only one of several queries is restored.
View 8 Replies
View Related
Apr 17, 2007
We are using Reporting Services 2000.
The print button that is present in the browser is working just fine for some users.
But some users are complaining that on clicking the print button their system restarts.
Some other users are also getting the error "An error occurred during printing. (0x80004005)"
However on closing the browser and opening the report in it again this issue is resolved.
So, the main concern is "Restart of the machine on click of the PRINT icon in reports viewed in some application browser."
Please help!!
View 2 Replies
View Related
Jan 17, 2007
I have created a package that use SSIS check pointing for failure-retry mechanism. I knew that when this package fails, on restarting the package it starts from the task where it got failed.
Is it possible for me to override this on a custom condition and start the package at an earlier task where it executed successfully?
Ex:
Check pointing is enabled.
FTP task è Write to Staging Table è Write to Target table.
Assuming I am downloading XML file through FTP and writing to a table.
FTP Download is successful.
Read from XML file and write to Staging table task failed because of downloaded file is not a well formed XML.
Here, FTP task is completed successfully; it failed only in the second task. When I re-run the package; it starts from the second [Read from XML file and write to staging table] task because of check pointing.
Is it possible for me to restart from the FTP task on a custom condition where it executed successfully?
View 3 Replies
View Related
May 24, 2006
Whenever I restart the Sql Server Agent, it causes SQL Server to restart also - is this correct ? I thought the dependency was the other way around i.e. restarting SQL Server would cause the agent to restart ? Any insights gratefully accepted.
View 5 Replies
View Related
