error restoring a master db

[kodaksmile]

Hi All,

I am trying to restore a master database from one server to another and I get a blank error screen. I brought up sql in single user mode (sqlserv.exe -c -m) Then I went into enterprise manager and attempted to restore the master database. I have put the datafiles in the locations of the existing files, selected force over existing db. When I check the sql log it has two messages:

Error: 9001, Severity: 21, State: 1.
Error: 3151, Severity: 21, State: 0

Any suggestions?

 

[mutley1]

Hi Kodak,

What version of SQL are you on? When you say you put the datafiles in the same place, do you mean you are trying to restore from them, or are you defiantely using the backup file to restore from?

Mutley.

 

[JayKusch]

Morning Kodak.

As Mutley1 stated ... it seems you are relaying conflicting operations.

The statements of ....

"to restore the master database."
AND
"selected force over existing db."


indicate you are trying to RESTORE the Master DB from Tape of Disc where the statement of ...

"I have put the datafiles in the locations of the existing files,"


Indicates you are trying to CREATE/REPLICATE the Master DB from another server by ATTACHing the MDF and LDF files of the source Master DB.

So ... which one are we dealing with here?

Thanks

J. Kusch

 

[kodaksmile]

When you install sql server it automatically creates master hence there are already files in existance for the master db. I did the restore with the force option since the master db already exists. That was not the issue - I did get it resolved once I moved the model and msdb databases to the locations they were in on the other server I was doing the restore from.