[dba-SQLServer] Restoring a master db

Not identical but very close. I rolled my own. I didn't know there already
was one.

Arthur


On 4/12/07, Francisco Tapia <fhtapia at gmail.com> wrote:
>
> Arthur is this the revlogin script?
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
>
> The issue is that the server was down, and we couldn't load it at
> all... my sysadmin ended up redoing the entire system.  I restored the
> masterdb, but it may be a problem that the hashes that are saved in
> the sysuser table do not match the sid key from the OS since it was
> re-installed.
>
> --
> Francisco
>
> On 4/12/07, Arthur Fuller <fuller.artful at gmail.com> wrote:
> > This is a bit after the fact, I realize, but I have a script that will
> write
> > a script for you that records all the user info (logins, users,
> passwords,
> > etc.) so you can just run the script in future to avoid all the
> hand-work. I
> > don't have it with me at the moment, but I'll send it off-list if you
> like.
> >
> > Arthur
> >
> >
> > On 4/12/07, Francisco Tapia <fhtapia at gmail.com> wrote:
> > >
> > > Today I had a server go down, and my sysadmin had to rebuild the OS.
> > > After re-installing SS2k SP4, I went ahead and placed the server in
> > > single user mode and restored the original master db, and also went
> > > ahead and restored the msdb (for scheduling task I had).  One thing
> > > that did not go smoothly was the userid's that were restored via
> > > Master db restore.  i've had to re-create the windows users and simply
> > > re-type the Sql users.  I don't know why this happend, it almost was
> > > as if the users were orphaned.
> > >
> > > I'm posting here in case others have ran into this problem... I was
> > > quite at a loss since I didn't quite know what to even google for...
> > > the closest match was when you migrate users. and the point I guess is
> > > that I wasn't they were already on the same server (master db).
> > >
> > > any ideas?
> > >
> > > :) thanks,
> > >
> > > --
> > > -Francisco
> > > http://sqlthis.blogspot.com | Tsql and More...
> > > _______________________________________________
> > > dba-SQLServer mailing list
> > > dba-SQLServer at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > > http://www.databaseadvisors.com
> > >
> > >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> >
>
>
> --
> -Francisco
> http://sqlthis.blogspot.com | Tsql and More...
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>