Wednesday, March 7, 2012

Database Restore caused production server reboot

I got a production server with the following hard ware software
Server: Dell PowerEdge 2950
Storage: FS SAN 650
Memory: 4GB
windows 2003 standard (sp1)
sql server 2005 standard (9.00.2153)
There are five user databases, their size range varies from 12GB to 15 GB
I wanted archived data from one of the databases, so started database
restore process from old backups that made server to freeze then rebooted it
automatically. I found the following messages in the event log. My question
is how a restore process will bring server shutdown. With the same memory
and i had 150 databases in dev environment and never got a server reboot
with database restore. Can you please let me know your expert ideas what
else might have caused the reboot if not the restore process.
Date 2/19/2008 11:15:48 AM
Log Windows NT (Application)
Source MSSQL$xxx
Category Logon
Event 3221242661
Computer xxxxxx
Message
SQL Server failed with error code 0xc0000000 to spawn a thread to process a
new login or connection. Check the SQL Server error log and the Windows
event logs for information about possible related problems. [CLIENT:
111.111.11.164]
Date 2/19/2008 11:22:09 AM
Log Windows NT (Application)
Source MSSQL$xxxxx
Category Logon
Event 3221242666
Computer xxxxxxx
Message
The server was unable to load the SSL provider library needed to log in; the
connection has been closed. SSL is used to encrypt either the login sequence
or all communications, depending on how the administrator has configured the
server. See Books Online for information on this error message: 0x2746.
[CLIENT: 111.111.111.5]
-- --
Thanks,
Subbu
Hi
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1308037&SiteID=1
http://www.sqlservermart.com/resources/SynAttackProtect.aspx
"Subbu" <subbudamireddy@.hotmail.com> wrote in message
news:%23g0IhlWdIHA.3400@.TK2MSFTNGP03.phx.gbl...
>I got a production server with the following hard ware software
> Server: Dell PowerEdge 2950
> Storage: FS SAN 650
> Memory: 4GB
> windows 2003 standard (sp1)
> sql server 2005 standard (9.00.2153)
> There are five user databases, their size range varies from 12GB to 15 GB
> I wanted archived data from one of the databases, so started database
> restore process from old backups that made server to freeze then rebooted
> it automatically. I found the following messages in the event log. My
> question is how a restore process will bring server shutdown. With the
> same memory and i had 150 databases in dev environment and never got a
> server reboot with database restore. Can you please let me know your
> expert ideas what else might have caused the reboot if not the restore
> process.
> Date 2/19/2008 11:15:48 AM
> Log Windows NT (Application)
> Source MSSQL$xxx
> Category Logon
> Event 3221242661
> Computer xxxxxx
> Message
> SQL Server failed with error code 0xc0000000 to spawn a thread to process
> a new login or connection. Check the SQL Server error log and the Windows
> event logs for information about possible related problems. [CLIENT:
> 111.111.11.164]
>
> ----
> Date 2/19/2008 11:22:09 AM
> Log Windows NT (Application)
> Source MSSQL$xxxxx
> Category Logon
> Event 3221242666
> Computer xxxxxxx
> Message
> The server was unable to load the SSL provider library needed to log in;
> the connection has been closed. SSL is used to encrypt either the login
> sequence or all communications, depending on how the administrator has
> configured the server. See Books Online for information on this error
> message: 0x2746. [CLIENT: 111.111.111.5]
> -- --
> Thanks,
> Subbu
>
>
>

No comments:

Post a Comment