Moving SQL Objects

Hi Everyone,
We've setup a new server to be used for SQL Server. I'm using scripts to tr
ansfer all of the components. I was wondering what would be the best order
in which to transfer the objects: databases, jobs, alerts, operators, login
s. Is there an order in wh
ich 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 acce
ss and roles are not following along.
Thanks in advance.
LarryIt 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|||I would transfer the logins, databases, operators, then jobs and alerts.
The reason I say this is this way all logins will be created prior to any
objects being created that depend on logins being available. I also would
do operators first, since jobs or alerts might need to operators created
first if they send messages to operators.
As far as the roles for logins, they are mainly in the databases. Although
you could have server roles assigned. I don't know of a method to script
the server roles.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"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