?
Solved

Restore deleted user in SQL Server 2000

Posted on 2008-10-28
3
Medium Priority
?
471 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 1500 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

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

771 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