Microsoft KB Archive/59902

{|
 * width="100%"|

INF: SQL Server Shuts Down When Master Database Is Reloaded

 * }

Q59902

-

The information in this article applies to:


 * Microsoft SQL Server for OS/2, version 4.2
 * Microsoft SQL Server version 4.2

-

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 : kbprogramming

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbZNotKeyword3 kbSQLServ420OS2