Hp XP Command View Advanced Edition Software Manual de usuario Pagina 391

  • Descarga
  • Añadir a mis manuales
  • Imprimir
  • Pagina
    / 574
  • Tabla de contenidos
  • SOLUCIÓN DE PROBLEMAS
  • MARCADORES
  • Valorado. / 5. Basado en revisión del cliente
Vista de pagina 390
Specify the backup ID used when the databases, including the system databases, were backed
up, and execute the drmsqlrestore command on the publisher/distributor server or the subscriber
server.
PROMPT> drmsqlrestore 0000000005 -resync -target master,model,msdb
PROMPT>
Restore the subscription database
On the subscriber server, execute the drmsqlrestore command.
PROMPT> drmsqlrestore 0000000002 -resync -target SubUserDB1
PROMPT>
Perform database recovery
Use the drmsqlrecover command or the drmsqlrecovertool command to perform a recovery
(roll forward) by using the normal procedure.
Prepare to restart operations
The following must be prepared in order to restart SQL Server replication operations:
The server that performs these operations will depend on the subscription format, as follows:
Push subscription: Publisher/distributor server
Pull subscription: Subscriber server
1. Start the log reader agent.
2. Start the agent associated with subscription.
Synchronous subscription is started.
3. Perform subscription re-initialization or deletion and re-creation.
Setting and checking the 'sync with backup' option
When the SQL Server replication function is used, the 'sync with backup' option must be set for
the publication database and the distribution database.
When backup is performed on the publication database transaction logs with the 'sync with
backup' option set, the backup is forwarded to the distribution database. Also, no publication
database logs will be dropped until all transactions are forwarded to the distribution database.
How to set the 'sync with backup' option
When creating the replication environment, execute the following stored procedure on the production
database and distribution database. For details about how to execute stored procedures, see SQL
Server Books Online.
Application Agent CLI User Guide 391
Vista de pagina 390
1 2 ... 386 387 388 389 390 391 392 393 394 395 396 ... 573 574

Comentarios a estos manuales

Sin comentarios