[dba-SQLServer] Restoring a master db

Francisco Tapia fhtapia at gmail.com
Thu Apr 12 12:02:46 CDT 2007


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...



More information about the dba-SQLServer mailing list