Rebuilding master

Hi,
Where do i find rebuildm.exe utility and how do I build master using this utility? Is it something like builmaster utility in Sybase??
Thanks in Advance
Jaideepthe file should be in the SQL install CD
-Vallabhai

Originally posted by jaideep
Hi,
Where do i find rebuildm.exe utility and how do I build master using this utility? Is it something like builmaster utility in Sybase??

Thanks in Advance

Jaideep|||Look under program files for MicrosoftSQLServer

You should have 80\Tools\Binn

Or do a Finf in Explorere...

Then go buy ADMIN 911 for SQL Server 2000 by Brian Knight

didn't I post this already?

It's like deja vu all over again...

Rebuilding master

Hi,
Where do i find rebuildm.exe utility and how do I build master using this utility? Is it something like builmaster utility in Sybase??
Thanks in Advance
JaideepOriginally posted by jaideep
Hi,
Where do i find rebuildm.exe utility and how do I build master using this utility? Is it something like builmaster utility in Sybase??

Thanks in Advance

Jaideep

Look in ..\Program files\MicrosoftSQL Server\80\Tools\Binn

Or do a find in explorer

And buy ADMIN 911 for SQL Server 2000 by Brian Knight..

Rebuild Master Error

I am performing a Rebiuld of the Master database using the REBUILDM utility on a SQL 2000 SP3 database which is clustered.
The utility starts off correclty, copying the correct MDF and LDF files to the hard drive, and the configuration bar goes across the screen 4 times, before giving the following error "Rebuild master failed with error -1".

I can't find anything on microsoft. I followed KB-298568 to perform this process, but the SQL Service will now not start as it cannot find the master, as it did not get rebuilt properly.

I have included screen shots of the error, in the zipped up word doc.It seems to be strange that it does it 4 times. Did you check whether the .mdf and .ldf were in the right directory?|||Originally posted by joejcheng
It seems to be strange that it does it 4 times. Did you check whether the .mdf and .ldf were in the right directory?

Yes, they appear in the correct directory, and are the correct size.|||When you run any sql utility or upgrade, a log file will be generated. In there, you can find detailed information regarding the error that you encountered. Check the directory \program files\microsoft sql server\mssql\install\.|||Also, try to copy the source to a local drive and run it from there rather than from a UNC location.|||I copied the files locally, and still got error -1|||Originally posted by joejcheng
When you run any sql utility or upgrade, a log file will be generated. In there, you can find detailed information regarding the error that you encountered. Check the directory \program files\microsoft sql server\mssql\install\.

There are not log files in this folder - only *.txt files that correspond to the *.gif files used for the Northwing and Pubs databases.|||I did some more investigation and found the cause of the problem.

When I initially installed SQL Server, I then used KB224071 to move the log files for the system databases to another drive, specifically for log files.

The location of the Master database files are written to the registry under HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\Pa rameters.

When Rebuildm runs it places all the files in the initial install location, and then tries to start the MSSQL Service, and fails as the path the the master database in the registry no longer matches the location of the log files where Rebuildm placed them - Hence error -1.

I manually moved the log file flat files to the correct drive, started the MSSQL Service and it all started up OK.|||Well, it would have been nice to know that you did move log files of systems databases to a different location :) Looks like we did all this brain-storming for nothing.|||Hi you fellow database teasers,

I think he did that in order to seperate data and log -- Performance.

But as I think it is not recommended to separate them for system databases.

Rebuild master db

I've recently had to rebuild the master database using the rebuild -m
utility. However, i've noticed some strange behaviours in my application
since in particular that a few errors are mssing from the sysmessages table.
What would be the preferred plan of action from here to get the system
tables back to a similar state before the rebuild ( I don't have a usable
backup of the master database i'm afraid)? Would it be to reapply the latest
SP?
I'm using SQL2k on a win2k box and prior to the rebuild of master, it was
patched up to SP3.
Thanks
RichYes, it is probable that a service pack adds rows to sysmessages. Do you
know the error number of the missing rows?
Another alternative is that you, or your application added those rows.
Error number < 50000 should mean they were added by SQL Server (service pack
is likely), > 50000 mean application.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Rich" <richbrownesq@.hotmail.com> wrote in message
news:%23UwsY15pDHA.744@.tk2msftngp13.phx.gbl...
> I've recently had to rebuild the master database using the rebuild -m
> utility. However, i've noticed some strange behaviours in my application
> since in particular that a few errors are mssing from the sysmessages
table.
> What would be the preferred plan of action from here to get the system
> tables back to a similar state before the rebuild ( I don't have a usable
> backup of the master database i'm afraid)? Would it be to reapply the
latest
> SP?
> I'm using SQL2k on a win2k box and prior to the rebuild of master, it was
> patched up to SP3.
> Thanks
> Rich
>|||There's 25 missing errors, ids ranging from 1960 -> 21520 and I think most
of these are sql server errors.
Would you recommend reapplying the SP or could i just insert the missing
rows? The issue i have with this is that there could be other modifications
to the system databases that i'm unaware of and wouldn't be fixed without
the latest SP.
However, when i run select serverproperty('productlevel'), it tells me SP3
is installed. Do you know if this will prevent me installing it again?
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:OeoPM75pDHA.4004@.TK2MSFTNGP11.phx.gbl...
> Yes, it is probable that a service pack adds rows to sysmessages. Do you
> know the error number of the missing rows?
> Another alternative is that you, or your application added those rows.
> Error number < 50000 should mean they were added by SQL Server (service
pack
> is likely), > 50000 mean application.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Rich" <richbrownesq@.hotmail.com> wrote in message
> news:%23UwsY15pDHA.744@.tk2msftngp13.phx.gbl...
> > I've recently had to rebuild the master database using the rebuild -m
> > utility. However, i've noticed some strange behaviours in my application
> > since in particular that a few errors are mssing from the sysmessages
> table.
> > What would be the preferred plan of action from here to get the system
> > tables back to a similar state before the rebuild ( I don't have a
usable
> > backup of the master database i'm afraid)? Would it be to reapply the
> latest
> > SP?
> >
> > I'm using SQL2k on a win2k box and prior to the rebuild of master, it
was
> > patched up to SP3.
> >
> > Thanks
> > Rich
> >
> >
>|||Yes, you should reapply the service pack. You are correct in other things
can be affected by the service pack, like bug fixes in system stored
procedures etc. The reason why you get sp3 is probably because the function
checks the .exe file and that didn't change because of your rebuild. I did a
search in the archives and came across below, amongst others (strange that I
did not find anything in BOL or KB that you need to reapply service pack).
http://tinyurl.com/ue4s
Or full URL:
http://groups.google.com/groups?q=rebuildm+%22service+pack%22+group:microsoft.public.sqlserver.*&hl=en&lr=&ie=UTF-8&group=microsoft.public.sqlserver.*&selm=4oheDoLQDHA.1724%40cpmsftngxa09.phx.gbl&rnum=5
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Rich" <richbrownesq@.hotmail.com> wrote in message
news:%234QgaA6pDHA.1672@.TK2MSFTNGP09.phx.gbl...
> There's 25 missing errors, ids ranging from 1960 -> 21520 and I think most
> of these are sql server errors.
> Would you recommend reapplying the SP or could i just insert the missing
> rows? The issue i have with this is that there could be other
modifications
> to the system databases that i'm unaware of and wouldn't be fixed without
> the latest SP.
> However, when i run select serverproperty('productlevel'), it tells me SP3
> is installed. Do you know if this will prevent me installing it again?
>
> "Tibor Karaszi"
<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> wrote in message news:OeoPM75pDHA.4004@.TK2MSFTNGP11.phx.gbl...
> > Yes, it is probable that a service pack adds rows to sysmessages. Do you
> > know the error number of the missing rows?
> >
> > Another alternative is that you, or your application added those rows.
> >
> > Error number < 50000 should mean they were added by SQL Server (service
> pack
> > is likely), > 50000 mean application.
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at:
> >
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> > "Rich" <richbrownesq@.hotmail.com> wrote in message
> > news:%23UwsY15pDHA.744@.tk2msftngp13.phx.gbl...
> > > I've recently had to rebuild the master database using the rebuild -m
> > > utility. However, i've noticed some strange behaviours in my
application
> > > since in particular that a few errors are mssing from the sysmessages
> > table.
> > > What would be the preferred plan of action from here to get the system
> > > tables back to a similar state before the rebuild ( I don't have a
> usable
> > > backup of the master database i'm afraid)? Would it be to reapply the
> > latest
> > > SP?
> > >
> > > I'm using SQL2k on a win2k box and prior to the rebuild of master, it
> was
> > > patched up to SP3.
> > >
> > > Thanks
> > > Rich
> > >
> > >
> >
> >
>sql

Rebuilbm not working

I don't have a new sql log.
I checked Server network utility and shared memory is enabled.
How can I verify if Shared Memory is loaded?
I rebooted the server and I get the same error.
Look at the SQL Server errolog and verify that Shared Memory is loaded. If
> not, reboot the machine. Rebuildm makes a shared memory connection so if
> shared memory is not loaded it will fail.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
You should have an errorlog file, each time SQL Server starts it creates such a file. The name of the file is
"errorlog".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"joj100" <joj100@.discussions.microsoft.com> wrote in message
news:6587E07D-DE45-4B81-BDB8-B9FC8C9DB0E7@.microsoft.com...[vbcol=seagreen]
> I don't have a new sql log.
> I checked Server network utility and shared memory is enabled.
> How can I verify if Shared Memory is loaded?
> I rebooted the server and I get the same error.
>
> Look at the SQL Server errolog and verify that Shared Memory is loaded. If

Rebuilbm not working

I don't have a new sql log.
I checked Server network utility and shared memory is enabled.
How can I verify if Shared Memory is loaded?
I rebooted the server and I get the same error.
Look at the SQL Server errolog and verify that Shared Memory is loaded. If
> not, reboot the machine. Rebuildm makes a shared memory connection so if
> shared memory is not loaded it will fail.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>You should have an errorlog file, each time SQL Server starts it creates suc
h a file. The name of the file is
"errorlog".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"joj100" <joj100@.discussions.microsoft.com> wrote in message
news:6587E07D-DE45-4B81-BDB8-B9FC8C9DB0E7@.microsoft.com...[vbcol=seagreen]
> I don't have a new sql log.
> I checked Server network utility and shared memory is enabled.
> How can I verify if Shared Memory is loaded?
> I rebooted the server and I get the same error.
>
> Look at the SQL Server errolog and verify that Shared Memory is loaded. I
f