Hp XP Array Manager Software Manual do Utilizador Página 394

  • Descarregar
  • Adicionar aos meus manuais
  • Imprimir
Vista de página 393
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.
sp_replicationdboption 'database-name', 'sync with backup', 'true'
For the database-name argument, specify the name of the publication database or distribution database.
How to check the 'sync with backup' option
To ensure that the option has been set, execute the following SQL statement:
select databasepropertyex('database-name', 'IsSyncWithBackup')
For the database-name in the SQL statement, specify the name of the publication database or
distribution database.
When this SQL statement is executed, one of the following values is returned:
If the 'sync with backup' option has been set: 1
If the 'sync with backup' option has not been set: 0
Backing up and restoring in an SQL Server AlwaysOn
availability group configuration
When using Application Agent on an SQL Server in an AlwaysOn availability group configuration,
you can back up and restore user databases on the active node. Backing up and restoring system
databases or backing up and restoring user databases on the passive node are not supported.
System configuration
When using Application Agent on an SQL Server in an AlwaysOn availability group configuration,
you can perform the following:
1. Back up and restore user databases to the active server
2. Restore user databases to the standby server from the active server
3. Restore user databases to the secondary-use server from the active server
The following figure shows the system configuration. The numbers used in the figure correspond to
the numbers above.
Operation for SQL Server databases394
Vista de página 393
1 2 ... 389 390 391 392 393 394 395 396 397 398 399 ... 563 564

Comentários a estes Manuais

Sem comentários

Conceptronic C20-150 manuales

Manuales del propietario y guías del usuario para Hdd / ssd recintos Conceptronic C20-150.
Ofrecemos 1 manuales en pdf Conceptronic C20-150 para descargar gratis por tipos de documentos: Ficha de datos


Tabla de contenidos





Más productos y manuales para Hdd / ssd recintos Conceptronic

Modelos Tipo de documento
C20-258 Ficha de datos   Conceptronic 2,5" Harddisk Box Mini Violet USB powered, 3 paginas
C05-210 Ficha de datos   Conceptronic 3,5 inch USB hard disk box for SATA hard disk, 3 paginas
C05-500 Ficha de datos   Conceptronic 2,5 / 3,5 inch hard disk docking station eSATA/USB, 3 paginas
CHD3SATA Ficha de datos   Conceptronic Serial ATA External Hard disk box 3.5 “., 1 paginas
C10-393 Ficha de datos   Conceptronic Grab'n'GO 2.5” Hard Disk Box eSATA/USB 2.0, 3 paginas
C05-326 Ficha de datos   Conceptronic USB SATA HDD 2.5" BLACK USB powered, 3 paginas
C10-135 Ficha de datos   Conceptronic 3,5 inch USB/e-SATA hard disk box, 3 paginas
C05-106 Ficha de datos   Conceptronic USB 2.0 & Firewire Harddisk Box 3.5", 1 paginas
C05-324 Ficha de datos   Conceptronic 3,5 inch HardDiskBox DualBay, 3 paginas
C20-253 Ficha de datos   Conceptronic 2,5" Harddisk Box Mini Blue USB powered, 3 paginas
C05-209 Ficha de datos   Conceptronic 2,5 inch USB hard disk box for SATA hard disk, 3 paginas
CHD3U Ficha de datos   Conceptronic USB 2.0 Hard Disk Box 3.5", 1 paginas