Microsoft KB Archive/77171

{|
 * width="100%"|

PRB: Msg 3201 When Attempting to Dump or Load Database

 * }

Q77171

-

The information in this article applies to:


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

-

SYMPTOMS
If you try to dump or load a database when all user connections are in use, SQL Server returns the following error message:

Msg 3201, Level 16, State 1

Can't open dump device 'c:\sql\data\device.dmp', device

error or device off line.

In addition, the following error appears in the SQL Server error log:

dbsopen: no room in socket table

CAUSE
Each SQL Server dump device requires one user connection while a database dump or load is in progress. Thus, if the need for user connections is high, the occasional failure of a dump or load must be tolerated in order to accommodate more users.

WORKAROUND
If these errors occur, determine whether or not all of the user connections are currently being used. If this is the case, temporarily closing one user connection allows the dump or load to proceed. To avoid this situation in the future, either increase the number of user connections, or schedule database dumps and loads when the need for user connections is low.

Additional query words: dumping loading Windows NT

Keywords : kbother

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbZNotKeyword3 kbSQLServ420OS2