[dba-SQLServer] Restoring a master db

Arthur,

That would make a great addition to the DatabaseAdvisors "handy dandy code"
pages. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur
Fuller
Sent: Thursday, April 12, 2007 11:56 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [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
>
>
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com