Restore user id - Dev Shed

Dev Shed Forums Sponsor:

Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now!

March 7th, 2004, 09:38 PM

wingschai

Registered User

Join Date: Jul 2003

Location: Malaysia

Posts: 10

Time spent in forums: < 1 sec
Reputation Power: 0

Restore user id

Hi there,

I using MSSQL 2000 Standard Edition. I perform full database backup on Server A and restore to Server B with same Database name, location, etc.

After restore the database, the tables, data is ok but not the user id. I look at the security - logins and can't find the user name but exist in the database I restore.

In order for the user id to access back the database, I need to delete the user id in the database I restore and recreate back and set the permissions again.

It is any ways to restore the database which includes the user id also?

Thanks

Wings

Viewing: Dev Shed Forums > Databases > MS SQL Development > Restore user id

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump

Get Flash