Dell POWEREDGE R515 Uživatelský manuál Strana 19

  • Stažení
  • Přidat do mých příruček
  • Tisk
  • Strana
    / 45
  • Tabulka s obsahem
  • KNIHY
  • Hodnocené. / 5. Na základě hodnocení zákazníků
Zobrazit stránku 18
19
Migrating to a Dell PowerEdge R515 server from two legacy database servers
Side-by-side migration
In this section, we provide an overview of the processes involved in
migrating your database from either SQL Server 2000 or SQL Server
2005 to a virtualized SQL Server 2008 R2 environment on the Dell
PowerEdge R515. We provide detailed instructions in Appendix G.
We performed all SQL Server 2000 administration using Query
Analyzer and Enterprise Manager, the two main tools in the SQL
Server 2000 environment. Likewise, we performed all administration
for the SQL Server 2005 and SQL Server 2008 R2 installations using
SQL Server Management Studio, the main administration interface for
those versions.
NOTE: Various methods exist for migrating databases between
instances and versions of SQL Server, including detach/attach,
backup/restore, and the copy database wizard. We chose to use the
backup/restore method because most businesses will have a backup
routine in place, and administrators will be familiar with the process.
Moving your SQL Server 2000 database: performing the backup
Using the SQL Server 2000 server, take the following steps to back up
your database. Backup times vary. Note that you should do any
special planning in advance to minimize your downtime window.
1. To keep users from issuing updates during the migration process,
you can either set the database to read-only mode or set the
access property to SINGLE_USER. Both choices immediately sever
all user connections. See Appendix G for details on setting the
database to single-user mode.
2. Perform a full backup of your SQL Server 2000 database, as we did
in Figure 8. See Appendix for details. G
Zobrazit stránku 18
1 2 ... 14 15 16 17 18 19 20 21 22 23 24 ... 44 45

Komentáře k této Příručce

Žádné komentáře