HP Serveur lame HP ProLiant BL465c Gen8 - Manual (Page 394)

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 databases 394