[dba-SQLServer] Restoring a master db

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