Hp XP Command View Advanced Edition Software Uživatelský manuál Strana 396

  • Stažení
  • Přidat do mých příruček
  • Tisk
  • Strana
    / 574
  • Tabulka s obsahem
  • ŘEŠENÍ PROBLÉMŮ
  • KNIHY
  • Hodnocené. / 5. Na základě hodnocení zákazníků
Zobrazit stránku 395
7. Confirm that the backup information file has been imported correctly.
On the database server (standby server), execute the drmsqlcat command.
PROMPT> drmsqlcat instance-name
8. Restore the user database.
On the database server (standby server), execute the drmsqlrestore command.
PROMPT> drmsqlrestore backup-ID -no_resync -nochk_host -target user-database-name
9. Recover the user database.
On the database server (standby server), execute the drmsqlrecovertool command.
PROMPT> drmsqlrecovertool instance-name
When the command is executed, the drmsqlrecovertool dialog box opens.
Specify the following conditions, and then click the Recovery button in the drmsqlrecovertool
dialog box.
Click the Add button to select all the transaction log backup files.
Select Loading for Recovery mode.
Select Yes for Roll forward?.
10. Use a tool such as SQL Server Management Studio to create an AlwaysOn availability group
configuration for the database server (active and standby servers).
Restoring a user database to the secondary-use server from the active server
To restore a user database to the secondary-use server from the active server:
1. When the secondary-use server is set for the database server (active server), delete the AlwaysOn
availability group configuration for the secondary-use server.
2. Detach the user database on the secondary-use server (active server).
3. On the secondary-use server (active server), perform the following:
1. Stop the SQL Server instance.
2. Unmount the file system from the secondary volume.
3. Place the disk of the secondary volume offline.
Operation for SQL Server databases396
Zobrazit stránku 395
1 2 ... 391 392 393 394 395 396 397 398 399 400 401 ... 573 574

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

Žádné komentáře