Solved

Restore deleted user in SQL Server 2000

Posted on 2008-10-28
3
468 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to setup several different housekeeping processes for a 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…

790 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