Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 472
  • Last Modified:

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).
0
denver5o
Asked:
denver5o
  • 2
1 Solution
 
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
 
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

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now