INF: SQL Server Shuts Down When Master Database Is Reloaded

ID: Q59902

The information in this article applies to:

SUMMARY

When the master database is reloaded from a dump, SQL Server will shut itself down automatically, forcing the user to restart SQL Server to implement the new master database. This is similar to the way changes take effect in CONFIG.SYS (although the operating system will not automatically reboot when CONFIG.SYS is changed). Any time you make changes to your CONFIG.SYS file, you must reboot your computer so these modifications will take affect.


MORE INFORMATION

When SQL Server shuts itself down, two messages are displayed: one message in the session running the console and the other message in the session running ISQL.

The message displayed in the session running the console is as follows:

Operating System Error:
Read failed with EOF on network pipe.
DB-Library: Unexpected EOF from SQL Server.

The following message is displayed in the session running ISQL:
DB-Library: Unexpected EOF from SQL Server.

These messages indicate that the named-pipe connection has been broken, which is true, because SQL Server has just shut itself down. At this point, SQL Server should be restarted, and any other required databases reloaded.

Additional query words: Dumping and Loading Windows NT 


Keywords          : kbprg SSrvServer SSrvWinNT 
Version           : 4.2 | 4.2
Platform          : OS/2 WINDOWS 
Issue type        :

Last Reviewed: March 9, 1999