Rebuild Master

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » SQLServerCentral.com Announcements » Rebuild Master

Rebuild Master

Rate Topic

Display Mode

Topic Options

Author

Message

Site Owners

Posted Tuesday, April 22, 2008 12:15 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040, Visits: 1

Comments posted to this topic are about the item Rebuild Master

Post #488375

Rob Goddard

Posted Tuesday, April 22, 2008 2:41 AM

SSChasing 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

Dugi

Posted Tuesday, April 22, 2008 5:33 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252, Visits: 3,367

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

rlondon

Posted Tuesday, April 22, 2008 7:11 AM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 1:55 PM
Points: 417, Visits: 1,125

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

Tim Mitchell

Posted Tuesday, April 22, 2008 7:12 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 9:12 PM
Points: 1,034, Visits: 2,611

Jeez, this is the fourth QOD in a row that I've answered incorrectly.....

Tim Mitchell
SQL Server MVP
www.TimMitchell.net
@Tim_Mitchell

Post #488588

Yelena Varshal

Posted Tuesday, April 22, 2008 8:58 AM

Hall of Fame

Group: General Forum Members
Last Login: Monday, July 30, 2012 10:42 AM
Points: 3,434, Visits: 519

I would try to restore from the backup first

Regards,
Yelena Varshal

Post #488693

Markus

Posted Wednesday, April 23, 2008 5:52 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 8:39 AM
Points: 1,059, Visits: 2,263

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

scottm30

Posted Wednesday, April 06, 2011 7:42 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 9:00 PM
Points: 570, Visits: 342

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 »

Permissions