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

  • Télécharger
  • Ajouter à mon manuel
  • Imprimer
  • Page
    / 580
  • Table des matières
  • DEPANNAGE
  • MARQUE LIVRES
  • Noté. / 5. Basé sur avis des utilisateurs
Vue de la page 397
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 databases398
Vue de la page 397
1 2 ... 393 394 395 396 397 398 399 400 401 402 403 ... 579 580

Commentaires sur ces manuels

Pas de commentaire