dbTalk Databases Forums  

Moving databases to a new location in SQL Server 2000 Cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Moving databases to a new location in SQL Server 2000 Cluster in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #61  
Old   
Tibor Karaszi
 
Posts: n/a

Default 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...



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.