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

  • 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 393
Restore the databases
Restore the publication database
Specify the backup ID used when the publication database and the distribution database were
backed up, and execute the drmsqlrestore command on the publisher/distributor server.
PROMPT> drmsqlrestore 0000000001 -resync
PROMPT>
If you are specifying the backup ID used when backing up the databases, including the system
databases, specify the publication database and the distribution database in the -target option
or -f option and execute the drmsqlrestore command.
PROMPT> drmsqlrestore 0000000005 -resync -target PubUserDB1,distribution
PROMPT>
Restore the publication database and the system databases
The following procedure must be followed to restore the publication and system databases on the
publisher/distributor server.
1. Restore the system databases
PROMPT> drmsqlrestore 0000000005 -resync -target master,model,msdb
PROMPT>
2. Stop the log reader agent.
3. Stop the agent associated with subscription.
A subscription synchronous stop is performed.
NOTE:
If the log reader agent start option is set to Automatically startup during SQL
Server agent startup, the log reader agent will be started after the master, model,
and msdb databases are restored, and an error will occur when the publication database
and distribution database are restored.
4. Restore the publication database and distribution database.
PROMPT> drmsqlrestore 0000000005 -resync -target
PubUserDB1,distribution
PROMPT>
Operation for SQL Server databases394
Vue de la page 393
1 2 ... 389 390 391 392 393 394 395 396 397 398 399 ... 579 580

Commentaires sur ces manuels

Pas de commentaire