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 ? ThanksHi,
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
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OWpYUePbEHA.1548@.TK2MSFTNGP12.phx.gbl...
> 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,
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..
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eP88VbUbEHA.1152@.TK2MSFTNGP09.phx.gbl...
> 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
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:OWpYUePbEHA.1548@.TK2MSFTNGP12.phx.gbl...
> now
or[vbcol=seagreen]
same[vbcol=seagreen]
>|||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
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:eeZJHiUbEHA.808@.tk2msftngp13.phx.gbl...
> 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..
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:eP88VbUbEHA.1152@.TK2MSFTNGP09.phx.gbl...
MSDB).[vbcol=seagreen]
> master
> dump).
> Model
SQL[vbcol=seagreen]
have[vbcol=seagreen]
and[vbcol=seagreen]
he[vbcol=seagreen]
db[vbcol=seagreen]
> or
> same
>sql