Rebuild Master Failed With Error 1

up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » Administration » REBUILDM.EXE failed with error -1 REBUILDM.EXE failed with error -1 Rate Topic Display Mode Topic Options Author Message Ken GrissomKen Grissom Posted Thursday, February 2, 2006 11:48 AM SSC-Enthusiastic Group: General Forum Members Last Login: Monday, October 17, 2016 9:50 AM Points: 103, Visits: 107 A little background:Just restore an entire machine from tape to a test environment for recovery testing. The backup included disk backups of the master database as well as the critical application databases.(Windows 2003 environment if that makes any difference. SQL Server was patched with SP3 on this machine)After the restore of course SQL server would not open because the master database was not restored.Ran RebuildM.EXE to rebuild the master database and got the message "Rebuild master failed with error -1". After that I was able to start the sqlservices in single user mode and restore the backup of the master.The Question:Do I need to be concerned with the error from rebuildm or is that somehow a successful erorr message? Post #255390 CTracyCTracy Posted Thursday, February 2, 2006 3:21 PM SSC-Enthusiastic Group: General Forum Members Last Login: Thursday, October 23, 2008 8:19 AM Points: 155, Visits: 134 I've heard of error messages occuring when restoring the master db from CD. It has something to do with the cd being read only media. So I make a note to only restore the master db from a hard drive by coping it off the cd first. Then I restore my master db from backup. I would think you'd be ok since you restored a version from backup after you had the error.-c Post #255466 Ken GrissomKen Grissom Posted Friday, February 3, 2006 6:54 AM SSC-Enthusiastic Group: General Forum Members Last Login: Monday, October 17, 2016 9:50 AM Points: 103, Visits: 107 Yep. I did copied the X86\Data folder off the CD onto d

Bao The other day I was trying to rebuild the master database for a SQL Server 2000 box. Everything was going well until the “Configuring Server” dialog popped up. The progress bar went across about 4 times and then an error message popped up. That's weird, I have rebuilt the master database a few times before and I have never encountered errors like this one. I looked for the error details and started with the cnfgsvr.out log http://www.sqlservercentral.com/Forums/Topic255390-5-1.aspx file located in C:\Program Files\Microsoft SQL Server\MSSQL\Install By looking at the log file, I could confirm the error, but it didn’t help to explain as why the connections had failed. So I ran eventvwr. One of the system log error mentioned something about MSSQLSERVER service failed to start. At that point, I was still not sure http://louiebao.net/rebuild-master-failed-with-error-1/ what’d happened, so I then ran services.msc and tried to start the MSSQLSERVER service manually. The error message matched what I had seen in the event viewer. Path? What path? Suddenly as if stricken by lightening, I noticed "Path to executable:" had the short file names for the path. The question became obvious, what was MICROS~3? A quick look in the explorer revealed 5 long name folders starting with the word “Microsoft”. MICROS~3 happened to be “Microsoft Office” instead of “Microsoft SQL Server”. Now the cause of the issue had been identified, I needed a way to work around it. For what I was doing at the time, I could not just reinstall SQL Server, therefore I decided to move the “80” and “mssql” folders into “Microsoft Office”. What I had effectively done was making C:\PROGRA~1\MICROS~3\MSSQL\binn\sqlservr.exe a valid path. Then I reran rebuildm.exe and as expected, everything worked. -oo00oo- For more info on short file names, please refer to the following Microsoft Knowledge Base articles:How Windo

Tried to start Sql (Does start of couse) 4. Run Rebuildm.exe ... and "Gonfigurating Sql server" message goes forever (I was waiting 1 1/2 hrs ... progress bar was running http://www.bigresource.com/MS_SQL-trying-to-rebuild-master-using-Rebuildm-exe-How-long-does-it-takes--Mbqxsju6.html ) Do I miss some some steps ? Tnanks View 3 Replies Similar Messages: Master Database Rebuild Takes Long Time Restoring Master After RebuildM Restoring Master After RebuildM Restoring Master After RebuildM BACKUP Job Takes http://www.mytechmantra.com/LearnSQLServer/Rebuild_System_Databases_In_SQL_Server_2008.html Too Long... SQL SP Takes Long Time To Run From VB.NET App How Long It Takes To Restore DB How To Rebuild The Master DB Long Query Takes Hours... Distributed Transaction Takes Far Too Long rebuild master Inserting Nothing Takes A Long Time SQL Server Takes Too Long To Run A Query Why Insert Takes A Long Time? Package Run Takes A Long.......... Time! DELETE Query Takes Long Rebuild Master Error Question About Master DB Rebuild No Ending Rebuild Master How To Rebuild The Master Database.? Shrink Database Takes Too Long (days) Update Takes Long Time To Complete!? Excel Export Takes Long Time Report Takes Long Time Loading rebuild master failed Vb.net And Reportingservices Setparameters Takes A Long Time Alter Column To Varchar(max) Takes To Long Failover Takes Long Due To Connection Blocking Rebuild Master? Error 9003 How To Rebuild Master Database In SQL 2005 SP2? Simple Select Query Takes A Very Long Time SQL Query From OLE DB Takes In SSIS Very Long While SQL Querfy Itself Is Very Easy Open Cube To Browse Takes Very Long Time Population Of Dimension Table Takes Long Time ADVERTISEMENT Master Database Rebuild Takes Long Time Dec 17, 2007 Hi All, I'm trying to rebuild my master database for sql server 2000. The process of rebuilding stared fine. But it is almost 4 hours since it got started. Performing it on a test system. Got doubtful and started the same on another test system. Issue is same and it is almost 2 hours. The Db size is less than 100 MB in both cases. IS IT NORMAL? I've tried the same for SQL SERVER 2005 and it got finished in couple of minutes. Please advise. View 5 Replies View Related Restoring Master After RebuildM Nov 19, 2001 View 1 Replies View Related Restoring Master After RebuildM Nov 19, 2001 View 1 Replies View Related Restoring Master After RebuildM Nov 19, 2001 HELPWe ar

unexpected shutdown of SQL Server 2008 database server has resulted in crashing of the SQL Server. I was unable to connect to SQL Server Instance and when I checked the SQL Server error logs, I could see the following entries “Restore the database from a full backup, or repair the database”, “Cannot recover the master database”. Now what do I do? I don’t have backups of SQL Server System databases! The questions which came to my mind were:- How can I bring the server back online at the earliest? Do I need to uninstall and then reinstall the SQL Server 2008? Today I realized how important it is to backup system databases across environments. Error Messages in SQL Server Error Logs During redoing of a logged operation in database 'master', an error occurred at log record ID (206:424:1). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database. Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online. My Environment Operating System: Windows Server 2008 R2 Enterprise Edition (64-bit) SQL Server: SQL Server 2008 SP1 Developer Edition (64-bit) Since I don’t have the system databases backups, the only option left for me was to rebuild the system databases in SQL Server 2008. So let’s go for it! 1. If you have SQL Server 2008 Installation media available then insert the same into the disk drive and search for Setup.EXE file or else search for Setup.EXE file which will be available locally on your server. The default location of Setup.EXE file on your server will be C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release. 2. Right click Command Prompt and select Run as administrator as shown in the below snippet to open up command prompt with elevated administrative privileges. Important Note The command prompt must be run under Administrator privileges to successfully rebuild the system databases. 3. In the command prompt window you need to enter the below mentioned command with appropriate values for each parameter and press enter to rebuild the system databases as per the syntax which is mentioned in MSDN. Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=InstanceName /SQLSYSADMINACCOUNTS=accounts [/SAPWD= StrongPassword][/SQLCOLLATION=CollationName] If you want to change the server