Re: Moving SQL objects

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 07/13/04 

Date: Tue, 13 Jul 2004 09:43:33 -0500

It does not really matter what order you transfer things. You mentioned
that you followed the directions within
http://support.microsoft.com/?id=246133. The users and the permissions
should be correct after everything is up-and-running. If not, you could try
sp_change_users_login.

You mentioned that you are using scripts to transfer all "components." I am
not sure what you mean, but you might be able to use a variety of methods to
move the various objects.

Here are some other links that you may find helpful:

INF: Disaster Recovery Articles for Microsoft SQL Server
http://www.support.microsoft.com/?id=307775

INF: Moving SQL Server databases to a new location with Detach/Attach
http://www.support.microsoft.com/?id=224071

HOW TO: Move Databases Between Computers That Are Running SQL Server
http://www.support.microsoft.com/?id=314546

INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/?id=221465

PRB: User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001

HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133

PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://www.support.microsoft.com/?id=274188

How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872

SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://www.support.microsoft.com/?id=298897

Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp 

-- 
Keith
"Larry" <Larry@discussions.microsoft.com> wrote in message
news:36682070-3D87-4DFA-B95F-0E53053F370B@microsoft.com...
> Hi Everyone,
>
> We have a new dedicated server for SQL operations.  I'm moving all of the
objects over to the new server:  databases, jobs, alerts, operators, logins.
While testing the transfer, I noticed that the logins do not have the access
to the databases and roles are not set.  Considering I used the stored
procedure in KB article 246133, it should have kept the same database
accesses and db roles.  Any ideas on this one?
>
> Should I be moving these objects in a specific order for more accurate and
optimal results?  Does it make a difference?
>
> Thanks in advance.
>
> Larry

Relevant Pages

  • Re: Server Migration...
    ... The logins are in the master DB and the DTS packages are in msdb. ... Columnist, SQL Server Professional ... database between server including all Systems Databases, ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server Logins do not have database access
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... created all user logins before restoring the databases. ... A few users are SQL Server logins. ...
    (microsoft.public.sqlserver.security)
  • Re: Moving SQL Objects
    ... Moving SQL Server databases to a new location with Detach/Attach ... Transfer Logins and Passwords Between Instances of SQL Server ... How to Resolve Permission Issues When a Database Is Moved Between SQL ...
    (microsoft.public.sqlserver.server)
  • Re: How to I get a list of databases?
    ... But don't you have to have permission to access master.dbo.sysdatabases? ... was able to deduce which databases I can access. ... Depending on the version of SQL Server you are using, ... find any sample ADOX code for getting a list of databases on a server ...
    (microsoft.public.inetserver.asp.db)
  • Re: URGENT (again) :-)
    ... the system databases are special... ... > Using WITH MOVE in a Restore to a New Location with Detach/Attach ... > How To Transfer Logins and Passwords Between SQL Servers ... > Disaster Recovery Articles for SQL Server ...
    (microsoft.public.sqlserver.setup)