Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
|
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 25th, 2007, 03:33 PM
Registered User
 
Join Date: Sep 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to v-manraj
Default restoring deleted logins in sql 2005

Hello,

I have accidentally deleted logins on my SQL Server 2005 Database.

Can you guide if there is a way to get these logins back in sql server 2005.

With 2000 we could have restored the master back and then got this back.

How do we get this done in sql server 2005



Manishankar Rajagopal
Analyst
Microsoft
 
Old September 26th, 2007, 02:10 PM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

You can do the same with SQL Server 2005 (restore the master db) but you lose any changes made to the master database since the last backup.

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html
 
Old September 26th, 2007, 03:52 PM
Registered User
 
Join Date: Sep 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to v-manraj
Default

Hello,

Thanks for your reply.

I started the server in single user mode and restored the master so all my logins were restored but the users that were also deleted were not restored automatically, Before that i had taken a back up of the User databases and then after the master DB was restored i restarted the SQL server normally and then restored the USer database one by one and all my users were back and they were properly mapped to the logins.

can you provide me some useful link which talks about the different objects that can be restored from master and objects most likely to be affected once the master is restored.

Thanks a million

Manishankar Rajagopal
Analyst
Microsoft





Similar Threads
Thread Thread Starter Forum Replies Last Post
reg conn to sql server 2005 from vb.net 2005.. veda SQL Server 2005 2 July 1st, 2008 12:16 AM
Upgrade 2000 DBs to 2005 or install SQL 2000/2005 cJeffreywang SQL Server ASP 0 February 13th, 2008 10:44 PM
Recovering accidentally deleted logins in sql serv v-manraj SQL Server 2000 0 September 25th, 2007 02:55 PM
Converting from MS SQL 2005 to Sql Epress edition saif44 SQL Language 0 February 16th, 2007 04:17 PM
SQL Server Logins nidgep Classic ASP Databases 2 June 20th, 2003 09:05 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.