|
Hi all, Very fresh MS SQL user calling. And I made horrible mistake, i am asking if possible to roll it back. I am running MS SQL 2008 Developers edition. What I accidentally did is deleting the very one DB user on my local server!!!!! I have several DBs so it is very important to get back to my previous state. Any chance? Please help me. Thank you.
(comments are locked)
|
|
Did you take a backup? Check "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA" (this may differ depending on your installation). It maybe that the mdf and ldf of the database are still in the data folder. If so you can try re-attaching the mdf My problem is I can not connect to the server itself. I have backups of my important DB, but not sure how can i use them when I can not connect to the DB server itself.
Mar 29 '10 at 06:50 AM
MpriorJ
OK.. Wrong end of the Stick... Are you a member of the "Local Admin" group? If so if you included this when you installed SQL then it should enable you in? Where did you delete the user from? Logins or the specific database?
Mar 29 '10 at 06:57 AM
sp_lock
Yeah, I know it is really bad! I am member of all the admin groups in the network, but i never manage to add any other users to my local sever (the one on my PC) except mine. When I was deleting the user, the idea was to delete it from specific DB, but by mistake I delete it from the local server. If this helps, i CAN connect to other MS SQL servers in the network, but not my local one. To cut the story, I was wondering if there is any way to rollback the deletion?
Mar 29 '10 at 07:05 AM
MpriorJ
Try the attached link.. It for 2005, but should work..
Mar 29 '10 at 07:18 AM
sp_lock
It work with little bit effort. Thank you very, very much. You saved me a lot of troubles! :)
Mar 29 '10 at 08:40 AM
MpriorJ
(comments are locked)
|
