Can't start/connect to SQL server 2000 1

[FancyPrairie]

SQL server was installed and our vendor had me create a few tables for him. After everything was created and the database populated, it was decided to move the databases to E: rather than where they are (C. Being a neewbie I searched the web and discovered that the first database that must be moved is the master database. But SQL wouldn't let me restore it to another partition (E. One internet hit I got said to move the master database from C: to E: and set the startup parameters to point to E:. Which is what I did (copied rather than moved, however). From that point on I can not connect to the database. I reset the parameters in the registry to point back to C: but still no luck.

The Event Viewer is displaying the following error

17204 :
FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.ldf for virtual device number (VDN) 2.

HELP! How do I fix this?

 

[mrdenny]

Does that file exist? If not copy the master.ldf to the c drive from the e drive.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[SQLBill]

It looks like you didn't move all the Master database files. There are at least two files; the database file (.mdf) and the log file (.ldf). Both are needed.
If you deleted the log file, you will have to attach using the sp_attach_single_db_file command. Check the BOL for more information.

-SQLBill

 

[FancyPrairie]

No, the ldf file doesn't exist. It didn't exist before (because I would have copied it). I have a mastlog.ldf but not a master.ldf

 

[mrdenny]

ok, sounds like something got screwed up when you changed the path in the registery. Go back in there to the regkey that you edited to tell it that it was on the c drive again, and change the filename for the ldf file back to mastlog.ldf. That "should" fix you back up.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[FancyPrairie]

Bless you mrdenny. I changed the registry so that the mastlog.ldf pointed to E (master.mdf still pointing to C). That didn't work. So I changed the registry so that maslog.ldf pointed back to C and that worked.

Now, I'm assuming what I did was correct in that, if I simply copy the master.mdf and mastlog.ldf to E and then set the startup parameters to point to E for both files, that should work. Is that correct?

 

[mrdenny]

Correct, that should do the trick. Then you can start to move the other databases over.

Denny

--Anything is possible. All it takes is a little research. (Me)