February 2, 2006 at 11:48 am
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?
February 2, 2006 at 3:21 pm
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
February 3, 2006 at 6:54 am
Yep. I did copied the X86\Data folder off the CD onto disk and removed the read-only attribute before running REBUILDM.EXE as described in http://support.microsoft.com/default.aspx?scid=kb;en-us;273572
Ran the REBUILDM.EXE, selected that X86\data folder on disk, clicked on Rebuild and after REBUILDM.EXE ran for a bit, that's when I received the error message.
I do believe I am OK but just wanted to know 1) how to avoid this error if possible, 2) if anyone else had seen a similar issue.
Thanks
Ken
February 16, 2006 at 12:38 pm
I'm in the same boat you are, Ken. We've used rebuildm at least a hundred times on production servers and we've always been able to restore our data each time, but we always get the -1 error.
If anyone knows how to get rid of the error, I'm all ears.
May 8, 2007 at 8:12 am
Hi guys,
We are also using rebuildm.exe to rebuild the master db after a crash then we retore our master bd in single user mode. We notice that we got that "Rebuild Master failed with error -1" only when we are trying to restore our SQL 2 nodes Cluster with SQL 2000 Enterprise. All of our other server running on SQL 2000 Standard SP4 are allright and return no error while rebuilding master. Is that your case either?
I use that "read only thing" aswell but can't avoid this error message either way. We try to grab our sources file both on the network or locally on the server with Read only attribut to OFF.
I'm out of ideas to resolve this issue, can someone give me some more trail to follow on this one?
Thx!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply