Wednesday, March 21, 2012

rebuild master question

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 ? 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 rebuilm internally do ? ThanksFatima,
We would strongly advise that you reapply sp3a as well as the hotfixes.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

No comments:

Post a Comment