February 28, 2009 at 6:21 am
Hi all.
I have my database in ms sql server 2008.
I have created a database 'db1'.
I have created a login ABC with default database 'db1'.
After that I have created a user 'dbuser' with login 'ABC'.
After I restore the database with overwrite option, the user under Security show without login name.
plz suggest how should I restore the database so that the user under security shows the login name.
thx in advance....
February 28, 2009 at 11:41 am
as per my understanding, your db backup file does not have the user which is available in the restored database.
script out the users before restore the db and run the script after the DB restore.
I hope it will work.
Rajesh Kasturi
February 28, 2009 at 3:32 pm
or just use the stored procedure
sp_chane_users_login
to resync the server login and database user
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply