Re: Moving SQL Server 2005 databases

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

If all the logins are successfully created by following the procedure you point to, the logins will connect with the users in the databases and the rights will be retained.

If any of the logins have server rights in addition to database rights, those will need to be scripted and reapplied. Rights such as VIEW SYSTEM STATE or membership in server roles such as serveradmin, etc.

RLF


"MRWildiac" <MRWildiac@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:111571B0-F9B6-45D8-934B-E51C15C3480D@xxxxxxxxxxxxxxxx
Hi

I'm about to move some databases between 2 SQL Server 2005 installations. I
plan to copy the databases manually, and then to move logins I plan to follow
the steps outlined in KB 918992 "How to tranfer the logins and the passwords
between instances of SQL Server 2005".
By doing this, do I have to perform aditional steps for users to have the
same rights on the databases on the new server? As far as I can recall this
is stored in the databases, so by following the steps in the article the
target server will be the same as the source when it comes to user rights in
the database., correct?


.

Relevant Pages

  • Re: object level permissions being lost when migrating
    ... I first transferred the logins from the 2000 server to the 2005 server via ... I then restored the databases and re-synched the users via the ... Errors After Restoring Dump ...
    (microsoft.public.sqlserver.security)
  • Re: Move databases between servers
    ... What I'm trying to do now is to copy master. ... Now I'm reinstalling sql with identical version, and restore all databases ... Since the logins are in master and operators/agents are in msdb why I ... copy all database and log files to new server ...
    (microsoft.public.sqlserver.setup)
  • db_owners unable to see login list
    ... add new users to their databases, despite the fact that logins exist ... for these users on the server. ... look at the logins, the complete list is not presented to them. ... assign them to server-level security roles, ...
    (comp.databases.ms-sqlserver)
  • Re: Copying Databases From Server to Another
    ... Manager, for SQL Server instances, which takes care to move logins and msdb ... you can perhaps full backup and restore on the new server users databases... ... you could then script the logins out and recreate them on the destination ...
    (microsoft.public.sqlserver.msde)
  • Re: moving server to a new box
    ... for SQL Server ... There are> about 100 user databases with a lot of logins and jobs. ...
    (microsoft.public.sqlserver.server)