restoring system databases

I've been testing a new 2005 server. After the install, I backed up the
system databases. I've done a lot of junk testing stuff since then, and
now I'm wondering if I should do a restore of the system databases before I
put the machine into production. If so, which ones?If you want a clean start, consider running rebuildmaster - rerun setup with
rebuild flag.
e.g.
setup.exe REBUILDDATABASE=1
-oj
"HK" <replywithingroup@.notreal.com> wrote in message
news:BceXf.17733$WK1.10563@.tornado.socal.rr.com...
> I've been testing a new 2005 server. After the install, I backed up the
> system databases. I've done a lot of junk testing stuff since then, and
> now I'm wondering if I should do a restore of the system databases before
> I
> put the machine into production. If so, which ones?
>|||Does that put it into the same state as just after an install?
If I had a test database still showing, for example, would that disappear?
"oj" <nospam_ojngo@.home.com> wrote in message
news:e2GjwiUVGHA.5364@.tk2msftngp13.phx.gbl...
> If you want a clean start, consider running rebuildmaster - rerun setup
with
> rebuild flag.
> e.g.
> setup.exe REBUILDDATABASE=1
>
> --
> -oj
>
> "HK" <replywithingroup@.notreal.com> wrote in message
> news:BceXf.17733$WK1.10563@.tornado.socal.rr.com...
> > I've been testing a new 2005 server. After the install, I backed up
the
> > system databases. I've done a lot of junk testing stuff since then,
and
> > now I'm wondering if I should do a restore of the system databases
before
> > I
> > put the machine into production. If so, which ones?
> >
> >
>|||Correct. The system would look as if it's just installed.
Since the setup does not touch your user database, you can just reattach it
after the rebuild.
--
-oj
"HK" <replywithingroup@.notreal.com> wrote in message
news:0SnXf.18403$WK1.7806@.tornado.socal.rr.com...
> Does that put it into the same state as just after an install?
> If I had a test database still showing, for example, would that disappear?
>
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:e2GjwiUVGHA.5364@.tk2msftngp13.phx.gbl...
>> If you want a clean start, consider running rebuildmaster - rerun setup
> with
>> rebuild flag.
>> e.g.
>> setup.exe REBUILDDATABASE=1
>>
>> --
>> -oj
>>
>> "HK" <replywithingroup@.notreal.com> wrote in message
>> news:BceXf.17733$WK1.10563@.tornado.socal.rr.com...
>> > I've been testing a new 2005 server. After the install, I backed up
> the
>> > system databases. I've done a lot of junk testing stuff since then,
> and
>> > now I'm wondering if I should do a restore of the system databases
> before
>> > I
>> > put the machine into production. If so, which ones?
>> >
>> >
>>
>|||That's a neat trick. Thanks.
"oj" <nospam_ojngo@.home.com> wrote in message
news:OgXKirUVGHA.5900@.tk2msftngp13.phx.gbl...
> Correct. The system would look as if it's just installed.
> Since the setup does not touch your user database, you can just reattach
it
> after the rebuild.
> --
> -oj
>
> "HK" <replywithingroup@.notreal.com> wrote in message
> news:0SnXf.18403$WK1.7806@.tornado.socal.rr.com...
> > Does that put it into the same state as just after an install?
> >
> > If I had a test database still showing, for example, would that
disappear?
> >
> >
> > "oj" <nospam_ojngo@.home.com> wrote in message
> > news:e2GjwiUVGHA.5364@.tk2msftngp13.phx.gbl...
> >> If you want a clean start, consider running rebuildmaster - rerun setup
> > with
> >> rebuild flag.
> >>
> >> e.g.
> >> setup.exe REBUILDDATABASE=1
> >>
> >>
> >>
> >> --
> >> -oj
> >>
> >>
> >>
> >> "HK" <replywithingroup@.notreal.com> wrote in message
> >> news:BceXf.17733$WK1.10563@.tornado.socal.rr.com...
> >> > I've been testing a new 2005 server. After the install, I backed up
> > the
> >> > system databases. I've done a lot of junk testing stuff since then,
> > and
> >> > now I'm wondering if I should do a restore of the system databases
> > before
> >> > I
> >> > put the machine into production. If so, which ones?
> >> >
> >> >
> >>
> >>
> >
> >
>