Download "user manual"

Migrating two legacy HP servers to one Dell PowerEdge T410
running Microsoft Windows Server 2008 R2
e. Click OK again to return to the Restore Database
screen (Figure 13). Check the Restore checkbox,
and click OK.
Figure 13. Restoring your selected database.
4. When the Restore of database completed successfully
screen appears, click OK.
5. While in SQL Server Management Studio, reset the
database access property to multi-user. See Appendix F
for details.
Transferring 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
Microsoft SQL Server 2008 server. Locate the jobs you need to
migrate in SQL Server Management Studio (on your Microsoft SQL
Server 2005 server) under the SQL Server Agent, right-click each
one, and select Script Job AsCreate ToNew Query Window.
Connect to the SQL Server 2008 server, and run the resulting
script in a query window.
39