24
Migrating to a Dell PowerEdge R515 server from two legacy database servers
To transfer logins, take the following steps on the SQL Server 2008 R2
virtual machine. Note that steps 1 through 6 apply to both Windows
logins and SQL Server logins, while Step 7 refers solely to SQL Server
logins.
1. Log into the virtual machine.
2. In SQL Server Management Studio, in the Object Explorer pane,
connect to both your SQL Server 2000 server and your SQL Server
2008 R2 virtual server. Be sure to have the Object Explorer Details
tab open (ViewObject Explorer Details).
3. Expand the tree view of the SQL Server 2000 server, browse to
the Security tab, and click the Logins node. In the Object Explorer
Details, you will now see a list of all logins on the SQL Server 2000
server.
4. If necessary, use the sorting and filtering options in the Object
Explorer Details tab, and take note of which logins you would like
to migrate. Select them by clicking; use the standard Windows
controls (Ctrl key, Shift key, etc.) to select multiple logins.
5. Right-click the logins you selected, and choose Script Login
AsCreate ToNew Query Window. Be sure to change the
connection of this new query window to connect to your new SQL
Server 2008 R2 virtual server by right-clicking and selecting
Change Connection.
6. Execute the script on your SQL Server 2008 R2 virtual server to
create the logins. If you are transferring Windows-based logins,
the process is complete. If you are transferring SQL Server logins,
continue with Step 7.
7. For SQL Server logins, the script you executed in Step 6 creates
the login, marks it as disabled, and assigns it a random password,
but the script does not map the login to the database user. To
avoid having a database user that is “orphaned” from a login, use
the sp_change_users_login stored procedure, to view orphaned
users and to map a user to a login. Appendix I provides an
example of this process.
SQL Server Agent jobs
Almost all installations schedule SQL Server Agent jobs that run
against their databases, such as backups, index rebuilds, and other
maintenance items. You must migrate these jobs to your new SQL
Server 2008 R2 virtual machine. Log into the virtual machine, open
SQL Server Management Studio, and connect to your older SQL
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Kommentare zu diesen Handbüchern