DR Testing

Hi all -
I am working with the DBA's to do some DR testing to see how to recover the
Master db if it became corrupted or unusable. We found a bunch of links
about doing this, but nothing seems to work. We used the SQL Server 2005
setup.exe method that MS seems to indicate is the way to do it, but it bombs
with no error and does nothing. We then just ran setup and went through the
steps, and when it does it's pre-installation checking, it complains that we
are trying to change the edition. I am guessing at this point this is
because we installed SP2, and are trying to recover using the non-SP CD.
Since MS does not allow slipstreaming service packs with SQL Server, how are
you supposed to do this?
Thanks for any info anyone can provide
MattHello Matt,
Here you go:
http://msdn2.microsoft.com/en-us/library/ms190679.aspx
http://msdn2.microsoft.com/en-us/library/ms175535.aspx
http://msdn2.microsoft.com/en-us/library/ms190190.aspx
http://msdn2.microsoft.com/en-us/library/ms191431.aspx
Cheers!
MB
"md" <someone@.microsoft.com> wrote in message
news:uDac9PDfHHA.5056@.TK2MSFTNGP02.phx.gbl...
> Hi all -
> I am working with the DBA's to do some DR testing to see how to recover
> the Master db if it became corrupted or unusable. We found a bunch of
> links about doing this, but nothing seems to work. We used the SQL Server
> 2005 setup.exe method that MS seems to indicate is the way to do it, but
> it bombs with no error and does nothing. We then just ran setup and went
> through the steps, and when it does it's pre-installation checking, it
> complains that we are trying to change the edition. I am guessing at this
> point this is because we installed SP2, and are trying to recover using
> the non-SP CD. Since MS does not allow slipstreaming service packs with
> SQL Server, how are you supposed to do this?
> Thanks for any info anyone can provide
> Matt
>|||Thanks MB. We had found some of these already, but not all. I forwarded them
to the DBA to take a look.
Thanks again
Matt
"MB" <MB@.MB.com> wrote in message
news:%23K4VhcDfHHA.4916@.TK2MSFTNGP06.phx.gbl...
> Hello Matt,
> Here you go:
> http://msdn2.microsoft.com/en-us/library/ms190679.aspx
> http://msdn2.microsoft.com/en-us/library/ms175535.aspx
> http://msdn2.microsoft.com/en-us/library/ms190190.aspx
> http://msdn2.microsoft.com/en-us/library/ms191431.aspx
> Cheers!
> MB
>
> "md" <someone@.microsoft.com> wrote in message
> news:uDac9PDfHHA.5056@.TK2MSFTNGP02.phx.gbl...
>sql