Dell POWEREDGE R515 Bedienungsanleitung PDF herunterladen (Seite 39)

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

9. 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.

10. Click OK to begin the SQL Server 2000 database backup. (Backup

times vary with database size and backup device configuration.)

11. After the backup completes, in Enterprise Manager, under

Databases, right-click the database, and choose All TasksTake

Offline. The old database is now offline, so SQL Server 2000 will

not allow any connections to it.

12. Log out of Windows on the SQL Server 2000 server.

Backing up a SQL Server 2005 database

1. Log into Windows on the SQL Server 2005 server as either an

administrative user or a user with full rights on SQL Server 2005.

2. Start SQL Server Management Studio by selecting StartAll

ProgramsMicrosoft SQL Server 2005SQL Server Management

Studio.

3. Enter your server name, and select Windows Authentication.

4. Set the database to single-user mode to ensure no updates occur.

NOTE: Setting the database to single-user mode immediately

disconnects all users, causing them to lose any work in

progress. You must notify your users well in advance of setting

the database to single-user mode.

5. To set the database to single-user mode, in Object Explorer, right-

click the database, and choose properties.

6. Click Options, and scroll to the State section.

7. For the Restrict Access setting, choose SINGLE_USER, and click OK.

Click Yes when prompted that other connections will be cut off.

8. Right-click the database, and choose Tasks, Back Up.

9. 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.

10. 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.

1 2 ... 34 35 36 37 38 39 40 41 42 43 44 45

Keine Kommentare

Dell POWEREDGE R515 Bedienungsanleitung Seite 39