Restore deleted user in SQL Server 2000

I need to know how to restore a deleted user. I do have copies of yesterday's backups, and can see the user listed there. However, I am afraid to restore all of the database (overwriting all of the table data), and would like to simply overwrite the user list. Is that possible? I know I could also just re-create the user, but I have run into one problem there. The deleted user is a special admin user whose login is listed as "<none>". Since I can't figure out how to create that (and would further have to re-create every jot and tittle of the user's specific permissions even if that worked), I would REALLY like to know how to get back just that user... or more likely, just the list of users we had as of yesterday (which is when the last backup was done).
denver5oAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

chapmandewCommented:
You can restore the database w/o overwriting the current database....just restore it w/ a different name.

restore database NewDatabaseName
from disk = 'c:\backupfile.bak'

from there, you can do whatever you need to w/ the users.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
denver5oAuthor Commented:
I have done the restoration as suggested. My problem is in creating that user with the right access/permissions/etc. in the current database. So to that extent, I'm not sure how I can do "whatever I need to w/ the users."
0
chapmandewCommented:
Is it on the same server?  Logins are stored at the server level, while users are stored in each db....
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.