Re: Moving SQL Objects

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

Date: Tue, 13 Jul 2004 09:43:02 -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:3AA43999-8696-42CD-BA63-6005479C5F3D@microsoft.com...
> Hi Everyone,
>
> We've setup a new server to be used for SQL Server.  I'm using scripts to
transfer all of the components.  I was wondering what would be the best
order in which to transfer the objects:  databases, jobs, alerts, operators,
logins.  Is there an order in which these should be done for the most
accurate and optimal results?  Does it matter?  I noticed that when I
transfer the logins, the users database access and roles are not following
along.
>
> 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: 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)
  • 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)