Summing it all up – Dell R810 User Manual
Page 25
Servers: Database consolidation on Dell PowerEdge R810 servers
25
stored procedure, to view orphaned users and to
map a user to a login.
example of this process.
SQL Server Agent jobs
Almost all installations schedule SQL Server Agent jobs that run
against their databases. You must migrate these jobs to your new
SQL Server 2008 R2 server. Locate the jobs you need to migrate in
SQL Server Management Studio (on your SQL Server 2000 server)
under the SQL Server Agent, right-click them, and choose Script
Job As | Create To | New Query Window. Connect to the SQL
Server 2008 R2 server, and run the resulting script in a query
window.
Other external dependencies
Your pre-migration research may well have yielded a list of items
for you to implement now; the list might include references to file
shares, database mail or SQL Mail configurations, stored
procedures in system databases, and/or linked servers. Addressing
these external dependencies will ensure a smooth finish to your
migration.
Summing it all up
The Dell PowerEdge R810, powered by Intel’s latest generation
Xeon Processor 7500 series, offers a compelling case for
consolidation of your SQL Server resources from a legacy SQL
Server 2000 environment to a new environment with SQL Server
2008 R2. As this Guide has explained, ROI is provided in less than
1 year, application throughput increases, and power consumption
drops dramatically as a result of this migration. In addition, the
tools provided by SQL Server 2008 R2 simplify migrating your
databases. With careful planning, you can execute migrations with
little difficulty and with no interruption of service to users.