Microsoft KB Archive/312537

= FIX: SQL Server Stops Unexpectedly During Restore =

Article ID: 312537

Article Last Modified on 4/25/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q312537



BUG #: 101115 (SQLBUG_70)



SYMPTOMS
If a restore operation is in progress on a SQL Server 7.0 server and at the same time a user opens or uses a SQL Server 2000 version of Enterprise Manager against the SQL Server 7.0 server, the SQL Server service may stop unexpectedly. The SQL Server error log does not give any indication as to why the SQL Server service stopped.



CAUSE
A deadlock occurs between the restore operation and the SQL statement issued by Enterprise Manager to list the databases when the database folder expands. SQL Server does not handle the deadlock correctly during a restore operation and an unhandled exception occurs, which stops the service.



RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 7.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

301511 INF: How to Obtain the Latest SQL Server 7.0 Service Pack

NOTE: The following hotfix was created prior to Microsoft SQL Server 7.0 Service Pack 4.

The English version of this fix should have the following file attributes or later:   Date         Time    Version    Size       File name    Platform

29/12/2000  22:41   7.00.976    4.81 MB   Sqlservr.exe   x86 29/12/2000  22:41   7.00.976   11.1  MB   Sqlservr.exe   Alpha

NOTE: Because of file dependencies, the most recent hotfix or feature that contains the preceding files may also contain additional files.



WORKAROUND
To work around this problem, use the SQL Server 7.0 version of Enterprise Manager to administer SQL Server 7.0 servers if you restore databases regularly.

If you still use the SQL Server 2000 version of Enterprise Manager, the fix discussed in the following Microsoft Knowledge Base article may reduce the chance of experiencing the problem because it reduces the amount of time SQL Server issues the SELECT FROM SYSDATABASES statement:

282416 FIX: Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes a Long Time



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Microsoft SQL Server 7.0 Service Pack 4.



MORE INFORMATION
You can see the deadlock if you run the SQL Profiler against the SQL Server 7.0 server and capture the Lock:Deadlock event when the problem occurs.

Additional query words: load restore dump backup

Keywords: kbbug kbfix kbsqlserv700presp4fix KB312537

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.