Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
schuhtl
Posting Yak Master
102 Posts |
 Posted - 2004-10-28 : 10:50:19
|
| My company had a server crash and had to be rebuild from scratch. The on-call dba restored the databases in this order: user databases then the msdb. He did not restore the master. What ramifications does not restoring the master database have other than the loss of logins? Is it to late to restore the master? The dba said he tried to restore the master after I instructed him to and he said when he tried to go into single user mode the command window went blank and just hung. He was unable to use query analyzer to restore the database. What is the correct steps for restoring the master? Thanks |
|
|
CanadaDBA
583 Posts |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-28 : 22:48:32
|
quote:
Originally posted by schuhtl
My company had a server crash and had to be rebuild from scratch. The on-call dba restored the databases in this order: user databases then the msdb. He did not restore the master. What ramifications does not restoring the master database have other than the loss of logins? Is it to late to restore the master? The dba said he tried to restore the master after I instructed him to and he said when he tried to go into single user mode the command window went blank and just hung. He was unable to use query analyzer to restore the database. What is the correct steps for restoring the master? Thanks
IMHO, it's ok not to restore the master database, as everything will be rebuild while restoring the other databases, you can resolve orphaned users by sp_change_users_login--------------------keeping it simple... |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-29 : 06:44:27
|
| Were there any User SProcs etc. in the Master DB?If not then I agree with JenKristen |
|
|
|
|
|
|
Restoring Master Database