Friday, February 24, 2012

Database Recovery

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/en...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?

No comments:

Post a Comment