October 11, 2009 at 2:21 am
Hi Iam trying to restore Master database from Varitas tool but my restoration was failed with below error......
--------------------------------------------------------------
TIMESTAMP 20091009194435
MASTERSERVER VMS-RMC301-VL150.EBR.DYNAMIC.IN.TELSTRA.COM.AU
CLIENT WSSANMGT0036
INSTANCE WSSANMGT0036
DATABASE master
OPERATION RESTORE
OBJECTTYPE DATABASE
STATUS -1
INFO ODBC message. ODBC return code <-1>, SQL State <08S01>, Message Text <[Microsoft][SQL Native Client]Shared Memory Provider: The pipe has been ended. >
INFO <[Microsoft][SQL Native Client]Communication link failure>
INFO Error found executing <restore database "master" from VIRTUAL_DEVICE='VNBU0-4820-2016' with blocksize = 65536, maxtransfersize = 65536, buffercount = 1, replace , recovery>
INFO ODBC message. ODBC return code <-1>, SQL State <08S01>, Message Text <[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.>
INFO <[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (recv()).>
INFO Unable to login into SQL instance <WSSANMGT0036\> as user <> using standard connection
INFO Error 64 has been returned from QuerySQLServerInfo
ENDOPER TRUE
----------------------------------------------------------------
Could you please help me and let me know how to i troubleshoot the restoration.i have started SQL in single user mode and try to restore of Master database.but i got above error.
October 11, 2009 at 12:31 pm
has anything else taken the single connection before the restore?. test by trying to connect via SQLcmd
---------------------------------------------------------------------
November 5, 2009 at 12:08 am
make sure the sql agent is disabled, that can take up a connection.
hope that helps,
Steve
November 29, 2009 at 4:03 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply