Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Rebuild Master Expand / Collapse
Author
Message
Posted Tuesday, April 22, 2008 12:15 AM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
Comments posted to this topic are about the item Rebuild Master
Post #488375
Posted Tuesday, April 22, 2008 2:41 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, May 24, 2013 5:20 AM
Points: 660, Visits: 558
I liked this question, because shamefully I didn't know that. :D

--------
I love deadlines. I like the whooshing sound they make as they fly by. -Douglas Adams
Post #488419
Posted Tuesday, April 22, 2008 5:33 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:51 AM
Points: 1,262, Visits: 3,422
Me too, I lose but I learn professional way thnx!
:P


============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #488504
Posted Tuesday, April 22, 2008 7:11 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, August 4, 2014 12:38 PM
Points: 417, Visits: 1,147
I selected the answer "run GUI from original CD...." Because from the following KB (http://msdn2.microsoft.com/en-us/library/ms144259.aspx#rebuilddatabase) it says:

To rebuild system databases for a default instance of SQL Server 2005 from the command prompt

1. Insert the SQL Server 2005 installation media into the disk drive.

2. Use the following syntax:
start /wait

None of the other options said to use the installation media.
Post #488587
Posted Tuesday, April 22, 2008 7:12 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 1:40 PM
Points: 1,045, Visits: 2,724
Jeez, this is the fourth QOD in a row that I've answered incorrectly.....



Tim Mitchell, SQL Server MVP
Independent Business Intelligence Consultant
www.TimMitchell.net
@Tim_Mitchell

Post #488588
Posted Tuesday, April 22, 2008 8:58 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, August 8, 2014 1:35 PM
Points: 3,475, Visits: 580
I would try to restore from the backup first


Regards,
Yelena Varshal

Post #488693
Posted Wednesday, April 23, 2008 5:52 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:16 AM
Points: 1,270, Visits: 2,784
If the master db is damaged SQL Server will not start so you can not restore the master db.

I did not know they sunsetted the rebuildm utility from 2000.



Post #489198
Posted Wednesday, April 6, 2011 7:42 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, December 3, 2013 4:40 PM
Points: 654, Visits: 375
I thought I'd nailed this one, but sadly was wrong. Nice to know, thanks for the great question.
Post #1089665
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse