I am working in Sql Server 2008. The Issue is when i restore the database the database users get disable i can map that particular user with the Login user. For mapping i have to remove the user from the database and then map the user.
Eg:- Database name :- Clv Database User :- Clv Server Loging :- Clv this user is mapped with the Clv Database Clv User
Then i took full backup of the Clv database. Now i want to change the server of the database so i restore the backup in new server. In new server i Create Clv login and trying to map it with the Clv database's Clv user but the error is there is already a Clv User so i delete the user of the database and then i map user again so its done on that way but i want to know that is there any other way out for this situation or there is only this wayout. Now when i restore the database the The Clv database User no longer mapped with the Clv Login. For to doing That i have to remove Clv database user first and the Map with Clv Login.
Is then any other solution??