Dell POWEREDGE R515 Manual de usuario descargar pdf (Pagina 21)

Migrating to a Dell PowerEdge R515 server from two legacy database servers

3. While in SQL Server Management Studio, reset the database

access property to multi-user, and set the compatibility level to

SQL 2008 (level 100). See Appendix G for details.

4. Modify application connection strings or change Domain Name

System (DNS) pointers that reference the migrated database.

Moving your SQL Server 2005 database: performing the backup

The process for migrating your SQL Server 2005 databases is almost

identical to SQL Server 2000, with some exceptions in the newer

management tool, SQL Server Management Studio. Using the SQL

Server 2005 server, take the following steps to back up your

database. Backup times vary. Again, note that you must 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 2005 database, as we did

in Figure 9. See Appendix G for details.

1 2 ... 16 17 18 19 20 21 22 23 24 25 26 ... 44 45

Sin comentarios

Dell POWEREDGE R515 Manual de usuario Pagina 21