You are here: Re: Database restore « MsSQL Server « IT news, forums, messages
Re: Database restore

Posted by Erland Sommarskog on 06/30/05 00:44

jsfromynr (jatinder.singh@clovertechnologies.com) writes:
> I am trying to restore a database from backup on another system [my
> client's] but I had to follow some weired steps.
>
> Step 1. Restore the database from EM 's GUI.
> [Users as on My machine get restored but their logins are not
> activated. So I have to follow the next steps]
>
> sp_helpuser shows me the userName but null LoginName and
> DefaultDatabase
>
> Step 2. Create a new login , grant access to the DB
>
> Step 3. Then run the script to change the ownership from earlier DB
> user to new user.
>
> Step 4. In EM make new user as dbo.

Look at sp_change_users_login in Books Online.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация