Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-12-16 : 07:58:45
|
| Sanjeev writes "I am trying to restore the master database and followed the following steps in SQL server 6.51. I run sqlservr.exe -m in command line to take SQL server in single user mode.2. I run "LOAD DATABASE master FROM MasterTest" in Query analyzer where MasterTest is logical name of the device.3.When I run above command I got the following message informing the connection is broken............................................................[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionCheckForData (CheckforData()).[Microsoft][ODBC SQL Server Driver][Named Pipes]General network error. Check your network documentation.Connection Broken .............................................................4.I can run all the command that is executable on single user mode except above command.Pls help me............Sanjeev" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-12-16 : 12:37:35
|
| I wonder if Named Pipes is the problem. Try connecting to the server using TCP/IP. You can do this by either setting the default to TCP/IP in the Client Network Utility program or by adding an entry for your server in that program as well. |
 |
|
|
|
|
|
Problem on single user mode