Solved

Restore deleted user in SQL Server 2000

Posted on 2008-10-28
3
463 Views
Last Modified: 2012-05-05
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).
0
Comment
Question by:denver5o
  • 2
3 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
ID: 22828485
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
 

Author Comment

by:denver5o
ID: 22833311
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
 
LVL 60

Expert Comment

by:chapmandew
ID: 22833323
Is it on the same server?  Logins are stored at the server level, while users are stored in each db....
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question