My database server crashed. I was able to recover the physical database
files, which a reattached to a new server with sp_attached_db. Now I got a
problem with recreating my login accounts. I got an error message that
<login_Account> al ready had a role in my database.
What is te proper way to recreate login accounts?You can use sp_change_users_login to remap:
http://msdn.microsoft.com/library/e..._ca-cz_8qzy.asp
-oj
"Arne" <Arne@.discussions.microsoft.com> wrote in message
news:15AD2C9D-48A8-4158-9834-594C9787CBB5@.microsoft.com...
> My database server crashed. I was able to recover the physical database
> files, which a reattached to a new server with sp_attached_db. Now I got a
> problem with recreating my login accounts. I got an error message that
> <login_Account> al ready had a role in my database.
> What is te proper way to recreate login accounts?
Friday, February 24, 2012
Database Recovery
Labels:
crashed,
database,
databasefiles,
microsoft,
mysql,
oracle,
physical,
reattached,
recover,
recovery,
server,
sp_attached_db,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment