April 5, 2006 at 9:13 am
Hi All! Ive been trying to restore the Master DB using SMO in my application. Im setting the SQL Server to Single User mode by shelling out "sqlservr.exe -m" in my code and then connecting to it via SMO. The problem is that when I call the actual sqlrestore function, I get a transport level error.
Ive also been checking the "sqlservr.exe -m" on a command window to see if there is anything wrong with it. Below is the output from that command:
C:\Program Files\Microsoft SQL Server\MSSQL\Binn>sqlservr.exe -c -m
2006-04-05 23:24:26.01 server Microsoft SQL Server 2000 - 8.00.760 (Intel X8
6)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2006-04-05 23:24:26.18 server Copyright (C) 1988-2002 Microsoft Corporation.
2006-04-05 23:24:26.24 server All rights reserved.
2006-04-05 23:24:26.29 server Server Process ID is 3908.
2006-04-05 23:24:26.34 server Logging SQL Server messages in file 'C:\Program
Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2006-04-05 23:24:26.45 server SQL Server is starting at priority class 'norma
l'(1 CPU detected).
2006-04-05 23:24:27.39 server SQL Server configured for thread mode processin
g.
2006-04-05 23:24:27.46 server Using dynamic lock allocation. [500] Lock Block
s, [1000] Lock Owner Blocks.
2006-04-05 23:24:27.81 spid3 Warning ******************
2006-04-05 23:24:27.84 spid3 SQL Server started in single user mode. Updates
allowed to system catalogs.
2006-04-05 23:24:27.92 spid3 Starting up database 'master'.
2006-04-05 23:24:28.34 server Using 'SSNETLIB.DLL' version '8.0.766'.
2006-04-05 23:24:28.49 spid5 Starting up database 'model'.
2006-04-05 23:24:28.59 spid3 Server name is 'LEO-VMHDS'.
2006-04-05 23:24:28.65 server SQL server listening on 172.16.169.212: 1433.
2006-04-05 23:24:28.73 server SQL server listening on 127.0.0.1: 1433.
2006-04-05 23:24:28.82 server SQL server listening on TCP, Shared Memory, Nam
ed Pipes.
2006-04-05 23:24:28.90 server SQL Server is ready for client connections
2006-04-05 23:24:28.93 spid3 Skipping startup of clean database id 4
2006-04-05 23:24:28.99 spid3 Skipping startup of clean database id 5
2006-04-05 23:24:29.06 spid3 Skipping startup of clean database id 6
2006-04-05 23:24:29.09 spid3 Skipping startup of clean database id 7
2006-04-05 23:24:29.12 spid3 Skipping startup of clean database id 8
2006-04-05 23:24:29.18 spid3 Skipping startup of clean database id 9
2006-04-05 23:24:29.23 spid3 Skipping startup of clean database id 10
2006-04-05 23:24:29.26 spid3 Skipping startup of clean database id 12
2006-04-05 23:24:29.31 spid3 Starting up database 'MyNetwork'.
2006-04-05 23:24:29.51 spid5 Clearing tempdb database.
2006-04-05 23:24:30.18 spid5 Starting up database 'tempdb'.
2006-04-05 23:24:30.35 spid3 Recovery complete.
2006-04-05 23:24:30.39 spid3 SQL global counter collection task is created.
2006-04-05 23:24:30.50 spid3 Launched startup procedure 'sp_MSrepl_startup'
2006-04-05 23:24:30.54 spid3 Launched startup procedure 'sp_MScleanupmergepu
blisher'
2006-04-05 23:24:30.92 spid52 Starting up database 'MyDatabase'.
2006-04-05 23:24:31.92 spid52 Starting up database 'MyNetwork'.
2006-04-05 23:24:32.15 spid52 Starting up database 'MyNetwork'.
And here it stops. Im not sure if this is ok or if there is something wrong with it. But it says that Recovery is complete so I thought it was just ok. But the funny thing is that there are other databases and they are not displayed... like MSDB for example...
I hope someone can help me on this cause I am now stumped and dont know how to proceed. Thanks for any help!
April 9, 2006 at 11:51 pm
Heh... turns out there was just a problem in resolving the hostnames with the ip address... weird... if im using the ip address I get 100% success rate but when im using the hostname or server name, I got a 0-10% chance of success in restoring master DB... I even edited the hosts file, rebooted and everything... but its still the same.... very weird..
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply