Microsoft KB Archive/129490

= BUG: Dumps to Multiple Tapes/Disks May Cause Unresponsiveness =

Article ID: 129490

Article Last Modified on 12/15/1999

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition

-



This article was previously published under Q129490



SYMPTOMS
In a database with a large table that has heavy updates being done to it, doing a dump to tape or diskette that spans multiple tapes/diskettes can cause SQL Server to become unresponsive. When you dump to tape, new logins may be allowed, but any queries issued by the new or existing logins will not return. This includes queries issued in other databases.

When you dump to diskettes, new logins may never complete the login process. Existing connections will not complete queries.

In both scenarios, the events never time out. These indications remain until the dump media is swapped after it becomes full. With tape, all events continue as soon as the new tape is installed, and the dump process is continued. With diskettes, the indications remain until the last diskette of the dump is in the drive and being used by the dump process.

If the dump process is canceled or interrupted, SQL Server could be left in the state described, requiring a reboot of the system in order to recover.



WORKAROUND
The best solution is to continue the dump process and let the process continue.



STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 4.21a. Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: dump Windows NT

Keywords: kbother KB129490

-

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

© Microsoft Corporation. All rights reserved.