Hp XP Command View Advanced Edition Software Manuel d'utilisateur Page 394

  • Télécharger
  • Ajouter à mon manuel
  • Imprimer
  • Page
    / 574
  • Table des matières
  • DEPANNAGE
  • MARQUE LIVRES
  • Noté. / 5. Basé sur avis des utilisateurs
Vue de la page 393
1. Back up the user database.
On the database server (active server), execute the drmsqlbackup command with the -target
or -f option specified.
To execute the drmsqlbackup command with the -target option specified:
PROMPT> drmsqlbackup instance-name -target user-database-name
To execute the drmsqlbackup command with the -f option specified:
PROMPT> drmsqlbackup instance-name -f target-definition-file-name
2. Back up the user database transaction logs.
On the database server (active server), execute the drmsqllogbackup command.
PROMPT> drmsqllogbackup instance-name
3. Use a tool such as SQL Server Management Studio to delete the AlwaysOn availability group
configuration for the database server (active server).
4. Restore the user database.
On the database server (active server), execute the drmsqlrestore command.
PROMPT> drmsqlrestore backup-ID -resync -target user-database-name
5. Recover the SQL Server database.
On the database server (active server), execute the drmsqlrecover or drmsqlrecovertool
command.
To execute the drmsqlrecover command for recovery:
PROMPT> drmsqlrecover instance-name
To execute the drmsqlrecovertool command for recovery:
PROMPT> drmsqlrecovertool instance-name
6. Use a tool such as SQL Server Management Studio to create the AlwaysOn availability group
configuration for the database server (active server).
Restoring a user database to the standby server from the active server
To restore a user database to the standby server from the active server:
Operation for SQL Server databases394
Vue de la page 393
1 2 ... 389 390 391 392 393 394 395 396 397 398 399 ... 573 574

Commentaires sur ces manuels

Pas de commentaire