40
Migrating to a Dell PowerEdge R515 server from two legacy database servers
11. Optionally, on the Options tab, select the checkbox to verify your
database backup upon completion.
NOTE: This option increases backup time but checks the
integrity of the backup file. We chose to verify the backup.
12. Click OK to begin the SQL Server 2005 database backup. (Backup
times vary with database size and backup device configuration.)
13. After the backup completes, in SQL Server Management Studio,
under Databases, right-click the database, and choose All
TasksTake Offline. The old database is now offline, so SQL
Server 2005 will not allow any connections to it.
14. Log out of Windows on the SQL Server 2005 server.
Restoring a database to SQL Server 2008 R2
1. Transfer either your SQL Server 2000 or SQL Server 2005 backup
file to the virtual machine.
2. Log into Windows on the virtual machine running SQL Server 2008
R2.
3. In Windows Explorer, navigate to backup folder location.
4. Open SQL Server Management Studio by selecting StartAll
ProgramsMicrosoft SQL Server 2008 R2SQL Server
Management Studio.
5. Select Database Engine for Server type, and type the server name
in Server name. For Authentication, we used Windows
Authentication.
6. In the Object Explorer pane, right-click Databases, and select
Restore Database.
7. Enter the name of the database in the To database box.
NOTE: It is critical to use the same database name as on your
SQL Server 2000 or SQL Server 2005 server. If the database
name does not match, applications that depend on the
database name may break.
8. Click the From device button, and click the “…” button to browse
to the local folder where you copied the backup file.
9. To add the backup file location, click Add. Browse to the
appropriate folder, find the backup file, select it, and click OK.
10. To return to the Restore Database window, click OK.
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Kommentare zu diesen Handbüchern