Rebuilding Master DB - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Rebuilding Master DB

Author

Topic

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2007-02-05 : 15:41:36

Gurus
What are the prerequisites before we rebuild our master db with the rebuild utility in bin folder.Please help

Regards
Nitin

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-02-05 : 16:13:18

Do not cross post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78588

CODO ERGO SUM

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-02-06 : 02:08:22

Q. How do I rebuild the master database?

A: To rebuild the master database of a SQL Server 2000 instance, use the Rebuild Master Utility, Rebuildm.exe. You must rebuild the master database to fix corrupted master databases or to change collation settings for the instance. Detailed steps and information are available in the "How to rebuild the master database" topic in SQL Server Books Online. Also, be aware of the issue that is mentioned in the following article in the Microsoft Knowledge Base:
273572 (http://support.microsoft.com/kb/273572/) BUG: Rebuildm.exe utility stops responding when source directory is on a CD
http://support.microsoft.com/kb/257716

MohammedU

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2007-02-08 : 19:09:51

So you download the utility then run rebuild master....what would you do next...

Would all the databases user be ok...or
What would be the next steps
Thanks

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-02-09 : 01:49:49

If you have previous master backup... then restore master backup...
When you restore your other user database will showup because master keep track of all user databases...

Restore masb...

If you don't have the backup of master then you need to create logins...attach/create all user dbs..

MohammedU

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2007-02-09 : 08:16:41

Thanks so if got backup then restore this.....from backup.
(Do you have to put in single mode the entire server how do you do this).

Then if not got master......(do the rebuild utility command) then..
(I keep a script of all the logins every night ...run this and every thing is back to normal).

Great i write up my disaster plan.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources