rebuild master again...  
Author Message
Göran





PostPosted: Sun Jul 18 23:04:27 CDT 2004 Top

SQL Server >> rebuild master again...

Posting this question again as I dont think its a tough one.. Must have
probably been missed before

Here goes...Using SQL 2K

Say i have SQL 2K with SP3a and the latest security patch installed and now
my master goes corrupt but I have a recent master db backup someplace.

If i rebuild master using the rebuildm utility, do i have to install the
SP3a and the security patch again before i try to restore the master db or
should i just restore master next and business as usual ? Just a lil
confused as the restore
master article mentions to ensure that the SQL installation is at the same
version as the master backup before restoring..

btw, what does the rebuildm internally do ? Thanks

SQL Server148  
 
 
Hari





PostPosted: Sun Jul 18 23:04:27 CDT 2004 Top

SQL Server >> rebuild master again... Hi,

Rebuildm.exe will rebuild all the system databases (Master, Model , MSDB).
So any changes which was done by
sp 3 or sp 3a will be lost when you rebuild the Master. So after the master
rebuild apply the service pack which matches the backup file (master dump).
After that apply the Restore database command to
restore the master database follwed with MSDB databse restore, Restore Model
if required.

what does the rebuildm internally do ?

It recreates the Master , MSDB and Model databases based on the one in SQL
server installation folder.

--
Thanks
Hari
MCDBA


> Posting this question again as I dont think its a tough one.. Must have
> probably been missed before
>
> Here goes...Using SQL 2K
>
> Say i have SQL 2K with SP3a and the latest security patch installed and
now
> my master goes corrupt but I have a recent master db backup someplace.
>
> If i rebuild master using the rebuildm utility, do i have to install the
> SP3a and the security patch again before i try to restore the master db or
> should i just restore master next and business as usual ? Just a lil
> confused as the restore
> master article mentions to ensure that the SQL installation is at the same
> version as the master backup before restoring..
>
> btw, what does the rebuildm internally do ? Thanks
>
>
>
>


 
 
Hassan





PostPosted: Sun Jul 18 23:26:12 CDT 2004 Top

SQL Server >> rebuild master again... Hari,

Are you sure that rebuildm would rebuild model and msdb too which means
clean out all my existing SQL jobs or DTS packages,etc ? Can you confirm ?
Have not seen any reference about messing up with model and msdb in books
online..



> Hi,
>
> Rebuildm.exe will rebuild all the system databases (Master, Model , MSDB).
> So any changes which was done by
> sp 3 or sp 3a will be lost when you rebuild the Master. So after the
master
> rebuild apply the service pack which matches the backup file (master
dump).
> After that apply the Restore database command to
> restore the master database follwed with MSDB databse restore, Restore
Model
> if required.
>
> what does the rebuildm internally do ?
>
> It recreates the Master , MSDB and Model databases based on the one in SQL
> server installation folder.
>
> --
> Thanks
> Hari
> MCDBA


> > Posting this question again as I dont think its a tough one.. Must have
> > probably been missed before
> >
> > Here goes...Using SQL 2K
> >
> > Say i have SQL 2K with SP3a and the latest security patch installed and
> now
> > my master goes corrupt but I have a recent master db backup someplace.
> >
> > If i rebuild master using the rebuildm utility, do i have to install the
> > SP3a and the security patch again before i try to restore the master db
or
> > should i just restore master next and business as usual ? Just a lil
> > confused as the restore
> > master article mentions to ensure that the SQL installation is at the
same
> > version as the master backup before restoring..
> >
> > btw, what does the rebuildm internally do ? Thanks
> >
> >
> >
> >
>
>


 
 
Hari





PostPosted: Mon Jul 19 01:02:14 CDT 2004 Top

SQL Server >> rebuild master again... HI Hassan,

Yes, it does that. You have to restore the MSDB to retrive back all the
Jobs, Alerts , DTS packages ....

Confirmation from books online:-

"Important The Rebuild Master utility rebuilds master completely. Because
the msdb and model system databases are rebuilt as well, it will normally be
necessary to restore backups of those databases. "


--
Thanks
Hari
MCDBA




> Hari,
>
> Are you sure that rebuildm would rebuild model and msdb too which means
> clean out all my existing SQL jobs or DTS packages,etc ? Can you confirm
?
> Have not seen any reference about messing up with model and msdb in books
> online..
>


> > Hi,
> >
> > Rebuildm.exe will rebuild all the system databases (Master, Model ,
MSDB).
> > So any changes which was done by
> > sp 3 or sp 3a will be lost when you rebuild the Master. So after the
> master
> > rebuild apply the service pack which matches the backup file (master
> dump).
> > After that apply the Restore database command to
> > restore the master database follwed with MSDB databse restore, Restore
> Model
> > if required.
> >
> > what does the rebuildm internally do ?
> >
> > It recreates the Master , MSDB and Model databases based on the one in
SQL
> > server installation folder.
> >
> > --
> > Thanks
> > Hari
> > MCDBA


> > > Posting this question again as I dont think its a tough one.. Must
have
> > > probably been missed before
> > >
> > > Here goes...Using SQL 2K
> > >
> > > Say i have SQL 2K with SP3a and the latest security patch installed
and
> > now
> > > my master goes corrupt but I have a recent master db backup someplace.
> > >
> > > If i rebuild master using the rebuildm utility, do i have to install t
he
> > > SP3a and the security patch again before i try to restore the master
db
> or
> > > should i just restore master next and business as usual ? Just a lil
> > > confused as the restore
> > > master article mentions to ensure that the SQL installation is at the
> same
> > > version as the master backup before restoring..
> > >
> > > btw, what does the rebuildm internally do ? Thanks
> > >
> > >
> > >
> > >
> >
> >
>
>