38
Migrating to a Dell PowerEdge R515 server from two legacy database servers
APPENDIX G – MIGRATING DATABASES
In this appendix, we give detailed instructions about a basic side-by-
side migration of a user database from a SQL Server 2000 or SQL
Server 2005 server to a SQL Server 2008 R2 virtual server. There are
multiple methods of accomplishing this task, including using TSQL
commands and automated tools. Here, we discuss performing the
database migration using the graphical interface tools Microsoft
provides with SQL Server 2000, SQL Server 2005, and SQL Server 2008
R2.
Backing up a SQL Server 2000 database
1. Log into the SQL Server 2000 server as either an administrative
user or a user with full rights on SQL Server 2000.
2. Start Enterprise Manager by selecting StartAll
ProgramsMicrosoft SQL ServerEnterprise Manager.
3. Expand Microsoft SQL ServersSQL Server Group(local)
(Windows NT)Databases.
4. Set the database to single-user mode to ensure no updates occur.
Right-click the database, and choose properties. Click the Options
tab, check the Restrict Access checkbox, and choose Single User.
NOTE: Setting the database to single-user mode immediately
disconnects all users. You must notify your users well in
advance of setting the database to single-user mode.
5. Right-click the database, and select All TasksBackup Database.
6. Keep the default of complete backup.
7. Click Add… to add a backup device, and click the “…” button to
browse to the backup location you want to use. Select a folder,
and enter a filename, such as
DatabaseNameMigrationBackup.bak.
8. Click OK to close the Backup Device Location window, and click OK
to close the Select Backup Destination window.
NOTE: To simplify moving the database later, we recommend
creating the backup in a shared local folder.
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales