Re: Moving databases to a new location in SQL Server 2000 Cluster -
05-23-2008
, 01:26 AM
Perhaps you don't point to the correct place for master in the registry? I'm not sure, though, since
I can't say 100% it is the master database it complaint over. I suggest you check out the errorlog
file. Also, if you are on 2005, then use the instructions in Books Online (updated version) instead
of 224071.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Eugene" <ETsipis (AT) gmail (DOT) com> wrote
I moved my master DB as per KB 224071. and now my SQL server does not
start. in the application logs I get 3 entries (see below).
From what I have seen on these errors so far, it is that MS article is
missing something. Anyone have any ideas on how to fix this? I am in a
failover cluster so registry editing is not as simple as in a stand
alone machine.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 05/22/2008
Time: 11:13:43 AM
User: N/A
Computer: WH1
Description:
17207 :
udopen: Operating system error 3(The system cannot find the path
specified.) during the creation/opening of physical device .
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 37 43 00 00 10 00 00 00 7C......
0008: 04 00 00 00 57 00 48 00 ....W.H.
0010: 31 00 00 00 07 00 00 00 1.......
0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
0020: 65 00 72 00 00 00 e.r...
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 05/22/2008
Time: 11:13:43 AM
User: N/A
Computer: WH1
Description:
17204 :
FCB::Open failed: Could not open device for virtual device number
(VDN) 2.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 34 43 00 00 10 00 00 00 4C......
0008: 04 00 00 00 57 00 48 00 ....W.H.
0010: 31 00 00 00 07 00 00 00 1.......
0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
0020: 65 00 72 00 00 00 e.r...
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 05/22/2008
Time: 11:13:43 AM
User: N/A
Computer: WH1
Description:
18052 :
Error: 5105, Severity: 16, State: 4.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 84 46 00 00 10 00 00 00 "F......
0008: 04 00 00 00 57 00 48 00 ....W.H.
0010: 31 00 00 00 07 00 00 00 1.......
0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
0020: 65 00 72 00 00 00 e.r... |