Networks

Ask something
Question Locked

This is for Shellbot

0 helpful
15 replies

by cmiller5400

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
You may know this one... I have a server that has SQL2000 on it. The OS install was overwritten by mistake during a failed drive replacement. I don't have a backup of the master db, but the database itself is okay because it was on a separate RAID array. Is there a way to restore the users from the db into the master db?

15 replies

by bizzo

I'm sure Shellbot's too proud for this kind of charity.

Or maybe not!

by shellbot

:)

Not soemthing I've ever had to do.. I'm one of those peple who has backups of backups ]:)

by bizzo

All way above my head. :(

I just thought I'd jump in and see if he any spare thumbs. :D

by shellbot

never had to deal with that..I've always had a backup!

To be honest, I don't know... :(

Recreate the master and then attach the database?

http://articles.techrepublic.com.com/5100-10878_11-5025441.html

by Former member

http://www.dbarecovery.com/restoremasterdb.html#Requirements:

Please post back if you have any more problems or questions.

by shellbot

Any joy?

If not..can you clarify "don't have a backup of the master db, but the database itself is okay "

Did you lose the master Db or not?

by cmiller5400

I found a backup copy of the master db hidden away on a drive (whohoooooooo!!!!) But I still do not have the transaction logs for the database, they are gone forever (DAMN RAID array failures).... But from what I have read, that is not a major issue.

I am now restoring SQL server to the correct version to restore the master db now.

by shellbot

wish i was having a party time :(
got massive Db probs this morn.. :(

by jdclyde

the reply gets the post further up the list, huh?

Still waiting to hear if it worked or not.

[i](you have no idea about SQL, while I on the other hand have no thoughts about SQL)

by shellbot

I'm asking myself why i got into this line of work anyways.... :(

not having a great day

This discussion is closed to new replies.